MATRIX Help [message #305508] |
Tue, 11 March 2008 02:01 |
irfan.ocp
Messages: 29 Registered: February 2008 Location: Karachi, Pakistan
|
Junior Member |
|
|
Dear All;
It is possible on Oracle Matrix Report
DEPT 10 20 30
EMP SAL SAL SAL TOTAL SAL EMPNAME
------ ------- ------
1010 5000 Smith
0150 5800 John
0250 6800 Edey
1350 1800 Akray
0150 1858 Jimmy
1810 1892 Jack
------ ------- ------
TOTAL ****** ******* ******
I was getting problem to define that EMP/EMPNAME run as row
Oracle giving me problem that ROW then CeLLs after then you can not give the row. I have create a new repeating frame but they didn't match.
Any idea how it works.
Best Regards,
Muhammad Irfan Bakali.
|
|
|
Re: MATRIX Help [message #305971 is a reply to message #305508] |
Wed, 12 March 2008 07:59 |
Flash
Messages: 34 Registered: February 2008
|
Member |
|
|
Hi,
You need to select the column as department, row as Empname/ Emp No and the cell as Salary.
What have you chosen in your query. Please paste your query and tell me your data model.
I can help you in this.
Thanks
Flash
|
|
|
|
|