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.
Before you can make use of reports subscriptions, e-mail delivery options need to be configured for SQL Server Reporting Services.
- 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.
- Start Reporting Services Configuration Manager. This program can be found under Start | All Programs | Microsoft SQL Server 2008 R2 | Configuration Tools.
- Check the Server Name and Report Server Instance ...