Filter & Sort Records Dialog

This dialog allows you to filter database records by defining criteria or sort them with a specified field.

Filtering

You define criteria by setting certain conditions and link them with AND/OR operators.

Filter Records - This option enable the filtering of records

Begin - set the level for the "opening" parenthesis. This can be either (, ((, (((, (((( or (((((

Field Name - select a field to test for condition

Criteria - select a comparison operation

Value - set a value the that will be compared with the selected field. Every record with a field that satisfy the criteria will return a TRUE for this condition.

End - set the level for the "closing" parenthesis. This can be either ), )), ))), )))) or )))))

Combine - used for combining conditions. If the value is OR, this means the current condition will be ORed with the next condition, and any records that satisfy any of these conditions will be considered for printing. If the value is AND, this means the current condition will be ANDed with the next condition, and any records that satisfy all of these conditions will be considered for printing. If the value is END , this means the current condition is the last condition in the filter.

Sorting

Sort Records - This option enable the sorting of records

Field Name - select a field to be sorted

Order - the sorting order of the values, Ascending or Descending

Combine - used for incoporating additional sort criteria. If the value is AND, this means there is an additional sorting criteria. If the value is END, this means the current criteria is the last criteria.

Use Custom SQL Statement

As you build filtering and sorting criteria, you will notice that the statement in this field actually changes. If you require special processing of the records that is not easily achieved with the basic filtering and sorting described above, you may define your own custom SQL statement in this field by selecting this option.