Kbase 18339: Report Builder: How to split a column based on criteria.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/10/2004 |
|
Status: Unverified
GOAL:
How to split a column based on criteria in Report Builder.
FIX:
To split a column in 2 based on certain criteria, create a calculated field(s) and place it on the report.
Example -- To split the Sports.Credit-Limit column in two columns GT (Greater than 10,000), and LT (Less than or equal to 10,000), do the following:
1) Create a new calculated field named GT. In the EXPRESSION part, insert the following line, IIF(Credit-Limit > 10000,string(Credit-Limit),"")
2) Create another calculated field named LT. In the EXPRESSION part insert the following line, IIF(Credit-Limit <= 10000,string(Credit-Limit),"")
3) Place GT and LT on the report and type in appropriate column headings (LABELS) for these two calculated fields.