January 27, 2011 at 1:34 pm
Hi there,
Working on SSRS 2008
Scenario is that I have one parent report with an option for users to drill through to a child report by clicking on a specific cell in the report, this part works perfect by using "Action" and passing selected parameters to the child report.
The requirement is that the child report has 6 tables and I need to hide/show specific tables based on one/two parameters values received from the parent report.
3 out of 6 tables are working fine as they are hidden based on ONE parameter value received. I hide the table by using the Tablix properties --> Visibility --> Show or hide based on an expression --> "=IIf(Parameters!Param_Table.Value = "TABLE_CC" ,False,True)"
(Issue)
The problem occurs when I try to hide a table based on two parameters values. I hide the table by using the Tablix properties --> Visibility --> Show or hide based on an expression --> "=IIF(Parameters!Param_Table.Value = "TABLE_CC",False,True) ANDALSO IIF(Parameters!Param_System.Value = "R",False,True)
For some reason the above doesn't work and table is always displayed when it matches one of the parameter e.g. If the parent report passes Param_Table = TABLE_CC and Param_System = P the table is displayed.
I've tried various combination to hide the table but been unsuccessful, now need some help from all the experts around the world.
Thanks,
Kewal
January 27, 2011 at 6:04 pm
Solution
=IIf(((Parameters!Param_Table.Value = "TABLE_CC_") AndAlso (Parameters!Param_System.Value <> "R")),False,True)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply