Data-Driven Subscriptions

A data-driven subscription provides a way to use dynamic subscription data that is retrieved from an external data source at run time. A data-driven subscription can also use static text and default values that you specify when the subscription is defined. You can use data-driven subscriptions to do the following:

  • Distribute a report to a fluctuating list of subscribers. For example, you can use data-driven subscriptions to distribute a report throughout a large organization where subscribers vary from one month to the next, or use other criteria that determines group membership from an existing set of users.
  • Filter the report output using report parameter values that are retrieved at run time.
  • Vary report output formats and delivery options for each report delivery.

A data-driven subscription is composed of multiple parts. The fixed aspects of a data-driven subscription are defined when you create the subscription, and these include the following:

  • The report for which the subscription is defined (a subscription is always associated with a single report).
  • The delivery extension used to distribute the report. You can specify report server e-mail delivery, file share delivery, the null delivery provider used for preloading the cache, or a custom delivery extension. You cannot specify multiple delivery extensions within a single subscription.
  • The subscriber data source. You must specify a connection string to the data source that contains subscriber data when you define the subscription. The subscriber data source cannot be specified dynamically at run time.
  • The query that you use to select subscriber data must be specified when you define the subscription. You cannot change the query at run time.

Dynamic values used in a data-driven subscription are obtained when the subscription is processed. Examples of variable data that you might use in a subscription include the subscriber name, e-mail address, preferred report output format, or any value that is valid for a report parameter. To use dynamic values in a data-driven subscription, you define a mapping between the fields that are returned in the query to specific delivery options and to report parameters. Variable data is retrieved from a subscriber data source each time the subscription is processed.

Requirements for using Data-Driven Subscriptions

Note

Data-driven subscriptions are not supported when the report server is configured for SharePoint integrated mode.

Data-driven subscription functionality is not available in all editions. There are also limitations on the kinds of data sources that you can use to retrieve subscription data at run time. The following list provides more information about the requirements:

  • Confirm whether you are using one of the following editions: Evaluation, Developer, and Enterprise. Data-driven subscriptions are not supported in the Standard edition or SQL Server 20005 Express Edition with Advanced Services. For more information about feature availability, see Features Supported by the Editions of SQL Server 2005.
  • For subscription data, choose a data source that can provide schema information to the report server. Examples of supported data source types include SQL Server relational data, Oracle, Analysis Services databases, SQL Server Integration Services package data, ODBC data sources, and OLE DB data sources. For more information about subscriber data source requirements, see Using an External Data Source for Subscriber Data.

Working with Data-Driven Subscriptions

The following topics provide more information about data-driven subscriptions.

Topics Description

Subscription Processing

Describes how reports are processed for data-driven subscriptions.

Creating, Modifying, and Deleting Data-Driven Subscriptions

Explains how to create, modify, or delete a data-driven subscription.

Using an External Data Source for Subscriber Data

Provides information about the data sources that you can use for a data-driven subscription.

Tutorial: Creating a Data-Driven Subscription

Provides step-by-step instruction for learning how to create a data-driven subscription.

Report Caching in Reporting Services

Describes how to use the Null Delivery Provider with a data-driven subscription to preload the cache.

See Also

Tasks

How to: Delete or Modify a Subscription (Management Studio)
How to: Delete or Modify a Subscription (Report Manager)
How to: Preload the Cache (Management Studio)
How to: Preload the Cache (Report Manager)

Concepts

Subscription Overview

Other Resources

Delivering Reports Through Subscriptions
Create Data-driven Subscription Page (Report Manager)

Help and Information

Getting SQL Server 2005 Assistance