Report Subscription(Windows File Share Delivery) in SSRS

Report Subscription(Windows File Share Delivery) in SSRS

A subscription is a standing request to deliver a report at a specific time or in response to an event, and in an application file format that you specify in the subscription. Subscriptions provide an alternative to running a report on demand. On-demand reporting requires that you actively select the report each time you want to view the report. In contrast, subscriptions can be used to schedule and then automate the delivery of a report.

In this article, I will show you how to use Report Subscription(Windows File Share Delivery) in SSRS.

1. First of all open Internet Explorer and go to Report Manager URL which is something  like below:

http://bhushan-pc/Reports2012

Your internet explorer tab looks like below :

1-Report Subscription(Windows File Share Delivery) in SSRS

2. Click on your SSRS project. In my case it is Start SSRS. So now it will show you list of reports which are deployed on your report server.

2-Report Subscription(Windows File Share Delivery) in SSRS

3. Now click on down arrow on the report which you want to subscribe and select Manage as shown in below screen shot.

3-Report Subscription(Windows File Share Delivery) in SSRS

4. Then select Subscriptions from left pane and Click on New Subscription as shown in below screen shot.

4-Report Subscription(Windows File Share Delivery) in SSRS

5. In next screen, select Windows File Share in list of Delivered By.

5-Report Subscription(Windows File Share Delivery) in SSRS

6. Then specify Network Path on which you want to save your report. In my case it is \\BHUSHAN-PC\Bhushan Reports.

Also specify render format in which you want your report and give credentials to access that specific folder. Here we select PDF.

6-Report Subscription(Windows File Share Delivery) in SSRS

7. Then click on Select Schedule to give specific time to deliver your report. In below screen you will see that options. After that click on OK.

7-Report Subscription(Windows File Share Delivery) in SSRS

8. You can also specify parameter’s value if any parameter is used in your report.

8-Report Subscription(Windows File Share Delivery) in SSRS

Now click on OK button. So we have done with Our Subscription.

9. You will see the history of your subscriptions under the tab of Subscriptions.

9-Report Subscription(Windows File Share Delivery) in SSRS

10. After your subscription is executed, you will find that report in Network Path which you specify at the time of Subscription Creation.

10-Report Subscription(Windows File Share Delivery) in SSRS

Congratulations! We successfully completed use of Report Subscription(Windows File Share Delivery) in SSRS.

8 thoughts on “Report Subscription(Windows File Share Delivery) in SSRS

  1. How about if the report execution failed for some reason. We want to send a failure e-mail notifying the programmer of the failed report.

  2. Hi Bhushan,
    I get following error when I create file share subscription.
    An impersonation error occurred using the security context of the current user.

    The log in id that I provided has all the access to the destination folder.

    Any help is greatly appreciated.

  3. Anyone have a trick for not having to set permissions in each of the report subscriptions. I have 100+ reports I plan to setup to write to a fileshare but my bigest hurdle is credential for saving to the file share. We update our passwords every few weeks so I do not want to have to update password in each report every few weeks.

Leave a Reply to Kaye Cancel reply

Your email address will not be published. Required fields are marked *