How to: Add, Move, or Delete a Filter Condition (Report Builder)
To apply a filter to your report, you must have at least one filter condition. You can add unlimited conditions.
On the Report menu, click Filter.
Note: Alternatively, open the Filter Data dialog box by clicking the Filter button on the Report toolbar.
In the Filter Data dialog box, double-click the entity or field name or drag it to the filter area.
The filter condition is added to the filter area. When a header is shaded, the group is selected. When you double-click an item, it is added to the selected item in the filter area.
Click the equals comparison operator and select the operator that you want to use.
Type or select the criteria value.
To add additional filter conditions, follow steps 2 through 4.
When done, click OK.
The Filter Data dialog box closes.
When you run the report, the filter is applied.