Group Filter Dialog Box
You can use the Group Filter dialog box to create and modify advanced filtering conditions based on the selected group. This topic describes the options in the dialog box.
Designer displays the Group Filter dialog box when you select Group Filter in the Group screen of the component wizard.
You see the following options in the dialog box:
Select to evaluate the records that are not in the record aggregate.
Select the function to aggregate on a certain field.
Select to evaluate the records that have the lowest values for the selected field.
Select to evaluate the records that have the largest values for the selected field.
Select to check if there exists at least one qualified record.
Field Name (before Occur With)
Specify the field you want to aggregate on.
Field Name (after Occur With)
Specify 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 the the ellipsis to select column names or fields values in the Expressions dialog box.
Select the operator to compose the filter expression.
Greater than or equal to
Less than or equal to
Not equal to
Specify the value to use 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 the ellipsis to select the parameter names in the Expressions dialog box.
Select to display some additional commands.
Select to finish entering the condition.
Select to insert the logic operator "AND" which applies to this line and the next line.
Select to insert the logic operator "OR" which applies to this line and the next line.
- Insert Row
Select to insert a single Expression line.
- Delete Row
Select to delete a single Expression line.
Select to apply your settings and close the dialog box.
Select to close the dialog box without saving any changes.
Select to view information about the dialog box.