Create a Group Filter

Group filters can be used in output levels with grouped data to prevent rows with a certain number of grouped items from displaying.

For example, an output level that returns rows showing the number of unresolved incidents for each staff member could have a group filter to display only rows for staff members with more than ten unresolved incidents. Group filters can be fixed or runtime selectable.

1. Open the report you want to edit.
2. Select the level you want to add the filter to from the Level drop-down list at the top of the design surface.
3. Click the Level tab.
4. Click Add Group Filter.
   The Add Filter window opens.
5. Enter field information described in Create a Fixed or Runtime Selectable Filter.
   Note: The filter options for group filters are identical to those for filters applied to the overall report. However, you generally want group filters to filter on the results in the output level’s aggregate column. For example, if the aggregate column in your report counts the number of unresolved incidents a staff member has with count(incidents.i_id), then the group filter’s expression could be count(incidents.i_id)> 10, to return rows for staff members with more than ten incidents.
6. Click OK.
7. Click Save.