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)"
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.