HELP!!! Reports 2.5 Matrix Report Problem

From: Steve Barrett <steve_at_eurovis.demon.co.uk>
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

Original text of this message