SSRS Subscriptions

Overview:

A subscription is a standing request to deliver a report at a specific time or in response to an event, and then to have that report presented in a way that you define. 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.
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. For each standard subscription, there is exactly one set of report presentation options, delivery options, and report parameters.

Report delivery option a) Email Delivery
b)Windows File share Delivery
data driven subscriptions :
Data-driven subscriptions are dynamic in that the presentation, delivery, and parameter values are retrieved at run time from a data source. You might use data-driven subscriptions if you have a very large recipient list or if you want to vary report output for each recipient. To use data-driven subscriptions, you must have expertise in building queries and an understanding of how parameters are used.

Email Delivery Subscription:

Report server e-mail delivery is implemented on Collaboration Data Objects (CDO) and requires a local or remote Simple Mail Transport Protocol (SMTP) server or SMTP forwarder.
The Report Server Windows service account must have permission on the SMTP server to send mail.
The Report Server E-mail delivery extension uses UTF-8 encoding in e-mail attachments. You cannot modify the encoding; the HTML rendering extension only supports UTF-8.

Step1:
Start the SQL SERVER AGENT services.
Need to create the data source for the report in report manager (i.e http://jayantk4346-sap:8080/Reports)

Step2: a)Give the credentials for custom data source data source type & connection string.
b)Click on the credentials stored securely in the report server.
Username : Domainname\Username ( ex :ITCINFOTECH\reddeppa.gundluri)
Password:welcome12345
c)select the use as windows credentials when connecting to the data source.
d)Click apply
e)click on subscriptions
Step 3:
Click on New subscription

a)select the subscription type
Select the option delivered by ------> Email
specify the values the report is delivered only to the address that are full email addresses and that are specified in the following recipient fields:
To:
CC:
BCC:
Reply To:



b)Subscription processing options:
when the scheduled report run is complete ----> click on select schedule

Click ok.

Email delivery subscriptions are successfully created.






File shared Delivery:
From step 3 elect the report delivery option ---->windows file share

a)Give the path must conform to Uniform Naming Convention (UNC) format.



b)Credentials use to access the file share
Username : Domainname\username
Password:xxxxxx
c)Schedule the report run is complete ---> select the schedule
d) schedule to determine the report for delivered.