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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial