How To Filter A Tablix With An OR Condition In SQL Server Report Builder


Have you ever wanted to filter a tablix using an OR clause.  The interface is a little confusing, but the steps below will accomplish this.



1.  Open Tablix Properties

2.  Add Filter

3.  Set Filter Expression: =(Fields!MyTagName.Value = "value1" OR Fields!MyTagName.Value = "value2" OR Fields!MyTagName.Value = "value3")

4.  Set Filter Expression Type: Boolean

5.  Set Filter Operator to '='

6.  Set Filter Value = 'True'


That should do it.



There are no notes on this topic.