>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,
You drop the same field being listed in the report column in the group footer. In the properties of the field dropped in the group footer, you tell it to calculate the sum of that field. You also set the total to reset (to zero) when whatever field changes (probably the customer number, for example). You have have multiple groups on the report, you just drop whatever field you want to total or sub-total in the appropriate group foot, even the report footer or summary band for grand totals.
On the number of invlices, you would select the count option. As for how many over 30 days, etc., I would create report variables that provides a sum. The initial value would be zero and the value would be
nCurInvoiceCount = iif(between(invoicedate, date()-30, date(), 1, 0))
n30DayInvcCount = iif(invoicedate > date()-30, 1, 0)
Mark McCasland
Midlothian, TX USA