>Hello.
>
>I have a report who needs to include a totals page wich is in another table.
>
>Example:
>
>Vendor Doc Amount
>Vendor Doc Amount
>Vendor Doc Amount
>Vendor Doc Amount
>
>Total amount xxxxxxxxx
>
>Vendor1 #docs amount
>Vendor2 #docs amount
>Vendor2 #docs amount
>Vendor2 #docs amount
>
>
>
>
>How can I make this report? TIA

One of the ways would be to construct a cursor with all the information in (with extra fields from the other table).

Other way to use relation between tables.