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 reports 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. This program can be found under Start | All Programs | Microsoft SQL Server 2008 R2 | Configuration Tools.
  3. Check the Server Name and Report Server Instance ...

Get Microsoft System Center 2012 Service Manager Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.