Group Filter dialog

This dialog appears when you click the Group Filter button in the Group screen of the report wizard. It helps you to create and modify more advanced filtering conditions based on the selected group. See the dialog.

The following are details about options in the dialog:

Logic

Specifies whether to evaluate the records that are not in the record aggregate.

Functions

Specifies the function to aggregate on a certain field.

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

Where,

• +
  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.

Operators

Specifies the operator to compose the filter expression. It can be =, >, <, >=, <= or <>.

Value

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, click to select the parameter names in the Expressions dialog.

More

Lists some additional commands.

• END
  Finishes entering the condition
• OR
  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.

OK

Accepts the changes and closes the dialog.

Cancel

Closes the dialog, leaving any changes unsaved.

Help

Displays this help document.

Related topics:

• Filtering the groups