display 2 columns with sub totals

T

Trevor Mills

I need to display data from 2 sources side by side with sub-totals to show
that they reconcile. eg

Sub-total 1 = Australia
Employee 1 $ Product A $
Employee 2 $

Sub-total 2 = New Zealand
Employee 1 $ Product A $
Product C $

I don't see sub-reports working because I need to compare the sub-totals
side by side.

In some sections there will be more rows on the left and in others more rows
on the right.

My idea is to populate a temporary table with the data and generate the
report from the table. An alternate ideas most welcome, my way seems klunky.

Thanks in advance

Trevor
 
Top