0 out of 1 rated this helpful - Rate this topic

My Subscriptions Page (Report Manager)

SQL Server 2008

Use the My Subscriptions page to view all of your subscriptions in one place. From this page, you can access and modify or delete any subscription that you own. You own only the subscriptions that you create. You cannot access those of other users, nor can you access subscriptions that you use but do not own (for example, if your name has been added to an existing subscription defined by another user). You cannot create subscriptions from this page. For more information about creating subscriptions, see the New Subscription / Edit Subscription Page (Report Manager).

To open this page, click My Subscriptions at the top of the page. My Subscriptions is always available, even if you lack permission to create subscriptions. If you have no subscriptions or if permission to create or manage subscriptions is disabled, no subscriptions appear on the page.

By default, subscriptions are sorted in alphabetical order by report name. Click a different column heading to change how subscriptions are sorted. Icons are used to indicate whether the subscription is an individual subscription or a data-driven subscription. For more information about icons, see Icons in Report Manager.

Note
This feature is not supported in SQL Server Express with Advanced Services. For more information about feature availability, see Reporting Services in SQL Server Express with Advanced Services.

Options

Delete

Select the check box next to each subscription that you want to delete and click Delete.

Edit

Click to view or edit the description.

Report

Shows the report that is specified in the subscription. Click the report name to view the report.

Description

Shows a description of the subscription. Click the description to view or edit the subscription information for the report.

Folder

Shows the folder that contains the report that is specified in the subscription. Click the folder name to view the contents of the folder.

Trigger

Identifies criteria that cause the subscription to run. A TimedSubscription trigger is based on a schedule that defines when the subscription runs. A SnapshotUpdated trigger is based on an update to a report snapshot.

Last Run

Shows the last time that the subscription was processed.

Status

Shows the status of the subscription. Usually, the status value is either "New" or the date and time at which the subscription last ran.

A status value of "Bad Data" occurs when the subscription includes a pointer to encrypted values that are no longer valid (that is, to the stored credentials used to run the report). Existing encrypted values become unusable when the symmetric keys used to encrypt and decrypt data are recreated on the report server.

A subscription cannot be processed if it has been deactivated. To update the subscription and make it operational, open and then save the subscription.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

My Subscriptions Page (Report Manager)

Tasks

Reference

Concepts

Community Additions