June 12, 2014 at 8:24 pm
In a ssrs 2008 report, I would like to call other reports based upon selections that users make and/or possibly calling the other reports based on values stored in a table in sql server 2008 or sql server 2008 r2. The users could possibly select the reports they want by: 1. using dropdown lists, 2. using checkboxes to pick the reports they want, 3. selecting a number to indicate the order of how the reports should be executed.4, using default values stored in a database. Thus what option would you use and would you tell me how to code this option?
June 12, 2014 at 10:13 pm
I would like to call other reports based upon selections that users make and/or possibly calling the other reports based on values stored in a table in sql server 2008 or sql server 2008 r2. The users could possibly select the reports they want by: 1. using dropdown lists, 2. using checkboxes to pick the reports they want, 3. selecting a number to indicate the order of how the reports should be executed.4, using default values stored in a database.
Maybe it's just me, but I've read this post at least 5 times, and I'm still not sure what you're asking. Are you essentially trying to create a reporting solution where users can select which subreports to include in a report by passing parameters when the report is executed? I suppose you could create subreport(s) in your main report and set the specific report using an expression.
June 13, 2014 at 1:51 am
I think if I understand you correctly then the short answer is: Not easily.
The idea above is good, but I'm not sure you can use an expression to populate the target of a sub report element, at least not without using some VB code (please correct me if I'm wrong, it'll be useful for me to know!). Do your sub reports have parameters of their own? If so you'd also need to set those as well, and it rapidly gets very complicated.
What is the wider context around trying to execute reports in this way? If it's the case that certain users always want the same set of reports, you could try using subscriptions against individual reports to email them out once a day, for example. If you're trying to build some sort of interactive dashboard that allows the user to change what metrics they see, then SSRS isn't the best tool for that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply