How to: Group Filter Conditions (Report Builder)
You can group together multiple filter conditions and nest filter condition groups within other filter condition groups by dragging and dropping. You are not limited in the number of groups you can use. You can create a filter condition group first or, if you prefer, you can add your filter conditions to the filter area, create a filter condition group, and then move the filter conditions into the group.
To create a filter condition group
To open the Filter Data dialog box, click Filter on the Report menu.
In the Filter Data dialog box, click New Group.
Select the option that you want to use.
A new filter condition group is displayed in the filter area. The title of the filter condition group indicates the New Group option that you selected.
When creating a new group, the new group is added to the end of the currently selected group, and becomes the new selected group.
To add filter conditions to the filter condition group
In the Explorer pane, select a field or entity and drag it to the filter condition group.
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 to the filter condition group, follow steps 4 through 6.
Optionally, change the comparison operator between each filter condition.
Note
If you change individual operators within a group, this action creates a new, nested group.
Click OK.
When you run the report, the filter is applied.
To move a grouped filter condition
- Click the filter group box name and drag the group to the new location.
To remove a grouped filter condition
- Click the filter group box name and click Remove Group.
See Also
Tasks
How to: Add, Move, or Delete a Filter Condition (Report Builder)
Concepts
Grouping Filter Conditions (Report Builder)
Working with Filters (Report Builder)
Working with a Filter Condition (Report Builder)
Other Resources
Filter Data Dialog Box (Report Builder)