Solved

Crystal Chart and Month Number vs. Month Name

Posted on 2006-10-20
3
1,070 Views
Last Modified: 2008-01-16
Experts-

I have a chart which displays monthly information on the X axis.

If in Chart Expert, I show SUM values at the change of month number and City, it sequences my data correctly (1,2,3...), representing Jan, Feb, Mar.

If in Chart Expert I change the SUM to be at the change of month name and City, it 'incorrectly' sequences data by the month's alphabetical order (April, December, February, ...)

How can I order my X axis data by month number, but display the month name on the X axis. I see there's a Chart Sort Order with a formula option. Is there something here I can use? Also, the number of months will be dynamic at run-time. Sometimes it will be the first six months of the year, other times it will be the full 12 months.

Thanks
0
Comment
Question by:DataDesignIT
  • 2
3 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 17780584
In the Chart expert when change the SUM to be at the change of month name and City
Select the Month field
Click ORDER button
Change the order choose SPECIFIED ORDER.  You will then be asked to provide the order.

mlmcc
0
 

Author Comment

by:DataDesignIT
ID: 17780674
Awesome! Thanks.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 17780944
Glad i could help

mlmcc
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question