Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Hiding tables in a drill through report - based on parameters received from the parent report Expand / Collapse
Author
Message
Posted Thursday, January 27, 2011 1:34 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 14, 2014 3:00 PM
Points: 19, Visits: 5,560
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





Post #1054901
Posted Thursday, January 27, 2011 6:04 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 14, 2014 3:00 PM
Points: 19, Visits: 5,560
Solution
=IIf(((Parameters!Param_Table.Value = "TABLE_CC_") AndAlso (Parameters!Param_System.Value <> "R")),False,True)
Post #1055030
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse