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:
- General Properties Page (Data-Driven Subscription Wizard)
- Delivery Data Source (Data-Driven Wizard)
- Delivery Query Page (Data-Driven Subscription Wizard)
- Extension Settings Page (Data-Driven Subscription Wizard)
- Parameter Values Page (Data-Driven Subscription Wizard)
- Subscription Trigger Page (Data-Driven Subscription Wizard)
Starting the Wizard
To start the Data Driven Subscription Wizard
In SQL Server Management Studio, in Object Explorer, connect to a Report Server.
Select a report. The report data source must be configured to use stored credentials. For more information, see Report Caching in Reporting Services.
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