Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SSRS + multiple subscriptions with different default values

Posted on 2011-05-12
4
Medium Priority
?
446 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:Josh_Blade
  • 2
  • 2
4 Comments
 
LVL 11

Accepted Solution

by:
shorak earned 2000 total points
ID: 35745776
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
 

Author Comment

by:Josh_Blade
ID: 35745805
Hmm, are data driven subscriptions only supported by SQL Server Enterprise editions?
0
 

Author Closing Comment

by:Josh_Blade
ID: 35745843
Very quick response, with an excellent guide!
0
 
LVL 11

Expert Comment

by:shorak
ID: 35745846
Unfortunately, only Enterprise and Developer editions suport it according to Microsoft.

http://msdn.microsoft.com/en-us/library/ms169673.aspx
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Screencast - Getting to Know the Pipeline
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question