March 12, 2010, 03:44 PM
Dan McDonaldTexgator,
We had Walter from the helpdesk work with us to get this going along with considerable input from Harry. I think the heirarchy is a little clunky, but they got it working for us.
I am posting all of my code so you can follow along. Pay attention to the compute line:
COMPUTE FMLLIST/A50 = FMLLIST('A4096V'); NOPRINT
We use the drill down to jump to another report for transaction detail, but the concept should be the same for the detail accounts.
I am amazed that the financial community is not not really represented enough on the site. We saved so much money by passing on consolidation software and using WF instead. We are not programmers and we can only understand the GUI application so we may not be able to expand on any additional questions. Anyway, here's the code:
-* File VIEW_PLMQYV.fex
SET PRINTPLUS = OFF
SET CNOTATION = EXPLICIT
SET NODATA = 0
SET FOCEXURL=http://wasprod1:12345/ibi_apps/WFServlet
DEFINE FILE NBGLVIEW1
PERIOD/I4=.
FY/YY=&FY;
CFY/YY=FY;
LFY/YY=FY-1;
MTD/D12.2=IF PERIOD EQ 1 THEN NET01 ELSE IF PERIOD EQ 2 THEN NET02 ELSE IF PERIOD EQ 3 THEN NET03 ELSE IF PERIOD EQ 4 THEN NET04 ELSE IF PERIOD EQ 5 THEN NET05 ELSE IF PERIOD EQ 6 THEN NET06 ELSE IF PERIOD EQ 7 THEN NET07 ELSE IF PERIOD EQ 8 THEN NET08 ELSE IF PERIOD EQ 9 THEN NET09 ELSE IF PERIOD EQ 10 THEN NET10 ELSE IF PERIOD EQ 11 THEN NET11 ELSE IF PERIOD EQ 12 THEN NET12 ELSE 0;
QTD/D12.2=IF PERIOD EQ 1 THEN NET01 ELSE IF PERIOD EQ 2 THEN NET01 + NET02 ELSE IF PERIOD EQ 3 THEN NET01 + NET02 + NET03 ELSE IF PERIOD EQ 4 THEN NET04 ELSE IF PERIOD EQ 5 THEN NET04 + NET05 ELSE IF PERIOD EQ 6 THEN NET04 + NET05 + NET06 ELSE IF PERIOD EQ 7 THEN NET07 ELSE IF PERIOD EQ 8 THEN NET07 + NET08 ELSE IF PERIOD EQ 9 THEN NET07 + NET08 + NET09 ELSE IF PERIOD EQ 10 THEN NET10 ELSE IF PERIOD EQ 11 THEN NET10 + NET11 ELSE IF PERIOD EQ 12 THEN NET10 + NET11 + NET12 ELSE 0;
YTD/D12.2=IF PERIOD EQ 1 THEN NET01 ELSE IF PERIOD EQ 2 THEN NET01 + NET02 ELSE IF PERIOD EQ 3 THEN NET01 + NET02 + NET03 ELSE IF PERIOD EQ 4 THEN NET01 + NET02 + NET03 + NET04 ELSE IF PERIOD EQ 5 THEN NET01 + NET02 + NET03 + NET04 + NET05 ELSE IF PERIOD EQ 6 THEN NET01 + NET02 + NET03 + NET04 + NET05 + NET06 ELSE IF PERIOD EQ 7 THEN NET01 + NET02 + NET03 + NET04 + NET05 + NET06 + NET07 ELSE IF PERIOD EQ 8 THEN NET01 + NET02 + NET03 + NET04 + NET05 + NET06 + NET07 + NET08 ELSE IF PERIOD EQ 9 THEN NET01 + NET02 + NET03 + NET04 + NET05 + NET06 + NET07 + NET08 + NET09 ELSE IF PERIOD EQ 10 THEN NET01 + NET02 + NET03 + NET04 + NET05 + NET06 + NET07 + NET08 + NET09 + NET10 ELSE IF PERIOD EQ 11 THEN NET01 + NET02 + NET03 + NET04 + NET05 + NET06 + NET07 + NET08 + NET09 + NET10 + NET11 ELSE IF PERIOD EQ 12 THEN NET01 + NET02 + NET03 + NET04 + NET05 + NET06 + NET07 + NET08 + NET09 + NET10 + NET11 + NET12 ELSE 0;
CMTD/D12C=IF GAM_FISCAL_YEAR EQ CFY THEN MTD ELSE 0;
LMTD/D12C=IF GAM_FISCAL_YEAR EQ LFY THEN MTD ELSE 0;
CQTD/D12C=IF GAM_FISCAL_YEAR EQ CFY THEN QTD ELSE 0;
LQTD/D12C=IF GAM_FISCAL_YEAR EQ LFY THEN QTD ELSE 0;
CYTD/D12C=IF GAM_FISCAL_YEAR EQ CFY THEN YTD ELSE 0;
LYTD/D12C=IF GAM_FISCAL_YEAR EQ LFY THEN YTD ELSE 0;
CMTDSALES/D12.2=IF (GAM_ACCOUNT GE 40000 AND GAM_ACCOUNT LE 42999) THEN CMTD ELSE 0;
LMTDSALES/D12.2=IF (GAM_ACCOUNT GE 40000 AND GAM_ACCOUNT LE 42999) THEN LMTD ELSE 0;
CQTDSALES/D12.2=IF (GAM_ACCOUNT GE 40000 AND GAM_ACCOUNT LE 42999) THEN CQTD ELSE 0;
LQTDSALES/D12.2=IF (GAM_ACCOUNT GE 40000 AND GAM_ACCOUNT LE 42999) THEN LQTD ELSE 0;
CYTDSALES/D12.2=IF (GAM_ACCOUNT GE 40000 AND GAM_ACCOUNT LE 42999) THEN CYTD ELSE 0;
LYTDSALES/D12.2=IF (GAM_ACCOUNT GE 40000 AND GAM_ACCOUNT LE 42999) THEN LYTD ELSE 0;
MPERIOD/A20=DECODE PERIOD( 1 'MONTH ENDED 10/31' 2 'MONTH ENDED 11/30' 3 'MONTH ENDED 12/31' 4 'MONTH ENDED 1/31' 5 'MONTH ENDED 2/28' 6 'MONTH ENDED 3/31' 7 'MONTH ENDED 4/30' 8 'MONTH ENDED 5/31' 9 'MONTH ENDED 6/30' 10 'MONTH ENDED 7/31' 11 'MONTH ENDED 8/31' 12 'MONTH ENDED 9/30' );
QPERIOD/A20=DECODE PERIOD( 1 '1 MONTH ENDED 10/31' 2 '2 MONTHS ENDED 11/30' 3 '3 MONTHS ENDED 12/31' 4 '1 MONTH ENDED 1/31' 5 '2 MONTHS ENDED 2/28' 6 '3 MONTHS ENDED 3/31' 7 '1 MONTH ENDED 4/30' 8 '2 MONTHS ENDED 5/31' 9 '3 MONTHS ENDED 6/30' 10 '1 MONTH ENDED 7/31' 11 '2 MONTHS ENDED 8/31' 12 '3 MONTHS ENDED 9/30' );
YPERIOD/A20=DECODE PERIOD( 1 '1 MONTH ENDED 10/31' 2 '2 MONTHS ENDED 11/30' 3 '3 MONTHS ENDED 12/31' 4 '4 MONTHS ENDED 1/31' 5 '5 MONTHS ENDED 2/28' 6 '6 MONTHS ENDED 3/31' 7 '7 MONTHS ENDED 4/30' 8 '8 MONTHS ENDED 5/31' 9 '9 MONTHS ENDED 6/30' 10 '10 MONTHS ENDED 7/31' 11 '11 MONTHS ENDED 8/31' 12 '12 MONTHS ENDED 9/30' );
AMVDES/A30=DECODE AMV_MX_VALUE( 'ESTER C' 'ESTER C BRAND' 'ESTER C RM' 'ESTER C RAW MATERIAL' HB 'H and B RETAIL' LENAT 'LE NATURISTE' 'LENAT DR' 'LE NATURISTE DIRECT REPSONSE' PLCMFG 'PL CONTRACT MFG BAYER' 'RETAIL ' 'VITAMIN WORLD' 'REXALL BRAND' 'PRIVATE LABEL CONTROL REXALL' 'SOLGAR' 'SOLGAR US' 'INTL REG CAN' 'NBTY CANADA' 'VW LTD' 'HB DIRECT');
END
TABLE FILE NBGLVIEW1
SUM
'NBGLVIEW1.NBGLVIEW1.CMTD/D12CB' AS 'Current,MTD'
'NBGLVIEW1.NBGLVIEW1.CMTDSALES' WITHIN AMV_MX_VALUE NOPRINT
COMPUTE PERCMTD/D7.2B% = CMTD / C2 * 100; AS '%Sales'
'NBGLVIEW1.NBGLVIEW1.LMTD/D10CB' AS 'Prior,MTD'
'NBGLVIEW1.NBGLVIEW1.LMTDSALES' WITHIN AMV_MX_VALUE NOPRINT
COMPUTE PERLMTD/D7.2CB% = LMTD / C5 * 100; AS '%Sales'
COMPUTE MVAR/D10CB = CMTD - LMTD; AS 'Variance'
COMPUTE MVARPER/D7.2B% = MVAR / LMTD * 100; AS '%Var'
'NBGLVIEW1.NBGLVIEW1.CYTD/D13B' AS 'Current,YTD'
'NBGLVIEW1.NBGLVIEW1.CYTDSALES' WITHIN AMV_MX_VALUE NOPRINT
COMPUTE PERCYTD/D7.2B% = CYTD / C10 * 100; AS '%Sales'
'NBGLVIEW1.NBGLVIEW1.LYTD/D13B' AS 'Prior,YTD'
'NBGLVIEW1.NBGLVIEW1.LYTDSALES' WITHIN AMV_MX_VALUE NOPRINT
COMPUTE PERLYTD/D7.2B% = LYTD / C13 * 100; AS '%Sales'
COMPUTE YVAR/D10B = CYTD - LYTD; AS 'Variance'
COMPUTE YVARPER/D7.2B% = YVAR / LYTD * 100; AS '%Var'
COMPUTE FMLLIST/A50 = FMLLIST('A4096V'); NOPRINT
BY 'NBGLVIEW1.NBGLVIEW1.AMV_MX_VALUE' NOPRINT
FOR
'NBGLVIEW1.NBGLVIEW1.GAC_MX_VALUE'
'SALES' AS 'SALES' LABEL R1 WHEN EXISTS OVER
'COGS' AS 'COGS' LABEL R2 WHEN EXISTS OVER
BAR AS '-' OVER
RECAP R4(1)/D12C=(R1-R2);
R4(3)=R4(1) / R1(2) * 100;
R4(4)/D12C=(R1-R2);
R4(6)=R4(4) / R1(5) * 100;
R4(7)/D12CB=(R1-R2);
R4(8)=R4(7) / R4(4) * 100;
R4(9)/D12C=(R1-R2);
R4(11)=R4(9) / R1(10) * 100;
R4(12)/D12C=(R1-R2);
R4(14)=R4(12) / R1(12) * 100;
R4(15)/D12CB=(R1-R2);
R4(16)=R4(15) / R4(12) * 100;
AS 'GROSS PROFIT' OVER
" " LABEL R5 OVER
"<2 ADVERTISING, PROMOS, CATALOGS" LABEL R6 OVER
'ADVERTISING' AS 'ADVERTISING, PROMOS & MEDIA' LABEL R7 WHEN EXISTS OVER
'CATALOG' AS 'CATALOG PRINTING AND MAILING' LABEL R8 WHEN EXISTS OVER
BAR AS '-' OVER
RECAP R10(1)=R7+R8;
R10(3)=R10(1) / R1(2) * 100;
R10(4)=R7+R8;
R10(6)=R10(4) / R1(5) * 100;
R10(7)/D12CB=R7+R8;
R10(8)=R10(7) / R10(4) * 100;
R10(9)=R7+R8;
R10(11)=R10(9) / R1(10) * 100;
R10(12)=R7+R8;
R10(14)=R10(12) / R1(12) * 100;
R10(15)=R7+R8;
R10(16)=R10(15) / R10(12) * 100;
AS 'TOTAL ADVERTISING PROMO EXP' OVER
" " LABEL R11 OVER
"<2 SELLING, GENERAL & ADMIN EXP" LABEL R12 OVER
'DIRECT LABOR' OR 'SALARIES' AS 'SALARIES & WAGES' LABEL R13 WHEN EXISTS OVER
'FRINGES' AS 'PAYROLL FRINGE BENEFITS' LABEL R14 WHEN EXISTS OVER
'SUPPLIES' AS 'STATIONERY & SUPPLIES' LABEL R15 WHEN EXISTS OVER
'BUILDING' AS 'BUILDING' LABEL R16 WHEN EXISTS OVER
'REPAIRS' AS 'REPAIRS & MAINTENANCE' LABEL R17 WHEN EXISTS OVER
'POSTAGE' AS 'POSTAGE' LABEL R18 WHEN EXISTS OVER
'TELEPHONE' AS 'TELEPHONE' LABEL R19 WHEN EXISTS OVER
'TE' AS 'TRAVEL, AUTO & ENTERTAINMENT' LABEL R20 WHEN EXISTS OVER
'SERVICES' AS 'OUTSIDE SERVICES' LABEL R21 WHEN EXISTS OVER
'PROF FEES' AS 'PROFESSIONAL & LEGAL' LABEL R22 WHEN EXISTS OVER
'FREIGHT' AS 'FREIGHT' LABEL R23 WHEN EXISTS OVER
'TAXES' AS 'TAXES- REAL ESTATE/LOCAL' LABEL R24 WHEN EXISTS OVER
'OTHER' AS 'OTHER' LABEL R25 WHEN EXISTS OVER
'COMMISSIONS' AS 'COMMISSIONS TO BROKERS' LABEL R26 WHEN EXISTS OVER
'INSURANCE' AS 'INSURANCE' LABEL R27 WHEN EXISTS OVER
'DEPRECIATION' AS 'DEPRECIATION / AMORT OF PPE' LABEL R28 WHEN EXISTS OVER
'AMORTIZATION' AS 'AMORTIZATION OF INTANGIBLES' LABEL R29 WHEN EXISTS OVER
'SGA ALLOCS' OR 'MFG ALLOCS' AS 'SGA ALLOCATIONS' LABEL R30 WHEN EXISTS OVER
'CORPOPALL' AS 'CORP OPERATING ALLOCS' LABEL R31 OVER
BAR AS '-' OVER
RECAP R33(1)=R13+R14+R15+R16+R17+R18+R19+R20+R21+R22+R23+R24+R25+R26+R27+R28+R29+R30+R31;
R33(3)=R33(1) / R1(2) * 100;
R33(4)=R13+R14+R15+R16+R17+R18+R19+R20+R21+R22+R23+R24+R25+R26+R27+R28+R29+R30+R31;
R33(6)=R33(4) / R1(5) * 100;
R33(7)=R13+R14+R15+R16+R17+R18+R19+R20+R21+R22+R23+R24+R25+R26+R27+R28+R29+R30+R31;
R33(8)/D12.2B=R33(7) / R33(4) * 100;
R33(9)=R13+R14+R15+R16+R17+R18+R19+R20+R21+R22+R23+R24+R25+R26+R27+R28+R29+R30+R31;
R33(11)=R33(9) / R1(10) * 100;
R33(12)=R13+R14+R15+R16+R17+R18+R19+R20+R21+R22+R23+R24+R25+R26+R27+R28+R29+R30+R31;
R33(14)=R33(12) / R1(12) * 100;
R33(15)=R13+R14+R15+R16+R17+R18+R19+R20+R21+R22+R23+R24+R25+R26+R27+R28+R29+R30+R31;
R33(16)/D12.2B=R33(15) / R33(12) * 100;
AS 'TOTAL SELLING, GEN. & ADMIN.' OVER
" " LABEL R34 OVER
RECAP R35(1)=R10+R33;
R35(3)=R35(1) / R1(2) * 100;
R35(4)=R10+R33;
R35(6)=R35(4) / R1(5) * 100;
R35(7)=R10+R33;
R35(8)=R35(7) / R35(4) * 100;
R35(9)=R10+R33;
R35(11)=R35(9) / R1(10) * 100;
R35(12)=R10+R33;
R35(14)=R35(12) / R1(12) * 100;
R35(15)=R10+R33;
R35(16)=R35(15) / R35(12) * 100;
AS 'TOTAL EXPENSES' OVER
BAR AS '-' OVER
" " LABEL R37 OVER
RECAP R38(1)=R4 - R35;
R38(3)=R38(1) / R1(2) * 100;
R38(4)=R4 - R35;
R38(6)=R38(4) / R1(5) * 100;
R38(7)=R4 - R35;
R38(8)=R38(7) / R38(4) * 100;
R38(9)=R4 - R35;
R38(11)=R38(9) / R1(10) * 100;
R38(12)=R4 - R35;
R38(14)=R38(12) / R1(12) * 100;
R38(15)=R4 - R35;
R38(16)=R38(15) / R38(12) * 100;
AS 'OPERATING INCOME (LOSS)'
ON NBGLVIEW1.NBGLVIEW1.AMV_MX_VALUE PAGE-BREAK
HEADING
"Date: &DATEtrMDYY CONSOLIDATED STATEMENTS OF INCOME<+0>NBTY, INC. AND SUBSIDIARIES<+0> "
"Time: &TOD<+0>STATEMENT OF PROFIT (LOSS)<+0> "
"Report: &FOCFEXNAME<+0> <+0> "
"
"Brand / Division <+0> <+0> <+0> "
"ON TABLE SUBFOOT
""
WHERE ( GAC_MATRIX_CAT EQ 'SECSUM' ) AND ( AMV_MATRIX_CAT EQ 'DIVISIONNBTY' ) AND ( GLS_CURRENCY_CODE EQ 'USD' ) AND ( AMV_MX_VALUE NE 'MFG' );
WHERE AMV_MX_VALUE EQ &AMV_MX_VALUE.(OR(FIND BRAND IN brand)).Brand / Division.;
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT ,
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.125000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=7,
LEFTGAP=0.055556,
$
TYPE=DATA,
COLUMN=N2,
SIZE=7,
$
TYPE=DATA,
COLUMN=N3,
SIZE=7,
FOCEXEC=transactions_brand_drilldown( \
AMV_MX_VALUE=NBGLVIEW1.NBGLVIEW1.AMV_MX_VALUE \
GAC_MX_VALUE=FMLLIST \
FY='&FY' \
GLT_ACCT_PERIOD='&PERIOD' \
),
$
TYPE=DATA,
COLUMN=N6,
SIZE=7,
FOCEXEC=transactions_brand_drilldown( \
AMV_MX_VALUE=NBGLVIEW1.NBGLVIEW1.AMV_MX_VALUE \
GAC_MX_VALUE=FMLLIST \
FY= \
GLT_ACCT_PERIOD='&PERIOD' \
),
$
TYPE=DATA,
COLUMN=N13,
SIZE=7,
$
TYPE=DATA,
COLUMN=N16,
SIZE=7,
$
TYPE=DATA,
COLUMN=N17,
SIZE=7,
$
TYPE=DATA,
COLUMN=N18,
SIZE=7,
$
TYPE=DATA,
COLUMN=N10,
BORDER-RIGHT=MEDIUM,
SIZE=7,
$
TYPE=DATA,
COLUMN=N9,
SIZE=7,
$
TYPE=DATA,
COLUMN=N8,
SIZE=7,
$
TYPE=DATA,
COLUMN=N1,
SIZE=7,
$
TYPE=DATA,
COLUMN=N14,
SIZE=7,
$
TYPE=DATA,
COLUMN=N11,
SIZE=7,
$
TYPE=DATA,
COLUMN=N5,
SIZE=7,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N2,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N3,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N6,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N13,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N16,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N17,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N18,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N10,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N9,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N8,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N1,
SIZE=5,
$
TYPE=TITLE,
COLUMN=N14,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N11,
SIZE=7,
$
TYPE=TITLE,
COLUMN=N5,
SIZE=7,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=4.250,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
SIZE=7,
WIDTH=3.625,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
SIZE=6,
JUSTIFY=RIGHT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=3.625,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=2,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=4.250,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
SIZE=7,
WIDTH=3.625,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=4,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=1,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=3.625,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=2,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.375,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=4,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=5,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=3.125,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
SIZE=6,
WIDTH=3.625,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=1,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=3.000,
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=2,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.375,
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=4,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=5,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=3.625,
$
TYPE=HEADING,
LINE=4,
OBJECT=TEXT,
ITEM=2,
SIZE=6,
WIDTH=3.625,
$
TYPE=HEADING,
LINE=4,
OBJECT=TEXT,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=4,
OBJECT=FIELD,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=3.125,
$
TYPE=HEADING,
LINE=4,
OBJECT=FIELD,
ITEM=2,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=4,
OBJECT=FIELD,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.125,
$
TYPE=HEADING,
LINE=4,
OBJECT=FIELD,
ITEM=4,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=HEADING,
LINE=4,
OBJECT=FIELD,
ITEM=5,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.125,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=2,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.750,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.500,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.625,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=5,
JUSTIFY=LEFT,
WIDTH=4.000,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=6,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.500,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=2,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=3,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.375,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=4,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=1.250,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=5,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.125,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=2,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.750,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=3,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=1.500,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=4,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=.625,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=5,
JUSTIFY=LEFT,
WIDTH=4.000,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=6,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=7,
SIZE=6,
JUSTIFY=LEFT,
WIDTH=2.375,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=1,
SIZE=7,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=2,
SIZE=7,
POSITION='N3',
JUSTIFY=RIGHT,
WIDTH=.875,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=3,
SIZE=7,
POSITION='N6',
JUSTIFY=RIGHT,
WIDTH=.750,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=4,
SIZE=7,
POSITION='N11',
JUSTIFY=RIGHT,
WIDTH=.875,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=5,
SIZE=7,
POSITION='N14',
JUSTIFY=RIGHT,
WIDTH=.875,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
BORDER-TOP=OFF,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
BORDER-TOP-STYLE=DASHED,
BORDER-BOTTOM-STYLE=DASHED,
BORDER-LEFT-STYLE=DASHED,
BORDER-RIGHT-STYLE=DASHED,
SIZE=9,
$
TYPE=ACROSSTITLE,
BORDER-BOTTOM=LIGHT,
BORDER-BOTTOM-STYLE=DASHED,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
TYPE=FREETEXT,
SIZE=7,
$
ENDSTYLE
END