Enter filter criteria for... Dialog

enter filter criteria dialog


Allow more than one filter criteria for the same column.

How to Open

In the Report Viewer, open the drop-down menu for one of the filter cells; select the Custom option (see below):

report filtering, custom option


enter filter criteria dialog,condition

You may specify as many conditions as you like.  Each condition has two properties, a Matching Criteria on the left and a filter value on the right.  The filter value is a string, and the matching criteria specifies what constitutes a match.   For more details, look HERE.

Filter Aggregation

There are two ways you can aggregate / combine filter conditions:

enter filter criteria dialog,radio list


enter filter criteria dialog,buttons

You can select a condition by clicking on the field name to the left of the matching criteria:

enter filter criteria dialog,condition selected