Kbase P9270: How to create a report that shows only the last of a set of records in a joined table.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/11/2003 |
|
Status: Unverified
GOAL:
How to create a report that shows only the last of a set of records in a joined table.
FACT(s) (Environment):
Progress/WebSpeed Versions
CAUSE:
Due to Report Builders design it will display all of the records from the joined table.
FIX:
1) Create your basic report layout and database joins.
2) Create a sort on the second field in decending order.
For our example we will use customer and invoice of customer.
3) Create a caculated field with the following expression;
iif(Previous(invoice.custnum)=custnum, FALSE, TRUE)
4) Enable bandline printing in this band that prints only when the caculated field is TRUE.