SSRS + multiple subscriptions with different default values

I have a report built in SSRS, and I was wondering if there is a way to set up a subscription that will run reports for each of the available options for a given parameter.

ie: One of the parameters is VendorID. At the moment, there are 11 VendorIDs, so I'd like to have a subscription that will run 11 reports, one with each VendorID as the default value. Then later, if a new VendorID is added to the database, the subscription would run 12 reports etc.
Josh_BladeAsked:
Who is Participating?
 
shorakCommented:
Hi... have a look at my solution in the following question.

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23942416.html

In summary, you will need a version of reporting services that supports data driven subscriptions. As part of the setup, you write sql that will return a list of vendorID's which you use as a parameter for your subscription.

hope this helps

Rob

0
 
Josh_BladeAuthor Commented:
Hmm, are data driven subscriptions only supported by SQL Server Enterprise editions?
0
 
Josh_BladeAuthor Commented:
Very quick response, with an excellent guide!
0
 
shorakCommented:
Unfortunately, only Enterprise and Developer editions suport it according to Microsoft.

http://msdn.microsoft.com/en-us/library/ms169673.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.