I am trying to show only those rows with the value "100". I set the expression to
=IIf(("Fields!WarehouseCode.Value")=100),False,True)
So far I only get result "True" for the rows with 100 and false for the others. See result. How do I hide the other rows, that don't contain the number 100?
Best,
Bogotrax
Edit: It works! Thanks alot Niktrs! Your code worked :)
= ( Fields!WarehouseCode.Value <> 100)
Set the tablix row visibility to your expression
= ( Fields!WarehouseCode.Value<>"100")
UPDATE
changed the expression to compare string instead of integer