João,

How well do you know SQL? Simply select the data exactly as you would like to see it for your report. The data will be very non-normalized. For example, the client's name will be repeated on every line of the report cursor, but will only show in the header on the report. Use the page header or group header for things like the client name and the date, the detail lines for the individual "line items" and the page footer or group footer for the total of the invoice. (The field would have the amount, and then calculate the sum, with reset when invoice number or client name changes.)

You may want to look at some examples for report layout, like the Orders.frx in TasTrade.


>Hi Cindy,
>
>Thank's for your response, i think the same way and i would do that.
>
>But i want to elaborate an Invoice, i have several tables like,
>
>Documents.Type
>01-Invoice
>02-VD,.......
>
>CLients
>0001-Joao Batista-Stree A, CytiB
>
>Header.Invoice
>Document.ID
>Client.ID,
>Date Document ...
>
>Line.Invoice
>Ref.ID
>Description
>QT......
>
>Now, when i do a select in table Header.Invoice i need to get in table clients the name, in documents.Type the name document, what's the way to do that in select or in design report?
>
>Sorry for boring you but it's my first report with a lot of tables and i think i have some problems.
>
>Thank's in Advance
>
>João Batista