View Full Version: Crystal Dates As Grouping

LawsonTalk > Reporting (NEW!!) > Crystal Dates As Grouping



Title: Crystal Dates As Grouping
Description: Dates change when used in Group header


vc727 - April 10, 2008 05:00 PM (GMT)
I am not sure if it just me but I am working on a pay period report using the PRTIME table and when I group by PER_END_DATE the date that it uses in the header is 7 days prior to the date in the PER_END_DATE field. so if I have a bunch of records with PPE date of 02/02/2008 the header on the report for there records reads 1/27/2008. I am not sure what i have done.

Any thoughts?

mike - April 14, 2008 05:19 PM (GMT)
That is strange. I was able to duplicate it and was baffled at first. The fix is to go into Report | Group Expert, select the group in the right pane of the dialog, and click the Options button at the bottom.

Change the value in the "The section will be printed" list from "for each week" to "for each day". (This is in CR10, it may be different in your version.)




Hosted for free by InvisionFree