Getting Started with SSRS (vii) Report subscriptions

SSRS provides basic report Subscription functionality, which demonstrates how to subscribe to a report.

A common requirement for report subscriptions is that users want to receive the latest report data about a business at a fixed time, such as a specified day of the week, or at a fixed time each day.

SSRS's report subscriptions provide two main ways to send mail, one for sending to a specified shared directory.

The message is sent if you want to have your own SMTP server, after the author verified and obtained the information, and the application of the SMTP service from the Third-party Web site is not possible, from the system tracking information can also be seen is not dbmail, due to the configuration of the SMTP server involved, so here is not to introduce , an alternative scenario will be presented in the next article. This article mainly demonstrates how to subscribe to a report as a shared directory.

Assuming that the user has such a requirement, you want to send the report to a specified shared directory at a fixed time each day for the appropriate department to view.

First, use the SSRS Report subscription function, in addition to the basic Reporting Services need to be opened, but also to ensure that the agent service is also open.

Then, go to the report management interface and find the report we set up in the previous section.

After you find the report, click the Down menu next to the report and click Subscribe.

Go to the report subscription interface, delievered by selecting Windows File Share so that the report is sent to a shared directory.

Path settings must be a shared directory, directly set D disk such a directory is not allowed.

Render format allows you to choose common types such as Excel or PDFs.

The authentication information can provide a username and password that the system will use to access the shared directory. So in the above shared directory, make sure that the user has write permission to the shared directory.