Microsoft® SQL Server® 2012 Bible

1276

Part IX: Business Intelligence

FIGURE 56-9

Create a report subscription to be delivered to a windows fi le share by confi guring these

options.

Creating a Data-Driven Subscription

A data-driven subscription enables delivery settings and report parameters to be set

dynamically using the results of a query. This is an excellent way to deliver reports and to

customize the content of the reports being delivered. (This feature is available only in the

Enterprise Edition of SQL Server.) For example, instead of creating linked reports for each

region as described earlier, a data-driven subscription could obtain the list of recipients

and their corresponding region from a data source and automatically generate and deliver

the reports with the content appropriate to each recipient.

To create a data-driven subscription, select the Subscriptions tab on the report you want

to deliver, and click the New Data-Driven Subscription button. This guides you through the

process to create a data-driven subscription. Data-driven subscriptions can be delivered by

c56.indd 1276c56.indd 1276 7/31/2012 10:34:19 AM7/31/2012 10:34:19 AM

http://www.it-ebooks.info