Data-Driven Subscription Wizard

The Data-Driven Subscription Wizard guides you through the steps of creating or modifying a query-based subscription that delivers SQL Server Reporting Services reports to a list of subscribers. Data-driven subscriptions retrieve subscription data at run time. Data-driven subscriptions can use a combination of static values that you define in the subscription, and dynamic values that are provided by the query.

You can use data-driven subscriptions to distribute reports to a subscriber list that varies between subscription runs, to customize report output based on input values specified through the query, and to preload a report cache with a large number of parameterized report instances.

To create a data-driven subscription, you must know how to write a query or command that gets the data. You must also know how to connect to a data store that contains the recipient data (that is, the names of recipients and the delivery settings associated with each one).The Data-Driven Wizard includes the following pages:

Starting the Wizard

To start the Data Driven Subscription Wizard

  1. In SQL Server Management Studio, in Object Explorer, connect to a Report Server.

  2. Select a report. The report data source must be configured to use stored credentials. For more information, see Report Caching in Reporting Services.

  3. Expand the report node, right-click Subscriptions, and select New Data-Driven Subscription.

See Also

Other Resources

Tutorial: Creating a Data-Driven Subscription
Data-Driven Subscriptions
Creating, Modifying, and Deleting Data-Driven Subscriptions
Using an External Data Source for Subscriber Data

Help and Information

Getting SQL Server 2005 Assistance