July 20, 2011 at 11:09 am
Hello All,
I'm using SSRS 2008 R2 and I'm fairly new to SSRS. I am going to be designing a rather lengthy report with a series of tables and charts. I expect that each table and chart will be a separate subreport.
Depending on the parameter passed a table or chart may need to be dynamic, meaning the rows and/or columns may vary. The number of variations will be limited, probably two or three for each table or chart.
My first thought is to create a subreport for each variation. Then based on the parameter being passed I would like the correct subreport to be used by the report.
Is this feasible? Are there any other methods to dealing with this type of issue?
Thanks
July 20, 2011 at 11:15 am
In the subreport's source you cannot use an expression.
My guess is that if you have any chance of getting this to work is to make 2 or more subreports and then set the visibiliy on / off based on parameters (that setting can use an expression).
Now what would bug me is : Are those reports run anyways even if I hide them? This could become a performance hog really quickly. Of course you could pass an extra parameter to those subreports and then no return any data based on that parameter.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply