Report Subscription

SSRS 

Push Reports In SSRS :

Following are the steps to be done for report subscription in SSRS : 

→ SQL DB should be up and running

→ SQL Agent Should be up and running

→ Report Server/manager should be up and running

→ Report development and deployment 

→ Report automatic delivery / subscriptions

→ Check all the services are up and running or not : 

Go to ‘...’ in top of report and manage then you will get subscription option 

Delivery of report can be 2 forms :

1. Deliver In any format either through email subscription

      2. Windows file share subscription (shared Drive)

Windows file share subscription (shared Drive) : Next, we are selecting the render Format as PDF. From the below screenshot, you can see the list of available render options

• File Name: Please specify the file name

• Path: Specify the Network path where you want to save the Report.

• Render Format: Please select the format that you want to save the Report. For example, PDF, XML, Excel etc.

Subscription Processing Options :

• Schedule Details: Use this section to schedule the report subscription on Hourly, Daily, Weekly, Monthly, or Once in a lifetime. Don’t forget to mention the start time.

• Start Date: please specify when you want to start the Report subscription.

• Stop this Schedule on: When you want to stop this SSRS subscription.

Email Subscription in SSRS

• To: Email Id, or SMTP address of the receiver. (To whom you want to send the report)

• Subject: Email subject.

• Render Format: Please select the format that you want to save the report. For example, PDF, XML, Excel etc.

• Priority: Please specify the Email priority. Normal will do the work for you. If not, go for High.

• Subscription processing Options: This is the schedule of the report subscription.

Note: Subscriptions does not support Standard, Web, and Express with Advanced Services editions