Export (0) Print
Expand All

New Subscription / Edit Subscription Page

SQL Server 2000

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

Notify 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.

Choosing Report Server E-mail, for example, shows delivery options for To, Subject, Render Format, and Priority. For more information about how to specify these options, see How to create an e-mail subscription in Books Online.

Notify me when the report content is refreshed

Select this option to subscribe to a report snapshot that is refreshed on a scheduled basis. In this case, the notification occurs when the snapshot is refreshed.

Notify me when the scheduled report run is complete

Select this option to schedule when the subscription is processed. You can create a schedule that is specific to this subscription, or you can choose a predefined shared schedule if one is available that meets your criteria.

This option is selected by default if you are subscribing to a report that is not associated with a schedule associated.

Enter parameter values

Use 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.

Report Delivery 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. Reporting Services provide Report Server File Share and Report Server E-mail delivery.

Report Server E-Mail Settings

Choosing Report Server E-mail shows delivery options that specify how to deliver a report to a mailbox. To e-mail a report, your report server must be configured for e-mail delivery. 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, and Include Link to include a URL to the report. Render Format to choose a presentation format for the attached or embedded report. For more information about how to specify these options, see How to create an e-mail subscription in Books Online.

Report Server File Share

Choosing Report Server File Share shows delivery options that specify how to deliver a report to a location on the file system. 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 file that is based on a matrix report. Avoid the format HTML with Office Web Components.

The file share must be specified in Uniform Naming Convention (UNC) format (for example, \\myserver\c$\myreportfiles). Do not include a trailing backslash in the path name. The file name is based on the report name, which you can override by setting the File Name option. 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). For more information about how to specify these options, see How to create a file share subscription.

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

Select this option to create a schedule that determines when the subscription is processed.

On a shared schedule

Select a predefined schedule to process the subscription.

Enter parameter values

Use 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. If you do not specify a value, the default value is used.

See Also

Creating, Modifying, and Deleting Schedules

Report Manager Help

Show:
© 2014 Microsoft