Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

252



LESSON 28 Deploying anD aDministering ssrs

Schedule:



A shared schedule can be used by several reports. Updating the shared schedule will

affect all reports using it. The other option is an independent schedule used only by the cre-

ated subscription.

After creating a subscription for a report, you will need a way to manage the subscriptions. Click

the drop-down menu next to the report name again and select Manage, shown in Figure 28-6. The

Report Management screen has several options on the left-hand side of the window. They include

the following:

Properties:



Name and description of the report

Data Sources:



Data sources used by the report

Shared Datasets:



Shared datasets used by the report

Subscriptions:



Subscriptions set up on the report and the status of the last run for each

subscription

Processing Options:



Cache and snapshot options

Cache Refresh Options:



Location of cache refresh plans

Report History:



Saved snapshots of the report

Snapshot Options:



Controls snapshot history options

Security:



Controls the security options and roles

Under the Subscriptions option you can see any subscription on the current report and the last

time the subscription ran, along with the status of that run. You can delete the subscription in this

screen also.

There is one other type of subscription available in Reporting Services. It is the data-driven subscrip-

tion. This type of subscr ...