General information
Category:
Reports & Report designer
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)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only