SSRS 2008 row visibility issue

Question

I am facing following scenario : I have two values A and B and I need to Hide and show it based on ssrs expression. My Conditions :

If A = 1 and B = 1 show row
If A = 1 and B = 0 Show row
If A = 0 and B = 1 Show row
If A = 0 and B = 0 Hide Row

(I have tried using AND, OR, XOR, AndAlso, OrElse but it is not working.) (Problem arises because SSRS shows when output is false and hides when output is true)

This should be as simple as setting hidden to `A = 0 And B = 0`. You might have abstracted out the real problem from your question when simplifying it? — lc., Jan 23 '17 at 06:07
@Azhar Can you show your expressions tried? The one suggested above should work. — BishNaboB, Jan 23 '17 at 09:19
=IIF((Fields!A.Value = 0) AND (Fields!B.Value = 0),False,True) — Azhar, Jan 23 '17 at 10:24

score 0 · Accepted Answer · answered Jan 23 '17 at 09:38

0

Select the table detail row (or group row depending your table) and in the Visibility set the hidden expression like below

= ( Fields!A.Value = 0 AND Fields!B.Value = 0)

answered Jan 23 '17 at 09:38

niktrs

9,858
1
30
30

SSRS 2008 row visibility issue

1 Answers1