Progress
Report Builder
User’s Guide
Error Conditions in Evaluating Expressions
When you print or preview a report, if Report Builder encounters an error in evaluating a calculated field expression, it displays question marks in the field and in any fields that total the calculated field. For example, if Report Builder tries to evaluate a date expression that adds a specified number of days to a field whose value is UNKNOWN, it displays ??/??/?? as the result, since it cannot produce a proper date.
For example, if Report Builder tries to evaluate a numeric expression that requires it to divide by zero, it displays question marks as the result, since division by zero is an undefined operation. If this calculated field were totaled, the total value would also display as question marks.
UNKNOWN sorts as the last value in an ascending sort or the first value in a descending sort. For more information about how Report Builder handles UNKNOWN values, see the "UNKNOWN Values" section of this chapter or Fields."
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |