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



TODO:

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.

 

SOLUTION:

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.

 

NOTES:

There are no notes on this topic.