>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.
If it's not broken, fix it until it is.
My Blog