New Subscription / Edit Subscription Page (Report Manager)

Use the New Subscription or Edit Subscription page to create a new subscription or modify an existing subscription to a report. The options on this page vary depending on your role assignment. Users with advanced permissions can work with additional options.

You can open this page in the following ways:

• To open the New Subscription page, open report property pages, click the Subscriptions tab, and then click New Subscription. You can also click New Subscription from the View page.
• To open the Edit Subscription page, open report property pages, click the Subscriptions tab, find the subscription you want to modify, and then click Edit. You can also edit subscriptions from My Subscriptions, which is available on the global toolbar.

Subscriptions are supported for reports that can run unattended. At a minimum, the report must use stored or no credentials. If the report uses parameters, a default value must be specified. Subscriptions may become inactive if you change report execution settings or remove the default values used by parameter properties. For more information, see Managing Subscriptions.

Options

• Delivered by
  Select the delivery extension to use to distribute the report. Selecting a delivery extension causes other settings to appear. The settings vary depending on the delivery extension you choose.

  E-mail subscriptions provide fields that are familiar to e-mail users (for example, To, Subject, and Priority fields). Specify Include Report to embed or attach the report, or Include Link to include a URL to the report. Specify Render Format to choose a presentation format for the attached or embedded report.

  File share subscriptions provide fields that allow you to specify a target location. You can deliver any report to a file share. However, reports that support interactive features (including matrix reports that support drill-down to supporting rows and columns) are rendered as static files. You cannot view drill-down rows and columns in a static file. The file share name must be specified in Uniform Naming Convention (UNC) format (for example, \\mycomputer\public\myreportfiles). Do not include a trailing backslash in the path name. The report file will be delivered in a file format that is based on the render format (for example, if you choose Excel, the report is delivered as an .xls file).

  The availability of a delivery extension depends on whether it is installed and configured on the report server. Report Server E-mail is the default delivery extension, but it must be configured before you can use it. File Share delivery does not require configuration, but you must define a shared folder before you can use it.

  For more information about how to create a subscription, see How to: Subscribe to a Report (Report Manager).

Subscription Processing Options

Use these settings to define the conditions that cause a subscription to process. Some of the options are only available for reports that use parameters or that run as report execution snapshots.

• When the report content is refreshed
  Select this option to subscribe to a report snapshot that is refreshed on a scheduled basis. This option is visible only when you are subscribing to a report that runs as a report execution snapshot. The content for a report execution snapshot is typically refreshed on a schedule. For reports that run in this mode, you can define a subscription to occur when the snapshot is refreshed.

• When the scheduled report run is complete
  Create a schedule that determines when the subscription is processed.

• On a shared schedule
  Choose a predefined schedule to process the subscription.

• Enter parameter values
  Use this option when you are subscribing to a report that has parameters. This option is available only for parameterized reports. When subscribing to a parameterized report, you can specify the parameter values that are used to create the version of the report that is delivered through the subscription. For example, you can specify a region code to select sales data for a particular region. If you do not specify a value, the default value is used.

Change History

See Also

Reference

Report Manager F1 Help

Other Resources

How to: Start Report Manager (Report Manager)
Report Manager
Creating, Modifying, and Deleting Schedules

Help and Information

Getting SQL Server 2005 Assistance