Showing results for 
Search instead for 
Did you mean: 

Passing parameters to reports in a schedule

Former Member
0 Kudos


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


Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You also have to make sure that the time settings on your database server is in synch with your crystal reports server.

Former Member
0 Kudos

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




Former Member
0 Kudos


Thanks for the reply