Hide Tablix on Condition base in SSRS

1
votes

I've one main report in which I have created two different Tablix. (Both have different dataset)

My question is, How can I hide tablix on condition base in SSRS.

For example:

Parameters!First.Value="Y" then hide only first tablix and show second tablix but if Parameters!First="Y" AND Parameters!Second.Value="Y" then show only first tablix not the second one.

How can I achieve this, Please help.

1
reporting-servicesssrs-tablixssrs-expression
I assume you tried setting the visibility / hidden property of the tablixes... What equation did you put in there? – Jonnus
Yes I've tried like this as per my condition, =IIF(Parameters!First.Value="Y",False,True) but the main problem is how can I hide other tablix from this expression? – pedram
You need to put conditions in both tablixes. – Anup Agrawal
I've tried but we have one common condition here is Parameters!First.Value="Y" so it is showing both tablix in such condition. – pedram

1 Answers

0
votes

First Tablix Visibility/Hidden Expression 

=Parameters!First.Value="Y" AND NOT(Parameters!Second.Value="Y")

OR

=Parameters!First.Value="Y" AND (Parameters!Second.Value<>"Y" OR ISNOTHING(Parameters!Second.Value))

OR

=IIF(Parameters!First.Value="Y" AND Parameters!Second.Value="Y",False,True)

Second Tablix Visibility/Hidden Expression:

=Parameters!First.Value="Y" AND Parameters!Second.Value="Y"

OR 

=iif(Parameters!First.Value="Y" AND Parameters!Second.Value="Y", True, False)

First evaluate both hidden expression independtly.

Note: For expression in SSRS you can write a shortcut expression without using iif.