Joao,

To elaborate further on what John said, I use the SELECT into a CURSOR method also. It is much easier than trying to run the report from related tables.

When you make your report, refer to the fields as MyField, not MyCursor.MyField. Do not put the cursor in the data environment, just build it in the click event of the "go" button. Any variables that are in scope will be available to your report.

If you are running off the related tables, you can use:

REPORT FORM MyReport FOR BETWEEN(InvoiceNum, nStart, nStop) TO PRINTER

Post back with more questions if you have any problems.


>Hi, all
>
>I want to try to do my 1st report, and i need some help and advices.
>
>What i have.
>
>Two tables (Parent(Header_Invoice) / child(Lines_Invoices)) like invoices form.
>
>I have one first form where the users type 1st number (Ex:1) and last number (Ex: 20), then i want to print the invoices 1 to 20 without any pause.
>
>Thank's in Advance
>
>João Batista
>(jbinf@mail.telepac.pt)