Print Page | Close Window

Month sort

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16133
Printed Date: 02 May 2025 at 5:40pm


Topic: Month sort
Posted By: Gymnast
Subject: Month sort
Date 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


Replies:
Posted By: lockwelle
Date 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


Print Page | Close Window