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
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