Why does a Group field in the Group Header has incorrect value?
Attached is a report created by Crystal Reports.
I am using Crystal Reports 2011.
A dataset is used as a DataSource for the report.
The problem is the group field for MA_CL_DATE in the Group Header has the incorrect value.
Note the Criteria in the report indicates a date range From 09/02/14 To 09/03/14.
All the rest of the Group fields are correct.
MA_CL_DATE is suppose to be 09/03/14 but is shown as 08/31/14.
Why would the Group field have an incorrect value?
Is there a bug in Crystal Reports 2011 that causes this?
What can be done to resolve this?
Abhilash Kumar replied
Go to the Group Expert > Highlight the date field > Options > where it says 'the section will be printed' choose 'For Each Day'.
By Default CR prints for each week when grouped on date field and that's why you see dates that are not in the database/range.