Topic Last Updated—August 2008

Report subscriptions in SQL Reporting Services enable you to configure the automatic delivery of specified reports by e-mail or to a file share at scheduled intervals. Use the Create Subscription Wizard in Configuration Manager 2007 R2 SQL Reporting Services to configure report subscriptions.

You can also configure other types of report subscriptions, such as data-driven subscriptions from the Web interface included with Microsoft SQL Server Reporting Services. For more information, see your SQL Server documentation.

Important
To configure reports to be delivered by e-mail, you must configure the item E-mail Settings in SQL Reporting Services Configuration Manager. For more information, see How to Configure Microsoft SQL Server for SQL Reporting Services.
Note
The information in this topic applies only to Configuration Manager 2007 R2 and Configuration Manager 2007 R3.

To configure a subscription to deliver a report by e-mail

  1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reporting Services / <Report Server Name>, and expand the node.

  2. In the results pane, right-click a report and then click New Subscription.

  3. On the Subscription Delivery page of the Create Subscription Wizard, specify the delivery properties for this report subscription. From the Report delivered by drop-down list, select E-mail. For more details about the options on this page, see Report Subscription Dialog Box: Subscription Delivery Tab.

  4. Click Next to continue.

  5. On the Subscription Schedule page of the Create Subscription Wizard, configure the schedule by which the report will be generated and delivered. For more details about the options on this page, see Report Subscription Dialog Box: Subscription Schedule Tab.

  6. Click Next to continue.

  7. On the Subscription Parameters page of the Create Subscription Wizard, specify any parameters that this report needs to run. For more details about the options on this page, see Report Subscription Dialog Box: Subscription Parameters Tab.

  8. Click Next to continue.

  9. On the Summary page of the Create Subscription Wizard, review the subscription that will be created and then click Next.

  10. On the Confirmation page of the Create Subscription Wizard, review the actions taken and then click Close to exit the wizard.

To configure a subscription to deliver a report to a file share

  1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reporting Services / <Report Server Name>, and expand the node.

  2. In the results pane, right-click a report and then click New Subscription.

  3. On the Subscription Delivery page of the Create Subscription Wizard, specify the delivery properties for this report subscription. From the Report delivered by drop-down list, select Windows File Share. For more details about the options on this page, see Report Subscription Dialog Box: Subscription Delivery Tab.

  4. Click Next to continue.

  5. On the Subscription Schedule page of the Create Subscription Wizard, configure the schedule by which the report will be generated and delivered to the file share. For more details about the options on this page, see Report Subscription Dialog Box: Subscription Schedule Tab.

  6. Click Next to continue.

  7. On the Subscription Parameters page of the Create Subscription Wizard, specify any parameters that this report needs to run. For more details about the options on this page, see Report Subscription Dialog Box: Subscription Parameters Tab.

  8. Click Next to continue.

  9. On the Summary page of the Create Subscription Wizard, review the subscription that will be created and then click Next.

  10. On the Confirmation page of the Create Subscription Wizard, review the actions taken and then click Close to exit the wizard.

See Also