Need to filter data in Tablix

Question

I have created a tablix where I need to filter the data, I have used the following expression in the Tablix properties and I am not getting the expected results

 

IIf(IsNothing(field1.Value) OR IsNothing(field2.Value), 1, 0)

The above formula is displaying if both fields are 'NULL'. I need to only filter if one is null or the other.

Answer 1

Hi @Ali Ahad,

Please try with switch expression.

=switch(isnothing(Fields!name.Value) and isnothing(Fields!address.Value),"0",
isnothing(Fields!name.Value)="False" and isnothing(Fields!address.Value)="False","0",
isnothing(Fields!name.Value),"1",isnothing(Fields!address.Value),"1")

Actually, I'd like to suggest that you may filter the data in your dataset to make it easier.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Are you mapping it to an integer, and are you comparing it to 1?

The outcome you're getting is what you'd expect if it was just a value that's not compared to anything. And because there's a value, it's treated as true.