Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Report Design
Message Icon Topic: Months order in chart Post Reply Post New Topic
Author Message
barry.ein
Newbie
Newbie
Avatar

Joined: 18 Feb 2015
Location: Israel
Online Status: Offline
Posts: 7
Quote barry.ein Replybullet Topic: Months order in chart
    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
IP IP Logged
Valert16
Groupie
Groupie
Avatar

Joined: 21 Mar 2016
Location: Spain
Online Status: Offline
Posts: 48
Quote Valert16 Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.043 seconds.