Progress
Report Builder
User’s Guide
Guidelines for Using Report Builder Functions
Although many of the Report Builder functions are similar to Progress 4GL functions, you must follow these guidelines for using the Report Builder functions:
- You cannot abbreviate function names.
- You must include the parentheses for functions that do not have parameters. For example, to use the TIME function in Report Builder you must enter TIME( ).
- Case sensitivity of character string values affects Report Builder in the following ways:
- When the result of an operation or function is a character string, it is not case sensitive unless one or more of the operands or arguments is a case-sensitive string. Character string constants are always case insensitive. You can specify that a calculated or aggregate field or UDF parameter is case sensitive; by default, strings are not case sensitive.
The CASE and IIF built-in functions are exceptions to this rule. The value they return is selected from a list of arguments and retains the case sensitivity of the argument.
- Operations and built-in functions that use character strings perform their calculations in a case-insensitive manner unless one or both of the operands or arguments is a case-sensitive string. For example, MATCHES compares values in a case-insensitive manner unless one of the values is case sensitive.
See Fields." for a complete description of how Report Builder handles case sensitivity.
- Report Builder assigns an UNKNOWN value to a field if:
- There is an error in a calculation or aggregate that Report Builder cannot evaluate (for example, division by 0). If this occurs, Report Builder displays a string of question marks (?) the same width as the field width.
- The field is a database field whose value is UNKNOWN.
- The expression in a calculated field refers to an UNKNOWN value, or one of the values accumulated by an aggregate field (except a COUNT aggregate) is UNKNOWN.
See Fields." for a complete description of how Report Builder handles UNKNOWN values.
NOTE: You can also use a question mark (?) to represent an UNKNOWN value.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |