Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Crystal Chart and Month Number vs. Month Name

Posted on 2006-10-20
3
Medium Priority
?
1,158 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 101

Accepted Solution

by:
mlmcc earned 2000 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 101

Expert Comment

by:mlmcc
ID: 17780944
Glad i could help

mlmcc
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

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…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

571 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