Matrix report problem

[mnakhtar]

Hi !!

I am using Oracle reports 6i to make a report (matrix report as far as i get it). I have following fields in the view which is coming from couple of tables and have some calculations to get these fields
(group by clause include section_code,group_code,machine_code,jobdate,organization_id)

Name Null? Type
----------------------------------------- -------- ---------------
SECTION_CODE NOT NULL VARCHAR2(5)
GROUP_CODE NOT NULL VARCHAR2(5)
MACHINE_CODE NOT NULL VARCHAR2(20)
JOBDATE NOT NULL DATE
ORGANIZATION_ID NOT NULL NUMBER(15)
MATPROC NUMBER
WASTAGE NUMBER
WASTPER NUMBER
REGRIND NUMBER
COSTKG NUMBER
COSTPC NUMBER
OUTMAN NUMBER
REJECTION NUMBER
UTILI NUMBER
EFFICIENCY NUMBER

Now they want the report in below mentioned format (group by section_code,group_code,machine_code)

------------01-Dec 02-Dec 03-Dec.......... 15-Dec-->(Jobdate field)
Matproc 150 220 170 200
Wastage 8 9 8 8
wastper .77 .99 .87 .98
regrind 1822 2288 2222 5544
costkg .033 .98 .76 .022
costpc .044 .77 .88 .83
outman 8.56 7.56 7.66 4.53
rejection 0 0 0 0
utili 12 12 15 14
effifciency 100 99 99 98


how i am suppose to do this in Oracle reports ..if anybody ahas any type of suggestion please send it as soon as possible..because its like a show stopper for me

regards

MNA