|
-
July 15th, 2010, 10:30 AM
#1
Group by Date in Crystal reports
Hi all,
I am trying to group by a date column on my crystal report command object. I find couple of issues here:
1) the grp name which Crystal generates automatically is different from teh actual value of the date coming from the database.
2) The dates are not grouped correctly. Two different dates are seen in one group.
For eg. Grp by join_date and the date 6/30/2010 and 6/29/2010 are grouped into one group and the group name is 6/26/2010.
Because of the improper grouping the totals are messed up. Any idea as to what is happening here? Is this a bug in CR? Any suggestion is appreciated.
Thnx!
CR Version - 11.5.8.826
-
August 10th, 2010, 07:45 AM
#2
Re: Group by Date in Crystal reports
Hopefully you have solved the issue if not then
On Group Options Dialog there is a drop down on the end labeled "The section will be printed"
By default it is selected for each week change it to for each day or for each second
If this post is helpful, then, Rate this Post. 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|