Progress
Report Builder
User’s Guide


Filtering Basics

When you create a filter, you specify one or more conditions by which Report Builder limits the data it displays. Each condition contains:

If you are specifying multiple conditions, also include:

Lastly, you can also reverse the result of the comparison by using the NOT operator.

NOTE: If you are using outer joins in Report Builder and your report contains filter conditions, Report Builder applies the filter conditions after it processes the joins. As a result, the composite table might contain a different set of records than the records you obtain from an equivalent join and WHERE clause in a 4GL procedure.

The following sections describe condition fields, comparison operators, and comparison values.

Condition Fields

The condition field can be a database field, calculated field, aggregate field, or memo field. See the following sections for information about filtering on aggregate, calculated, or memo fields.

Comparison Operators

The comparison operator defines the relationship by which Report Builder evaluates the condition. Table 10–1 describes each of the available operators.

Table 10–1: Filter Comparison Operators
Operator
Description
=
Equal to
<>
Not equal to
>
Greater than
>=
Greater than or equal to
<
Less than
<=
Less than or equal to
IN-RANGE
Between two values or equal to either
IN-LIST
Equal to one of the listed values (up to 10 values)
MATCHES
Matches the entered pattern
BEGINS
Begins with the specified characters

The comparison drop-down list contains only the operators that are valid for use with the specified condition field.

NOTE: In Report Builder, the not equals (<>) operator treats the UNKNOWN value differently than the Progress 4GL. If a filter condition uses the not equals operator, and if the condition field for a record has the UNKNOWN value, the filter condition screens out the record, unless the comparison value is also UNKNOWN. For example, a condition such as Order-Line.Discount <> 0 screens out any records whose Order-Line.Discount value is UNKNOWN. In the 4GL, the same filter condition accepts all records whose discount value is UNKNOWN.

Comparison Values

The comparison value is the value to which Report Builder compares the condition field. The comparison value can be:

When you specify a comparison value, consider the following guidelines:


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095