Print Page | Close Window

Months order in chart

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22654
Printed Date: 28 Mar 2024 at 11:01am


Topic: Months order in chart
Posted By: barry.ein
Subject: Months order in chart
Date Posted: 07 Aug 2018 at 2:43am
Hi,
I want to show "MMM-yy" in the X axis of a bar chart in the months/years order and not in alpha order.
Thanks.
Barry



Replies:
Posted By: Valert16
Date Posted: 15 Aug 2018 at 11:20pm
Not sure if this applies here. But I think it's the usual approach to this issue.

The solution implies creating a cross-tab. Group by date (month) and use a formula as group name. The formula simply returns the date formatted as "MMM-yy". Use the same summarized field you want in the chart. Place this cross-tab in a section, and hide it.

Finally create your chart in another section using the cross-tab option. This way, the graph shows the X axis with the right format and the month order is also correct.



Print Page | Close Window