If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Matrix report problem

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)

If there are an unknown/variable number of columns, then I would dump the data into Excel and use a Pivot Table. In this case you could "page" by Month.Year and have a reasonable 31 (30, 29, 28) column-wide report for each month.

thanx for ur encouraging reply ... it really give me a move forward to think.. but stilll it didnt solve my problem.. the case is they want to select the date range at report runtime so u cant hardcode the months and dates and secondly .. they want to group by following feilds and date range selected at runtime ... but the thing is these are the column names and in a matrix report we need atleast Three columns to make matrix ...in my case there are only two columns that the date and the below mentioned fields

MATPROC NUMBER
WASTAGE NUMBER
WASTPER NUMBER
REGRIND NUMBER
COSTKG NUMBER
COSTPC NUMBER
OUTMAN NUMBER
REJECTION NUMBER
UTILI NUMBER
EFFICIENCY NUMBER