Wednesday, September 17, 2008

Difference between standard subscription and data-driven subscriptions

Standard Subscriptions

  1. Standard Subscriptions are available in Sql Server Standard version.
  2. Report users can subscribe for the subscriptions.
  3. The subscription is static in the sense that the list of subscribers is not derived from a query or some Active Directory search. The subscribers request(subscribe) for the report delivery or get an information that the report has run and is ready for viewing.

Data-Driven Subscriptions

  1. Data-Driven subscriptions are available in Enterprise Edition of Sql Server
  2. The DBAs/SSRS administrators are the ones who configure the subscriptions. The reports can be subscribed with different parameters.
  3. The subscribers list can be dynamic and can be the result of a query.

2 comments:

Richard C. Lambert said...

It's a bit late, I'm afraid, but since I'm a granny, I'm late all over the news LOL Keep in touch :-)Startup ideas in India

Unknown said...

You can use SQL-RD, a third-party solution, to create and run data-driven schedules without having to upgrade to SQL enterprise. It also comes with event-based scheduling (triggers the report on events including database changes, file changes, emails received and so on). It delivers the reports to email, SharePoint, folder, printer, fax or Dropbox.