I probably shouldn't have used the words "dummy relationship". I meant to create a dummy table to act as the parent ... then create a relationship between the parent and the two child tables.
>Cathy --
>
>What exactly do you mean "set a dummy relationship to each of the 2 tables you have"? How do you do that?
>
>Thanks in advance,
>
>Jim
>
>
>
>>You can use multiple detail bands to pull this off. Create a dummy table with one record and set a dummy relationship to each of the 2 tables you have. Put everything for Table 1 into the Detail 1 band. Check the Detail Header and Footer band checkox and put your totals for table one into the Detail 1 Footer band. Do the same for the 2nd table using the 2nd detail band.
>>
>>>Basically, I have 2 unrelated tables, and I have to report one after the other in the same report. I can`t use two reports without eject page.
>>>
>>>The layout is:
>>>
>>>Table 1
>>> Details
>>> Totals
>>>
>>>Table 2
>>> Details
>>> Totals
>>>
>>>
>>>>I'm not clear on what you want. Could you be more descriptive about what is coming from what table .. and which lines are "totals" of previous records and which lines are the detailed records themselves.
>>>>
>>>>
>>>>
>>>>>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