Grouping Filter Conditions (Report Builder 1.0)
A filter group contains one or more filter conditions connected by the same logical operator. Grouping filter conditions helps refine the data returned when the filter is applied to the report. By default, a single, implied filter group is created when you add several filter conditions to the filter area. You can further group the filter conditions by using the New Group options. Using these options you can group a set of filter conditions and nest grouped filter conditions within other grouped filter conditions to display the data you are interested in viewing in the rendered report.
Filter condition groups are grouped using Any of, All of, None of, and Not all of options. In an All of or None of filter condition group, all the filter conditions within the group must be met. In an Any of or Not all of filter condition group, any of the filter conditions within the group must be met.
By default, And is the logical operator between the filter conditions in an All of or Not all of group box, but this can be changed to Or by changing the title of the filter group. By default, Or is the logical operator between the filter conditions in an Any of or None of group box, but this can be changed to And by changing the title of the filter group. If you change the operator between the filter groups to Or, the grouped filters are grouped by an Any of group box.
.gif "Filter Data with grouped conditions")