Search code examples
reporting-servicessql-server-2017

How do I write a proper hide row expression?


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)

Solution

  • Set the tablix row visibility to your expression

    = ( Fields!WarehouseCode.Value<>"100") 
    

    UPDATE

    changed the expression to compare string instead of integer

    enter image description here

    enter image description here