Kbase 15637: Printing a band line conditionally on a complex statement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Printing a band line conditionally on a complex statement
How To Print a Band Line Conditionally on a Complex Statement
To print a band line on a more complex condition than
"Print when field is true" or "Print when field is false or
unknown," you must use create a calculated field to print
conditionally on.
For example (using the sports database), in order to print
a band line only when the customer-number field is greater
than 25, you must create a calculated field that uses the
"IIF(logical,value,value)" function.
1. Click on calculated field
2. In the New Calculations dialog box, scroll through the
"Functions:" selection list then select the
"IIF(logical,value,value)" function.
3. Replace the "logical" argument with "Cust-Num > 25".
(Do not include the quotation marks.)
4. Replace the first "Value" argument with true and the
second "Value" argument wiht false.
IIF(Cust-Num > 25, True, False).
5. Give a name to the new calculated field in the
"Calculated Field Name:" fill in field.
6. Click on OK.
7. Double click on the bank line to bring up the "Band Line
Properties" dialog box.
8. Click on "Enable Conditional Printing".
9. Use the drop down list to select the calculated field
you just created from the list of calculated fields.
10.Click on the "Print When Field Is True" radio button.
11.Click on OK.
Even though the calculated field you created is not
displayed on the report, it is still processed for each
record iteration and can be used for the print conditional
calculation.
Progress Software Technical Support Note # 15637