BackPrevious Topic  Next TopicNext

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.

Group Filter dialog box

You see the following options in the dialog box:

Logic

Select to evaluate the records that are not in the record aggregate.

Functions

Select the function to aggregate on a certain field.

  • Min
    Select to evaluate the records that have the lowest values for the selected field.
  • Max
    Select to evaluate the records that have the largest values for the selected field.
  • Exist
    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 Ellipsis button to select column names or fields values in the Expressions dialog box.

Operators

Select the operator to compose the filter expression.

  • =
    Equal to
  • >
    Greater than
  • <
    Less than
  • >=
    Greater than or equal to
  • <=
    Less than or equal to
  • <>
    Not equal to

Value

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 Ellipsis button to select the parameter names in the Expressions dialog box.

Down button

Select to display some additional commands.

  • END
    Select to finish entering the condition.
  • And
    Select to insert the logic operator "AND" which applies to this line and the next line.
  • OR
    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.

OK

Select to apply your settings and close the dialog box.

Cancel

Select to close the dialog box without saving any changes.

Help

Select to view information about the dialog box.

Back to top

BackPrevious Topic  Next TopicNext