Kbase 20374: How to Separate a Record Set Between Groups?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/05/2007 |
|
Status: Unverified
GOAL:
How to group a recordset between one group with a given criteria and all other records in the recordset.
FIX:
In this example all customers who have a state beginning with the letter M are listed and totaled first, then all other records in the table are listed and totaled.
FOR EACH customer BREAK BY (NOT state MATCHES "M*"):
DISPLAY state name credit-limit(TOTAL BY NOT state MATCHES "M*").
END.