I'm required to generate a complicated Matrix Report. Having the following Output.
GP-0 (First Digit)

(Subinventories)
(Group) (inv_org) COUGAR NIPPON HT-DIV GPXX TOTAL
GP 01 CII 5 2 7
OSS 3 4 7
DROPSHIP 6 6
GP 03 CII 5 5
M1 1 11 12
DROPSHIP
GP 04 CII 3 3
OSS 2 9 11
DROPSHIP 1 1

-------------------------------------------------------
CII Total 10 2 3
OSS Total 2 12 4
M1 Total 1 11
DROPSHIP Total 7
-------------------------------------------------------
The 2nd Page will have GP - 1 (first Digit) - The INV_ORG Totals for each SUBINV category are irrespective of GP's 2nd digit.

I've been able to generate the Inside matrix but not these TOTALS - which are individual totals for Inventory-orgs for each SUB_INV.

Do i need another matrix for the Data provided within the dotted lines ---.

Even if I use another matrix to generate these totals (data within the lines), I dont know how to show these 2 matrices together in the layout. Shall I use Data-links, if yes How ??
Plz HELP !!!

PS: While the First Matrix uses GP and INV_ORG as the first group(row-group of the matrix), Sub-Inv as the column-group.
The 2nd Matrix (if used) uses Inv_Org as the row-group, Sub-Inv as the column-group.

Have you tried building the information for the second matrix in a seperate query then inserting a second report block in the layout editor which you can use to reference this second query.

Yeah Chumpski,
It works that way.

That means I put the second matrix layout inside the correct repeating frame of the first matrix, after creating a data-link between the two.
It works fine.

Thx Anyways,
Rahul.

i think this is something like a Nested Matrix.