August 17, 2015 at 2:25 pm
I would like to create a report in SSRS so when it’s done running automatically I can send a link to all the user to view the report and it won’t re-run the report when they click of the link it will allow them to view it only. Is that a matter of going into the “Subscriptions” tab -> Edit and just checking the “Include Link”. This is for in SQL 2012 & SQL 2005.
August 17, 2015 at 7:26 pm
Unless the report returns a data source that doesn't change often (like a data warehouse that refreshes once a day), sending users the link doesn't guarantee that the report won't contain different data when they click on it. If they click on the link a day or two later, it almost certainly will have changed, unless they're querying, say, financial data from the last full month, which shouldn't have changed.
The only way to absolutely guarantee that they receive data from the point in time that the subscription runs is to attach the data to the email in CSV, Excel or PDF format (or another that suits their needs).
August 18, 2015 at 1:47 pm
So if i have a hundred users who want the report than that a hundred reports which is going out oppose one report going to a central location with an email message going out to the hundred users saying click on the link to view the report.
August 18, 2015 at 7:08 pm
I guess you could create a report snapshot and expire it after some reasonable amount of time (depending on how often you need the data in the report refreshed). Then you could create an e-mail subscription and add a link to the report, so when the user received the e-mail, clicking on the link would open the cached report.
August 18, 2015 at 11:31 pm
kd11 (8/18/2015)
So if i have a hundred users who want the report than that a hundred reports which is going out oppose one report going to a central location with an email message going out to the hundred users saying click on the link to view the report.
When you create a subscription, you can also save the exported data to a file location and include that link in the email, rather than having the subscription email everyone a copy of the export. You just have to change Delivered By option. I've attached an image showing this.
August 20, 2015 at 1:01 pm
Thank you, that was helpful.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply