Enter filter criteria for... Dialog

Top  Previous  Next

Screenshot

enter filter criteria dialog

 

Purpose

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

 

Conditions

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.

 

Radio List

enter filter criteria dialog,radio list

 

And conditions:  All conditions must be true to constitute a match.
Or conditions: At least one condition must be true to constitute a match.

 

Buttons

enter filter criteria dialog,buttons

 

Add a condition: Add a extra condition row.
Delete Condition: Delete the selected condition.

You can select a condition by pressing the button to the left of it:

enter filter criteria dialog,condition selected

 

OK: Close the dialog and apply the filter.
Cancel: Close the dialog.  Do not apply the filter.