>I am developing my first system in VFP and am now looking at the Report Designer for the first time....I am wanting to create a program that prints statements for customers that have outstanding invoices.
>Would I go about this by creating a "statement template" in the Report Designer. And then maybe on a form ask for the selection criteria and put a "Report Form custstmt for cus_acct = invoice.inv_acct to printer" in the middle of a loop that checks for outstanding invoices? I know I would need logic to not print more than one statement if there was more than one outstanding invoice per customer.
>
>I am more interested in knowing if I'm on the right track or if anyone can shed some light on how best to approach this.
>
>Thanks in advance,
>
>Paulo
I might use the report template (if all my reports were going to be based on these), but would use SQL to select customers' records to print.