A report subscription is a report snapshot generated on some defined scheduled time and delivered to the intended viewers by the report server.
SSRS allows us to create two types of subscriptions, e.g., standard subscriptions and data-driven subscription.
SSRS has provided two delivery extensions out of the box; the first one lets SSRS save the report subscription to a file share location whereas the second one sends the report in email to the specified recipients. There is one more extension; if you have SSRS installation in Share Point Integrated mode, which delivers the report to a Share Point document library.
Report Subscription
To setup subscription for a report, go to Report Manager, navigate to the folder that contains the report, point to the report for which you want to set up a subscription, click on the report as shown below:
On the report page, click on Subscriptions on the top
This will show the options; New Subscription; Click on New Subscription
When you click on the New Subscription link on the page shown above, it will bring up a page with two parts. In the first part you can define the report delivery method and in the second part you can specify subscription processing options. The Report Delivery Options section will change depending on the delivery method you choose.
For example as you can see below, I have chosen a delivery method of E-Mail and hence it has options to specify TO, CC, BCC, subject line, whether to include the report as link or as an attachment, etc.
If i change the delivery method to Windows File Share, the fields on screen will change to let us specify the file name, share location, credential to use to copy the file at that location, overwrite options, etc.
The second part of the screen is used to define the subscription processing options. Generally, we can specify two settings here. First define a schedule for the subscription to process and second you specify the parameter values to be used during processing of the reports.
Once created, we can view the subscription and its execution details in the subscription detail page as shown below. You can click on the Edit hyperlink to modify the subscription or select a subscription and click on the Delete button to delete it.
