Passing parameters to reports in a schedule

[Former Member]

Hi,

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

Naveen

[Former Member]

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

[Former Member]

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"

CurrentDate

and this will find you the current date and time

CurrentDateTime

HTH,

Jason

[Former Member]

Jason,

Thanks for the reply

naveen