Kbase P5628: Report Builder: How to create conditional fields.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/01/2003 |
|
Status: Unverified
GOAL:
Report Builder: How to create conditional fields.
FIX:
1) Create a calculated field using the "fx" button.
Examples:
To pinpoint the invoices that have amounts bigger than $1000, in the calculated field definition, type:
IIF(Amount < 1000,"<- Collect immediately","")
Or you can create more complex conditions like this:
IIF(Amount > 1000,IIF(Ship-Charge = 0,"<- Deliver immediately",""),"")
2) Saved the calculated fields.
3) Insert the calculated field in the report, by selecting it from the available fields.