Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Unanswered: Matrix Group Report

    Hi All,

    Im Sunil, Im created a Matrix Group Report in Oracle. But I have one issue in that report.
    Code:
    Year	80
    	Job	Clerk
    Dept No
    10		800
    20		500
    
    Year	81
    	Job	Analyst      Clerk	Manager
    Dept No
    10		200		300	500
    20		400		200	500
    Above mention report have year wise job in different departments. But that report in Year 80 Only one column Clerk & that Year 81 3 columns. I want Year 80 3 columns its column blank or not.

    Thanks
    Last edited by sunil.style2005; 02-02-12 at 01:43.

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    Please use [CODE] tag to display sample data.
    Because, it was left justified and correspondance of columns and values are not so clear.

    Another question is why "Dept no" was second line in Year 81 and third line in Year 80?

Posting Permissions

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