[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Crystal Chart and Month Number vs. Month Name

Posted on 2006-10-20
3
Medium Priority
?
1,148 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

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. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

650 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