O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Subscriptions – data-driven subscription

Another type of subscription is the data-driven subscription. This is a powerful way of creating subscriptions since you can use the database to set most of the properties of the subscription. The data-driven subscription is generated through a wizard. There are three different methods of delivery: e-mail, file share, and null. The null delivery does not generate a report. It is used to preload the cache for a report that is set up for using cached data.

Let's create a subscription to be sent out on the first of each month for each of the sales people:

Step 1 – specify the type of data-driven subscription

  1. Select the toolbar item called New Data-driven Subscription.
  2. Set the Description property to Last Month's ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required