Progress
Report Builder
User’s Guide
IN-RANGE
Determines whether a value is within a specified range of values. Returns logical TRUE if the value is equal to or greater than the lowest value and equal to or less than the highest value. Returns FALSE if not.
SYNTAX
value
A value (a constant, field name, or expression) that you want to compare to a range of values.
low-value
The minimum value (a constant, field name, or expression) for the range against which you want Report Builder to compare the value.
high-value
The maximum value (a constant, field name, or expression) for the range against which you want Report Builder to compare the value.
NOTE
The value, low-value, and high-value must be the same data type: CHARACTER, NUMERIC, DATE, or LOGICAL expressions.
EXAMPLETo determine whether the price of each item in the Item table is within the range of 4.95 and 6.95, create a calculated field containing this expression:
Sample data:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |