Print Page | Close Window

Date Format

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Writing Code
Forum Discription: .NET 2003 programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16131
Printed Date: 12 Aug 2020 at 8:00am


Topic: Date Format
Posted By: Gymnast
Subject: Date Format
Date 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.



Replies:
Posted By: comatt1
Date Posted: 25 Oct 2012 at 7:51am
create a forula to group by, that has a combo of both the month+year



Print Page | Close Window