Home » Developer & Programmer » Reports & Discoverer » Need solution for matrix report formating (10g)
icon4.gif  Need solution for matrix report formating [message #525590] Tue, 04 October 2011 00:46
onlijob
Messages: 6
Registered: October 2011
Location: india
Junior Member
hello everyone..

Am new to reports, am trying to learn reports through data model. Here is the scenario am trying to make: i want to create a matrix report which should have

"deptno" as rows and
"substr(hiredate,4,3) as hiredate" as columns, and
"sum(sal)" as cells of the matrix -- sum of (deptno and hiredate) cross product

I able to perform the above. Now i need some extra in that..

I also need to show a report having
but this time
"job" as rows and
"substr(hiredate,4,3) as hiredate" as columns, and
"sum(sal)" as cells of the matrix -- but sum of (job & hiredate) cross product

Not as nested but as separate part i mean The matrix should have common column but two rows (deptno and job) one after the other.

My matrix should should hve "hiredate" as common column and first all "deptno as rows" and their sum(sal) as cells should be shown
after completing all deptno and their summation(sum of each cells row wise and column wise), the "job" as rows and sum(sal) for this should follow that.

I can achieve this through 2 queries and 2 matrix. But i want to achieve with a single matrix.
Is it possible?

Pls help me
Thanx
Previous Topic: MATRIX REPORT
Next Topic: Oracle Discoverer - Workbooks
Goto Forum:
  


Current Time: Mon Apr 06 01:25:11 CDT 2020