 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
