Exporting an across-style report

Exported across-style reports include fields not found in standard exported reports

This sample shows an exported across-style report. 

 REPORT                                              LINE 1      POS 1     79
 
                              J & H SUPPLY COMPANY
                              DEPT AVERAGE SALARIES
                            REPORT 18 (ACROSS REPORT)
 
 
           <---------------- JOB ----------------->
           <- CLERK -->  <-- MGR --->  <- SALES -->  <- TOTAL -->
                AVERAGE       AVERAGE       AVERAGE       AVERAGE
     DEPT       SALARY        SALARY        SALARY        SALARY
   ------    ----------    ----------    ----------    ----------
       10                    20865.86                    20865.86
       15      12383.35      20659.80      16502.83      15482.33
       20      13878.68      18357.50      18171.25      16071.53
       38      12482.25      17506.75      17407.15      15457.11
             ==========    ==========    ==========    ==========
               12914.76      19998.21      17372.10      16880.26
 
 
                                  COMPANY NAME
                                    REPORT 18
                                     PAGE 1

The following encoded format is the result of exporting the sample across-style report.

H QMF 20 R 01 E V W E R 02 03 13/01/15 16:20
 
V  1001 006 PERIOD
V  1002 003 016
T  1010 002 006 1013 005 1014 006 1015 006 1016 006 1017 006 1012 008
R  L     000001 000003 000008 000001 GROUP
R  L2    000003 000005 000014 000001 AVERAGE
V  2001 005 C
V  2002 003 001
V  2003 003 YES
T  2010 004 003 2012 006 2013 006 2014 006
R  000014 000018 000009
R  000029 000031 000023
R  000042 000046 000037
R  000056 000060 000051
L  110 10100000                              J & H SUPPLY COMPANY
L  110 10100000                              DEPT AVERAGE SALARIES
L  110 10100000                            REPORT 18 (ACROSS REPORT)
L  110 10000000
L  110 10000000
L  170 10000000           <---------------- JOB ----------------->
L  170 11000000           <- CLERK -->  <-- MGR --->  <- SALES -->  <- TOTAL -->
L  170 10000000                AVERAGE       AVERAGE       AVERAGE       AVERAGE
L  170 10000000     DEPT       SALARY        SALARY        SALARY        SALARY
L  170 10010000   ------    ----------    ----------    ----------    ----------
L  181 11000000       10                    20865.86                    20865.86
L  181 11000000       15      12383.35      20659.80      16502.83      15482.33
L  181 11000000       20      13878.68      18357.50      18171.25      16071.53
L  181 11000000       38      12482.25      17506.75      17407.15      15457.11
L  190 10010000             ==========    ==========    ==========    ==========
L  190 11000000               12914.76      19998.21      17372.10      16880.26
ddL  120 10000000
L  120 10000000
L  120 10100000                                  COMPANY NAME
L  120 10100000                                    REPORT 18
L  120 10100000                                     PAGE 1
E

Table 2 explains field numbers that are common to both standard reports and across-style reports. The following table shows the additional fields that you see in the exported across-style reports.

Table 1. Field numbers for exported across-style report
Field number Record type Description
2001 V Edit code by which across value is formatted
2002 V Number of data lines per across group
2003 V Indicates whether the across summary column exists
     
2010 T Across report table
     
    For each across value:
2012 T Starting position for formatted across value (the across value appears in the column heading lines)
2013 T Ending position for formatted across value
2014 T Starting position for the set of report columns associated with this across value, including preceding indent area

For aggregated columns in an across report, fields 1014, 1015, and 1016 describe the relative starting and ending positions of the field within the set of aggregated columns of an across value. (See field 2014 in the table.)