Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Location
    Singapore
    Posts
    12

    Exclamation Unanswered: Reports6i - A Complicated MATRIX Report

    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.

  2. #2
    Join Date
    Oct 2003
    Posts
    43
    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.

  3. #3
    Join Date
    Jun 2004
    Location
    Singapore
    Posts
    12
    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.

  4. #4
    Join Date
    Jun 2004
    Location
    Singapore
    Posts
    12
    i think this is something like a Nested Matrix.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •