Share via


Managing Subscriptions

This section contains topics about subscription processing, oversight, and control. Subscription management varies for standard subscriptions and data-driven subscriptions. Standard subscriptions are typically user-owned and managed. In contrast, data-driven subscriptions are typically created and maintained by a report server administrator.

Subscription and delivery features are enabled by default (e-mail delivery requires configuration before it can be used). The default delivery extensions include report server e-mail and file share delivery. Unless you create or install custom delivery extensions, these are the only distribution methods available to subscriptions on a native mode report server.

Permissions for Subscribing to Reports on a Native Mode Report Server

Depending on how you use roles, you can provide subscription functionality to selected groups of users by enabling or disabling subscription tasks for different roles. Subscription features are available to users through two tasks:

  • The "Manage individual subscriptions" task allows users to create, modify, and delete subscriptions for a specific report. In the predefined roles, this task is part of Browser and Report Builder roles. Role assignments that include this task allow a user to manage only those subscriptions that he or she creates.

  • The "Manage all subscriptions" task allows users to access and modify all subscriptions. This task is required to create data-driven subscriptions. In predefined roles, only the Content Manager role includes this task.

Disabling Subscriptions

To prevent users from creating subscriptions, clear the "Manage individual subscriptions" task from the role. When you remove this task, the Subscription pages are not available. In Report Manager, the My Subscriptions page appears to be empty (it cannot be deleted), even if it previously contained subscriptions. Removing subscription-related tasks prevents users from creating and modifying subscriptions, but does not delete existing subscriptions. Existing subscriptions will continue to execute until you delete them. For more information about deleting subscriptions, see Creating, Modifying, and Deleting Standard Subscriptions.

To disable subscription processing on a report server, you can set the ScheduleEventsAndReportDeliveryEnabled property to False in the Surface Area Configuration for Reporting Services facet of SQL Server Policy-Based Management. Doing so will prevent all scheduled operations from running. You cannot turn off just subscription processing on the report server.

For instructions on how to cancel subscription that is processing on the report server, see Managing a Running Process.

Disabling Delivery Extensions

All delivery extensions installed on a report server are available to any user who has permission to create a subscription to a given report. The following delivery extensions are available and configured automatically:

  • Windows File Share

  • SharePoint Library (available only from a SharePoint site that is integrated with a SharePoint integrated mode report server)

E-mail delivery must be configured before it can be used. If you do not configure it, it is not available. For more information, see Configuring a Report Server for E-Mail Delivery.

If you want to turn off specific extensions, you can remove extension entries in the RSReportServer.config file. For more information, see RSReportServer Configuration File and Configuring a Report Server for E-Mail Delivery.

After you remove a delivery extension, it is no longer available in Report Manager or a SharePoint site. Removing a delivery extension can result in inactive subscriptions. Be sure to delete the subscriptions or configure them to use a different delivery extension before removing an extension.

In this section