A little Cabernet and the solution came to me: Use Sub reports. Now I just have to figure out how to get the total to include data from both reports.
Original post:
I've created a Cross tab rpt with 4 groups of data arranged as subgroups.
Problem is, the whenever I make a change to any of the 4 cross tabs, the other groups change too.
My 1st 2 groups are fine.
I have columns 1, 2, 3, broken into subcolumns
1.1, 1.2, 1.3, 2.1, 2.2, 2.3, 3.1, 3.2, 3.3 .
The subcolumns are further divided 1.1.1, 1.1.2, 1.1.3, 2.1.1, 2.1.2, 2.1.3, 3.1.1, 3.1.2, 3.1.3, .
For the next two groups, I want to eliminate the top level column, 1,2 and 3.
How can I apply different cross tab organizations in one report?
Many thanks if you can help.
Edited by bigbloo - 22 Mar 2010 at 6:20pm