Hiding tables in a drill through report - based on parameters received from the parent report

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Development » Hiding tables in a drill through report -...

Hiding tables in a drill through report - based on parameters received from the parent report

Rate Topic

Display Mode

Topic Options

Author

Message

kadeshara

Posted Thursday, January 27, 2011 1:34 PM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 6:45 PM
Points: 19, Visits: 5,533

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

kadeshara

Posted Thursday, January 27, 2011 6:04 PM

Grasshopper

Group: General Forum Members
Last Login: 2 days ago @ 6:45 PM
Points: 19, Visits: 5,533

Solution
=IIf(((Parameters!Param_Table.Value = "TABLE_CC_") AndAlso (Parameters!Param_System.Value <> "R")),False,True)

Post #1055030

« Prev Topic | Next Topic »

Permissions