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