Writing Code
 Crystal Reports Forum : Crystal Reports .NET 2003 : Writing Code
Message Icon Topic: Date Format 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: Date Format
    Posted: 10 Apr 2012 at 6:22am
I have grouped my dates based only on the Months of the year namely, 3/2011, 4/2011.. and so on.  The issue is that when the group consists of months spanning over a couple of years - say between 3/2011 and 4/2012, in the grouping/drill down area of the report, the months are sorted by the Month and then by Year (3/2012 after 3/2011) instead of grouping by Year first and then by Month (3/2011, 4/2011).  I tried to get only the month in the DatePart fomula in the Formula Workshop (to customize the group name).  But I still get the same sorting.  Can someone help, please?
 
Thanks.
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 25 Oct 2012 at 7:51am
create a forula to group by, that has a combo of both the month+year
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.