Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Subscription and Delivery Scenarios

SQL Server 2005

You can use subscription and delivery functionality to achieve a variety of objectives that vary in complexity and scope.

The following table describes scenarios for using the subscription and delivery functionality that installs with Reporting Services. If you are a developer, you can create custom delivery extensions to support additional scenarios. For more information, see Implementing a Delivery Extension.

Objective Description

Push reports out to users in your organization

Create a subscription and specify a group alias or e-mail alias to receive a report that you want to distribute.

You can have Reporting Services determine the subscription data at run time. If you want to send the same report to a group that has a changing list of members, you can use a query to derive the subscription list at run time.

View reports offline

Users can select PDF or Web archive formats in a subscription. These formats are recommended for viewing reports offline.

Archive reports to a file share

Reports that you want to archive can be sent directly to a shared folder that you back up on a nightly schedule.

Send large reports to disk

Large reports that take too long to load in a browser can be sent to a shared folder in a format that can be viewed in a desktop application.

Preload the cache

If you have multiple instances of a parameterized report or a large number of report viewers, you can preload reports in the cache to reduce processing time used to display the report.

Target a desktop application as a viewing device

If you want to work with a report as a Microsoft Excel file, you can create a subscription that sends the report as an Excel file. If you have a shared folder that stores the working documents for a specific work group, you can specify it in the subscription.

Customize report output for individual users

Use data-driven subscriptions to customize report output, delivery options, and report parameter settings at run time. The subscription uses a query to get input values from a data source at run time.

You can use data-driven subscriptions to perform a mail-merge operation that sends a report to a list of subscribers that is determined at the time the subscription is processed.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.