Sunday, February 19, 2012

Execution Snaption parameters

I am setting up an execution snapshot to run a query every day at 2:00 am to run a long query and store the report as a snapshot.

My question is my two parameters are Starting Date and Ending Date. I want the parameters to have the value of the previous date (being that the report is run at 2:00 am). Is is possible to set up an expression such as =today-1 for these parameters?

Thanks for the information.

that's true, = Today - 1 will be easy

I suppose set the "default" value for BeginDate to a DataSet query
where you select the previous date in the query?
SELECT getdate() - 1|||Thanks...that worked and I did not even think about applying the query actually as the default report parameter.

No comments:

Post a Comment