Posted by: Charles Maitland | Thursday 1 June, 2006

Reporting Services Standard Edition – Data Driven Subscriptions

Just scanned this article in SQL Server Central by Jason Selberg.

It details how to get data driven subscriptions using the Standard Edition of SQL Server.

"Do you have SQL Reports that need to go to different people but each person's report has different parameters? Don't have the resources to purchase the Enterprise edition of SQL 2000? The only solution available in Standard edition, besides writing your own front end in .NET was to create a subscription for each unique report, person and parameter. After only a short amount of time, you've got a ton of subscriptions to manage."

The technique uses a Stored Procedure to manipulate the Subscriptions Table in the Report Server database.

A useful trick to have up the sleeve.

Advertisements

Responses

  1. do you have any stuff to start this via from .Net code?
    Thanks

  2. HI,
    Did you progress with this at all. I am trying to find a method in Reporting services (Standard) 2005 making use of multi-value parameters?
    Thanks
    Phil


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: