SSRS Subscription with Parameters
Posted on 2013-01-23
I have a report in SSRS that shows data that has been updated and I need to set a parameter that gets the last update (this is being run daily) and a subscription that runs daily but if there are no updates then do not send report.
Presently, I only have an update that is timestamped last week so I cannot test for =today() because this throws an error (and I cannot change the timestamp or create a table). Pls explain how to set the parameter so that it gets the days' updates.
Also, How can I set up the subscription? Do I copy the SSRS query to the query text box in subscription area to run the report?
I am a bit confused on these processes - just started using SSRS.