Looping through sub summary values
Here's my (simplified) example:
I have a purchases file that contains supplier name and amount. There are multiple purchases for some suppliers.
A simple listview report with no body part and a sub summary part for each supplier when the table is sorted by supplier gives me the supplier's name and a total value of the purchases made from him - the amount I owe each supplier.
How do I use the report as the source of information for a script that produces a check for each supplier? Can there be a 'found set' of sub summary values? Is there a way of looping through sub summary fields in a script?
Many thanks for any ideas.