Delivering reports automatically using report subscriptions

SQL Server Reporting Services allow your users to subscribe to reports. Using report subscriptions, you can deliver reports to your end users' mailbox in the desired format on a scheduled interval.

Getting ready

Before you can make use of report subscriptions, e-mail delivery options need to be configured for SQL Server Reporting Services:

1. Log on to the server that hosts SQL Server Reporting Services with an account that has administrative privileges on both the local computer and SQL Server.
2. Start Reporting Services Configuration Manager.
3. Check the Server Name and Report Server Instance to make sure that you are connecting to the correct instance of SQL Server Reporting Services. Click on Connect.
4. Under E-mail Settings, enter the e-mail address that you want to use as the sender address for report delivery.
5. Enter the SMTP Server hostname or IP address, and then click on Apply. Click on Exit to close the Reporting Services Configuration...