I hope this makes sense:

You can have one column of the cursor be a value that tells you what type of detail line it is (ie. from Table1 or from Table2).

A simplified example:

Cursor looks like:

WhatType C(1)
WhatValue N(8,2)

If the record is from Table1, make WhatType equal "A". If the record is from Table2, make WhatType equal "B". Now, when you print the detail in the report, you can use the Print When options to format things differently for different types of values (eg. WhatType="A" or WhatType="B"). You can use Report/Data Grouping to group on WhatType. Use a Report Total variable for totals and reset this variable at the WhatType data grouping. I am assuming you print all details from Table1 then all details from Table2; if not, use two WhatValue fields and two report Totals and use two (overlapping if need be) TextBox controls with Print When logic using WhatType so only one prints at a time. If you have more detail data, just add columns to the cursor. The secret is to use a data grouping of WhatType (and build the cursor with the records in the right order); if the report is not to be "all details from Table1 one, then all from Table2", just use multiple WhatValue columns and Print When logic and multiple report totals.

Does this make any sense? If not, give me some detail and I will try to explain myself with your specific situation in mind.

Joe


>Yeah, but I need to have diff. headers and totals. Wouldn't to hard to add all these expressions to print?
>Thanks Mark