Menu
I have a report in SQL Server Reporting Services (SSRS) that I'd like to schedule to run automatically as an email. I'd like the report to be attached as Excel file.
According to the Microsoft overview this should be possible.
Report delivery. SQL Server Reporting Services supports both on-demand (pull) and event-based (push) delivery of reports. Users can view reports in a Web-based format or in e-mail.
However I can't find any information on how to actually do this. Does anyone know what tools should be used or where there is a good tutorial?
Thanks!
841
SSRS report parameters are easily handled in PBRS. Simply enter the desired value for the report parameter, or select it from the drop-down list. PBRS will automatically run the report for the given parameter each scheduled time.
You can: Schedule report delivery in a standard or data-driven subscription. Schedule report history so that new snapshots are added to report history at regular intervals. Schedule when to refresh the data of a report snapshot.
Standard and data-driven subscriptions Reporting Services supports two kinds of subscriptions: standard and data-driven. Standard subscriptions are created and managed by individual users.
When you browse to the report in your reporting services site you should see a tab for Subscriptions. That's where you'd specify the recipients and delivery methods for automated delivery.
Here's a page that describes the process.
195
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
