Show or hide report based on expression

Asked Sep 20 '16 at 09:41

Active Sep 20 '16 at 13:10

Viewed 191 times

Today i have one problem with SSRS reports while show or hide report based on expression i tried different expects but it is still not working following is my expression.

=IIf(Parameters!P_Level.Value = "3", true, false)

I tried following another expression

=IIf(Parameters!P_Level.Value = 3, true, false)

Also tried

 =IIf(Parameters!P_Level.Value > 2, true, false)

but when i select parameter P_Level with value 3 still report is not displaying my report.

Please add in comment if you need any more details.

Thanks in advance !!!

edited Sep 20 '16 at 13:10

Tab Alleman

31,483
7
36
52

asked Sep 20 '16 at 09:41

Nikhil.Patel

What Component you want to show or hide ?? Rectangle , textbox , tablix ? (What hide Report ?) – Chanom First Sep 20 '16 at 09:45
I want to use it with chart and i set visibility as showorhide based on expression – Nikhil.Patel Sep 20 '16 at 09:46
3

This properties is "Hidden" if you want to display report when p_Value = 3 use this Expr '=IIf(Parameters!P_Level.Value = 3, false, true)' – Chanom First Sep 20 '16 at 10:02
What is the name of the property that you are putting this expression in? – Tab Alleman Sep 20 '16 at 13:11

Show or hide report based on expression

0 Answers0