I am creating a Monthly Account Statement report in VFP 5.0a. It is a fairly simple report that just prints all the details of the customers invoices that are owing. I have a couple of requirements that I am not sure how to create in the Report Designer.

Firstly, I need to keep a running sub-total in one column. Secondly in the group footer, I need to print the aging summary. That is, the total of invoices that are current, those 30 days past due, etc.

How do you create this? In the detail band the amount for each invoice is printed, but I don't know how to then take that amount and add it to one of four sub totals depending on the date of the invoice.

Thanks in advance,

Peter Renton