Lesson 14: SSRS Subscriptions - Email Based AnandFriday, December 19, 2014 1 comments

                     Lesson 14: SSRS Subscriptions - Email Based

Subscriptions are delivery mechanisms for delivering a report to an user.
Subscriptions allow us to schedule a report, to be run and delivered in many formats (Excel/PDF etc) as an email or to be dropped in a file share at any pre-defined time.

There are mainly 2 types of subscriptions:
1.Standard
2.Data-Driven Subscription.

It also has 2 delivery mechanisms:
1.Email based
2.File Share based.

Lets discuss the email based subscription.
This demo is based on SSRS 2008 R2
Step 1:After I navigate to my ReportServer page, I should be seeing something like this:

Step 2: Select the report, and click subscribe.

Step 3: if the credentials are not stored, you will get the following error message.

Navigate again to the report and click manage:

Goto the data sources tab, and enter the credentials:

Click on apply and then click on subscriptions tab.
You should be seeing a screen something like this:

Click on New subscription.

you should be presented with a screen like this:

Select delivered by: Email
Type in To, CC, BCC
Select a report rendering format.
Select a schedule.
Click OK

The report should be available in your inbox, at  your specified time.