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.

Comments (1) -

Julie B
Julie B
1/26/2015 4:37:04 PM #

This was incredibly helpful! I was about to give up when I found this article - thank you so much. It worked beautifully!

Add comment

  Country flag

  • Comment
  • Preview