SSRS- Subscriptions

SSRS- Subscriptions

·      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. It’s an alternative way to deliver the report to end user in automated manner on predefined schedule.

·       The objective of the subscription is to reduce the  On-Demand  access  to the report server, therefore it also reduce network traffic and provide readymade business analysis to the client for specific event ..

·       Subscriptions are processed on the report server and are distributed through delivery extensions that are deployed on the server. By default, you can create subscriptions that send reports to a shared folder or to an e-mail address. If the report server is configured for SharePoint integrated mode, you can also send a report to a SharePoint library.

There are two type of subscription

·         Standard Subscriptions

·         Data Driven Subscriptions

Standard Subscriptions

Standard subscriptions are created and managed by individual users. A standard subscription consists of static values that cannot be varied during subscription processing.

How to set subscription

·         Go to report manager

·         Click on the report for which want to subscribe

·         Now click on “Manage”(See below on Pic.)

As you Click on subscribe you will see this  screen.

Now you click on “New Subscription”

Now you set your Subscription option  

While setting Subscription your  Sql server Agent should be in running mode