Conference ilbbak::ibi_focus

423.0. "Formatting problem" by MISERY::BLUM_JO () Sat Jun 08 1991 21:48

    I am trying to produce a report in the following format:

                                GEOGRAPHIC      CS               GRAND
    ADMIN            SALES          CS         DLO               TOTAL
    PORTFOLIO        %    $      %    $      %    $      ...     %    $
    -----------     ---  ---    ---  ---    ---  ---            ---  ---
    CUST. ADMIN                                                 100
    IMT
    SITE SERV
    -----------     ---  ---    ---  ---    ---  ---            ---  ---
    TOTAL ADMIN                                                 100
    (subtotal of above; % would be % of total $ in this row)
    
    
    FINANCE
    
    PERSONNEL
    -----------     ---  ---    ---  ---    ---  ---            ---  ---
    TOTAL OVERHEAD                                              100
    ALLOCATIONS     (grand total of all of above $; % would be % of 
                    total $ in this row)
    
    The functions (Sales, Geogrphic CS, etc.) must be in a specific order,
    and each function has 2 columns, $ (which is the dollars for that
    function within the corresponding portfolio), and % (percent of the
    total $ for the portfolio).  The rows are also in a specific order as
    listed.  I also need one subtotal listed as "TOTAL ADMIN".  "TOTAL
    ADMIN" should appear in the PORTFOLIO column.  The $ columns should
    have a total at the bottom of the report with the phrase "TOTAL
    OVERHEAD ALLOCATIONS" on 2 lines in the PORTFOLIO column.   I've tried
    using "ACROSS ... COLUMNS...", "BY ... ROWS ... OVER ...", and using
    the FRL, but can't get it to come out in this format.  Any ideas on how
    to do this?

    The following fex gives me the data I need as follows:

    TABLE FILE RECV
        SUM CUR_DOL                      AS 'TOTAL,   $   '
        BY PORTFOLIO                     AS 'ADMINITRATION,PORTFOLIO'
        SUM CUR_DOL                      AS '   $   '
            PCT.CUR_DOL WITHIN PORTFOLIO AS '   %   '
        BY PORTFOLIO
        BY FUNCTION
    END


    ADMINITRATION       TOTAL
    PORTFOLIO              $     FUNCTION               $            %
    -------------       -------  --------            -------      -------
    IMT                14,507.4  ADMIN               1,523.6         10.5
                                 DLO CS                216.9          1.5
                                 EIS CT                151.9          1.0
                                 OTHER CS               52.7           .4
                                 SALES               4,071.6         28.1
    SITE SERVICES      36,032.1  ADMIN               4,065.7         11.3
                                 DLO CS                542.9          1.5
                                 EIS CT              1,194.2          3.3
                                 OTHER CS              284.1           .8
                                 SALES               9,078.5         25.2
    
    
    I just can't seem to figure out how to reformat it.  Any help would be
    appreciated.

    John

    I managed to figure out how to do this, but had to change the column
    headings to:
    
                                     CS   CS
                    SALES  SALES    DLO  DLO
                      %      $       %    $
                    -----  -----    ---  --- 
    ADMIN
    PORTFOLIO
    ---------
    
    The fex is around 370 lines and uses alot of FRL RECAPs. 
    
    
    John