Progress
Report Builder
User’s Guide


Quick Reference Table

Report Builder supports the same operators as the Progress 4GL, plus the “-” string concatenation operator.

Table C–2 lists the five main types of operators and the operators within each type.

Table C–2: Operators
Type
Operator
Description
Arithmetic
+
Addition
-
Subtraction
/
Division
*
Multiplication
MODULO
Remainder after division
Date
+
Addition of days to a date. For example:
Order-Date + 30
-
Subtraction of days from a date or subtraction of one date from another. For example:
Ship-Date - Order-Date
Character
+
Concatenation (joining two character strings into one). For example:
First-name + Last-name
-
Concatenation after removing trailing spaces from the string before the operator. For example:
First-name - " " + Last-name - ""
Relational
BEGINS
Returns a logical value indicating whether the first operand begins with the second operand
MATCHES
Returns a logical value indicating whether the first operand matches the pattern specified as the second operand
= or EQ
Equal to
<> or NE
Not equal to
< or LT
Less than
<= or LE
Less than or equal to
> or GT
Greater than
>= or GE
Greater than or equal to
Logical
NOT
Logical not
AND
Logical and
OR
Logical or

NOTE: The Insert Filter Condition dialog box lists the IN-RANGE and IN-LIST functions as operator choices. See "Report Builder Functions," for descriptions of these functions.


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