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 easyI 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