The Group Filter dialog helps you to create and modify advanced filtering conditions based on the selected group. It appears when you select the Group Filter button in the Group screen of the report wizard.
The following are details about options in the dialog:
Specifies whether to evaluate the records that are not in the record aggregate.
Specifies the function to aggregate on a certain field.
Evaluates the records that have the lowest values for the selected field.
Evaluates the records that have the largest values for the selected field.
Checks if there exists at least one qualified record.
Field Name (before Occur With)
Specifies the field you want to aggregate on.
Field Name (after Occur With)
Specifies the criteria of the filter.
Expression includes not only the DBField, but also formulas and parameters. You can manually type the strings supported by the database or select to select column names or fields values in the Expressions dialog.
Adds numbers or fields together in the Expression menu.
Subtracts numbers or fields together in the Expression menu.
Multiplies numbers or fields together in the Expression menu.
Divides numbers or fields together in the Expression menu.
Equates fields together.
Places quotations marks on long character strings or names that have blanks. For example, places quotes on values, such as "New York" and "Washington DC".
Places fields together in the same Expression menu. For example: "New York" || "Washington DC".
- ( )
Places the fields in parentheses.
Specifies the operator to compose the filter expression.
Greater than or equal to
Less than or equal to
Not equal to
Specifies the value used in the filter condition.
You can also use a parameter for runtime input. You can manually type the value or parameter name, or, for parameters, select to select the parameter names in the Expressions dialog.
Lists some additional commands.
Finishes entering the condition
Inserts the logic operator AND which is applied to this line and the next line.
Inserts the logic operator OR which is applied to this line and the next line.
- Insert Row
Inserts a single Expression row.
- Delete Row
Deletes a single Expression row.
Accepts the changes and closes the dialog.
Closes the dialog, leaving any changes unsaved.
Displays the help document about this feature.