Kbase P40956: RB. How to display just the last record for each group sort.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/8/2003 |
|
Status: Unverified
GOAL:
How to display just the last record for each group sort.
GOAL:
How to achieve a FIND LAST with report builder
GOAL:
Report Builder
FIX:
Let say that you want to have for each customer only the last invoice according to the invoice-Date.
1) Create a new report, choosing instant layout.
2) Add Invoice table
3) Add all the fields of the table.
4) Choose Database --> Sort Order
- New -> invoice.cust-num, Ascending as sort level 1.
-> invoice.invoice-Date, Ascending as sort level 2.
5) Choose Database -> Group Order -> invoice.cust-num
6) After the Record Band line, insert a new band line and choose 1GF-cust-num as type.
7) Drag the 3 data fields from the record line to the 1GF-cust-num line
8) You can delete the Record line in order to display just the last record for each group.
9) Print preview will show a report listing just the most recent Invoice.