Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Month sort Post Reply Post New Topic
Author Message
Gymnast
Newbie
Newbie
Avatar

Joined: 26 Mar 2012
Location: United States
Online Status: Offline
Posts: 7
Quote Gymnast Replybullet Topic: Month sort
    Posted: 10 Apr 2012 at 7:04am
I am re-posting this.

I have grouped my data based on the month. This is grouped based on the parameter date range. The problem is that when the group is displayed in the drill down (grouping) section in the report the months are sorted by the Month first and then by Year (3/2011, 3/2012 and so on) rather than by Year and then by Month (3/2011, 4/2011 and so on). Trying to customize the group header does not seem to make any difference.

Any help is appreciated.

Thanks
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 10 Apr 2012 at 1:38pm
create a formula like:
 
totext({table.dateField}, "yyyy\MM")
 
then group on the formula, and display the date that you want
 
should work...
 
HTH
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.031 seconds.