I have created a report and scheduled it to run every Saturday evening during non-peak processing time. I am selecting the most current pay record per emplyee from PAYMASTR. If that record was issued within the last pay period (1 wk), then the employee has received pay and will be HIDDEN on the report. If the record is older than that, then the employee did not receive pay and will DISPLAY on the report.
if {PAYMASTR.CHECK_DATE} >= DateAdd("d", -7, CurrentDate) then {PAYMASTR.GROSS_PAY} else 0
The report works perfectly. It is published to Crystal Enterprise. My problem is in looking back at older versions of the report in CE. Apparently, when you select to view an instance of a report from HISTORY that ran several weeks ago (anytime), the values in the report CHANGE based on TODAY's current date, not on what was the current date when the report originally ran. Therefore, a report that ran last month showed 5 employees that did not receive pay during that week. When I look at that very same instance of the report now, it shows that 2200 employees did not receive pay that week! It appears that the report recomputes values every time you open it and to CE, CurrentDate is always today! Is there any way to freeze the values in the historical reports to be what they were at the time the report actually ran??
Use datadate instead of current date. This will display the date the rpeort ran and not today's date.
Hth,
Ruma.
That's perfect! Thank you.