Which database are you using? If Crystal allows it for your db, you could add a command text with something like the following SQL ("sysdate" is the current date in Oracle, it may be different in other db's):
Select max(End_Date)
from tblPayrollEndDates
where End_Date <= sysdate
You would then use that value as the parameter to your subreports.
-Dell
IP Logged
