I have a report that gives out some user statistics for a given period. It accepts 2 parameters start time and end time. What I want to do is schedule this report every night and pass the start time and end time as the previous day to the current day.
How can i pass the start time and end time dynamically using Crystal Reports Server 2008 version
Thanks in advance
You can't. If you want to schedule the reports you'll need to replace the parameters with formulas.
This will find you the "Start of Yesterday"
DateAdd("d", -1, CurrentDate)
This will find you "The End of Yesterday" / "Start of Today"
and this will find you the current date and time