Link to home
Start Free TrialLog in
Avatar of RNGAdmin
RNGAdmin

asked on

Show only selected sub reports

Hi ,

I have a ssrs RDL report which has 10 sub reports. Every thing works fine when we run the report.I see all 10 reports on the web page.
 We now have a scenario, where user selects some out of 10 sub reports (selection is through   aspx page).

Based on the user selection i need to display only the selected reports. I am able to achieve this by hiding the report based on an expression. But i am sure that all 10 reports run irrespective of the selection and display only selected based on user selection.

How do i over come this issue. User may select only 1 out of 10 reports to view it or he may select 9 reports out of 10 to view it. How do i achieve this.?

Right now i place all 10 sub reports in one rdl file. Each sub report in one rectangle control. and i have an expression which controls the visibility of the rectangle. Please help...
ASKER CERTIFIED SOLUTION
Avatar of Nico Bontenbal
Nico Bontenbal
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RNGAdmin
RNGAdmin

ASKER

The solution is definitely worth a try and it worked fine but taking the fact that we dont have a straight forward solution i would certainly recommend this as a solution. Hope Microsoft make this an option in their next release..