April 3, 2012 at 10:59 pm
HI,
I've created a report hosted on SQL Server Reporting Services 2008 R2. I have one parameter which has 2 values(' BSC','DSC','ESC') one of the report. I need to generate 3 separate reports by passing the thous 3 parameter values separately.
Could you please let me know the workaround to this.
Thanks for your help.
April 3, 2012 at 11:09 pm
Though I could not make much out of your description of the problem, but I think do either of the two methods:
1. Make subreports and use expressions to make the visible property to true/false based on the parameter value.
2. Use the Action property of any of your controls. use expressions in your Action value that can change based on the parameter value.
April 4, 2012 at 7:18 am
I think you could probably use one report. Add a group by your parameter and then put a page break between the groups. The page break should simulate 3 separate reports in your case.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply