HELP!!! Reports 2.5 Matrix Report Problem
Date: 1996/12/08
Message-ID: <qipARDANFuqyEwmm_at_eurovis.demon.co.uk>#1/1
I am having great difficulty producing a particular layout using Reports 2.5 for a Matrix style report. When the matrix overflows to the next page (right) I only want to print some of the "row" columns and so allowing the overflowing matrix to use more of the page without over duplicating information already printed. I have tried using anchors but with matrix reports these appear to mess up the layout.
Using the following report based on the emp table as an example can anyone help ???
Query :-
select job,deptno,ename,sum(sal) from emp group by job,deptno,ename
Data Model :-
DeptJobBreakGroup ----------------- Job Deptno EmpnoBreakGroup --------------- Ename SalGroup -------- sum(sal) All groups contained within a matrix group G_Cross. EnameBreakGroup layout direction is across all the rest down.
Required Layout
(First Page)
Job Deptno SMITH HARRY JONES EVANS === ====== ===== ===== ===== ===== SALESMAN 10 500 PRESIDENT 20 1000 MANAGER 30 CLEANER 10 50
(Overflow Page)
Job CARTER HOLMES ELLISON GATES PEARLY === ====== ====== ======= ===== ====== SALESMAN 50 PRESIDENT 2000 9000 5000 MANAGER 900 CLEANER
i.e Deptno doesn't print on overflow page and matrix moves in to use up the space.
As I have said I have tried using anchors but the display of the matrix on overflowing pages gets screwed up. I have tried separate query layouts but anchors still cause a problem. The best I have managed is to have the job column in a query in the left hand margin, the deptno a query on the body but does not overflow so will not print on overflow page. this only works however if there is enough of a page to print all the jobs (i.e. report does not overflow downwards).
Any solutions out there would be much appreciated.
Cheers
Steve
\\|// Steve Barrett (o o) steve_at_eurovis.demon.co.uk ~~~~~~~~~~~~oOOo~( )~oOOo~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ( ) ( ) (_)Received on Sun Dec 08 1996 - 00:00:00 CET