Delivery Query Page (Data-Driven Subscription Wizard)
Use this page to specify a command or query that gets subscription data. The result set that is produced by this command must contain all the generated data that you want to use. At a minimum, if you are using e-mail delivery, this should include e-mail aliases. Later, you will map the fields in the result set to subscription options. Subscription options can use data other than that returned by the result set. Specifically, you can use static values if you want to use the same subscription setting for all subscribers (for example, if you want to use the same export format for all reports that are distributed through this subscription).
Options
- Command text
Type a SQL query or a command that returns subscription data.
- Validate
Click Validate to verify the query. The query must produce valid results before you can continue. On subsequent pages, the result set is used to populate delivery options and report parameters.
Delivery settings
Shows the settings of the delivery extension you selected for this subscription.You can use this information to guide you in creating the query. If you want to use dynamic subscription data to set the delivery settings, the query must return values that can be mapped to all or some of the delivery settings.
Report parameters
Shows the parameters (if any) used in the report.You can use this information to guide you in creating the query. If you want to use dynamic subscription data to set report parameters, the query should return values that can be mapped to these parameters. Optionally, you can use the default parameters that are defined for the report.
- Specify a command time-out in seconds
Specify a query-time-out value. This value must be large enough to complete query validation.
For more information about the next page in the wizard, see Extension Settings Page (Data-Driven Subscription Wizard).
See Also
Other Resources
Defining Report Datasets
Working with Parameters in Reporting Services
Reporting Services F1 Help