February 24, 2011, 03:50 PM
jseaburnHere is the code for the procedure I am trying to reference in Document Composer:
-SET &ECHO = ALL;
SET NODATA = 0
SET SHOWBLANKS = ON
SET TRACEOFF = ALL
SET TRACEON = SQLAGGR//CLIENT
SET TRACEON = SQLAGGR//CLIENT
SET TRACEUSER = ON
-RUN
-SET &EndDate = '01/31/2011'
-*==========DATE LOGIC=====================================================================
-SET &EndDateYYYY = EDIT(&EndDate, '$$$$$$9999');
-SET &EndDateMM = EDIT(&EndDate, '99');
-SET &EndDateDD = EDIT(&EndDate, '$$$99');
-SET &EndDateFY = IF &EndDateMM EQ '11' OR '12' THEN &EndDateYYYY ELSE &EndDateYYYY - 1;
-SET &BeginDateFY = '11/01/' || &EndDateFY;
-SET &BeginDateFY2 = &EndDateFY || '-11-01';
-SET &PrevEndDateFY = &EndDateFY - 1;
-SET &PrevBeginDateFY = '11/01/' || &PrevEndDateFY;
-SET &PrevBeginDateFY2 = &PrevEndDateFY || '-11-01';
-SET &BeginDate = &EndDateMM || '/01/' || &EndDateYYYY;
-SET &BeginDateYYYY = EDIT(&BeginDate, '$$$$$$9999');
-SET &BeginDateMM = EDIT(&BeginDate, '99');
-SET &BeginDateDD = EDIT(&BeginDate, '$$$99');
-SET &BeginDate2 = &BeginDateYYYY || '-' || &BeginDateMM || '-' || &BeginDateDD;
-SET &EndDate2 = &EndDateYYYY || '-' || &EndDateMM || '-' || &EndDateDD;
-SET &LastBeginYear = &BeginDateYYYY - 1;
-SET &PrevBeginDate = &LastBeginYear || '-' || &BeginDateMM || '-' || &BeginDateDD;
-SET &LastEndYear = &EndDateYYYY - 1;
-SET &PrevEndDate = &LastEndYear || '-' || &EndDateMM || '-' || &EndDateDD;
-SET &PrevBeginDate2 = &BeginDateMM || '/' || &BeginDateDD || '/' || &LastBeginYear;
-SET &PrevEndDate2 = &EndDateMM || '/' || &EndDateDD || '/' || &LastEndYear;
-SET &CurrentFY = &EndDateFY + 1;
-SET &PreviousFY = &EndDateFY;
-*==========================================================================================
-INCLUDE app/sales_complete_join.fex
-DEFAULT &EndDate = '01/31/2011'
JOIN
SALES_COMPLETE_US.SALES_COMPLETE_US.CUSTOMER_ID IN SALES_COMPLETE_US TO UNIQUE
HERCDIVEUGOALSSQL.HERCDIVEUGOALSSQL.CUSTOMER_ID IN HERCDIVEUGOALSSQL TAG J4 AS J4
END
DEFINE FILE SALES_COMPLETE_US
GL_MNTH/M=GL_DATE;
GL_YEAR/YY=GL_DATE;
RPT_MNTH/M=&EndDateMM;
GL_YR_FY/YY=IF GL_MNTH EQ 11 OR 12 THEN GL_YEAR+1 ELSE GL_YEAR;
EU/I10=IF GL_MNTH EQ &BeginDateMM THEN SALES_COMPLETE_US.SALES_COMPLETE_US.QTY * J1.PRODUCTS_US.EQUIV_UNIT ELSE 0;
MTD_QTY/I10=IF GL_MNTH EQ &BeginDateMM THEN SALES_COMPLETE_US.SALES_COMPLETE_US.QTY ELSE 0;
EU_YTD/I10=SALES_COMPLETE_US.SALES_COMPLETE_US.QTY * J1.PRODUCTS_US.EQUIV_UNIT;
MTD_SLS/D12.2CM=IF &BeginDateMM EQ GL_MNTH THEN SALES_COMPLETE_US.SALES_COMPLETE_US.EXTENDED_FET_PRICE ELSE 0;
PSVDA/I10=IF (( J1.PRODUCTS_US.CATEGORY EQ 'PASSENGER' OR 'LIGHT TRUCK') AND ( GL_MNTH EQ &BeginDateMM ) AND ( GL_YR_FY EQ &CurrentFY )) THEN ( SALES_COMPLETE_US.SALES_COMPLETE_US.QTY * J1.PRODUCTS_US.EQUIV_UNIT ) ELSE 0;
YTDEUPS/I10=IF (( J1.PRODUCTS_US.CATEGORY EQ 'PASSENGER' OR 'LIGHT TRUCK') AND ( GL_YR_FY EQ &CurrentFY )) THEN ( SALES_COMPLETE_US.SALES_COMPLETE_US.QTY * J1.PRODUCTS_US.EQUIV_UNIT ) ELSE 0;
END
TABLE FILE SALES_COMPLETE_US
PRINT
COMPUTE CY_MTD_QTY/I10 = IF GL_YR_FY EQ &CurrentFY THEN SALES_COMPLETE_US.SALES_COMPLETE_US.MTD_QTY ELSE 0;
COMPUTE CY_YTD_QTY/I10 = IF GL_YR_FY EQ &CurrentFY THEN SALES_COMPLETE_US.SALES_COMPLETE_US.QTY ELSE 0;
COMPUTE CY_MTD_EU/I10 = IF GL_YR_FY EQ &CurrentFY THEN J1.PRODUCTS_US.EU ELSE 0;
COMPUTE CY_YTD_EU/I10 = IF GL_YR_FY EQ &CurrentFY THEN J1.PRODUCTS_US.EU_YTD ELSE 0;
COMPUTE CY_MTD_AMT/P12.2CM = IF GL_YR_FY EQ &CurrentFY THEN SALES_COMPLETE_US.SALES_COMPLETE_US.MTD_SLS ELSE 0;
COMPUTE CY_YTD_AMT/P12.2CM = IF GL_YR_FY EQ &CurrentFY THEN SALES_COMPLETE_US.SALES_COMPLETE_US.EXTENDED_FET_PRICE ELSE 0;
COMPUTE PY_MTD_QTY/I10 = IF GL_YR_FY EQ &PreviousFY THEN SALES_COMPLETE_US.SALES_COMPLETE_US.MTD_QTY ELSE 0;
COMPUTE PY_YTD_QTY/I10 = IF GL_YR_FY EQ &PreviousFY THEN SALES_COMPLETE_US.SALES_COMPLETE_US.QTY ELSE 0;
COMPUTE PY_MTD_EU/I10 = IF GL_YR_FY EQ &PreviousFY THEN J1.PRODUCTS_US.EU ELSE 0;
COMPUTE PY_YTD_EU/I10 = IF GL_YR_FY EQ &PreviousFY THEN J1.PRODUCTS_US.EU_YTD ELSE 0;
COMPUTE PY_MTD_AMT/P12.2CM = IF GL_YR_FY EQ &PreviousFY THEN SALES_COMPLETE_US.SALES_COMPLETE_US.MTD_SLS ELSE 0;
COMPUTE PY_YTD_AMT/P12.2CM = IF GL_YR_FY EQ &PreviousFY THEN SALES_COMPLETE_US.SALES_COMPLETE_US.EXTENDED_FET_PRICE ELSE 0;
'J1.PRODUCTS_US.YTDEUPS'
RPT_MNTH
BY 'SALES_COMPLETE_US.SALES_COMPLETE_US.CUSTOMER_ID'
BY 'J1.PRODUCTS_US.COMMODITY_CODE'
HEADING
""
FOOTING
""
WHERE SALES_COMPLETE_US.SALES_COMPLETE_US.PR_BR EQ 3;
WHERE (( SALES_COMPLETE_US.SALES_COMPLETE_US.GL_DATE_MDYY GE '&BeginDateFY' ) AND ( SALES_COMPLETE_US.SALES_COMPLETE_US.GL_DATE_MDYY LE '&EndDate' )) OR
(( SALES_COMPLETE_US.SALES_COMPLETE_US.GL_DATE_MDYY GE '&PrevBeginDateFY' ) AND ( SALES_COMPLETE_US.SALES_COMPLETE_US.GL_DATE_MDYY LE '&PrevEndDate2'));
WHERE J1.PRODUCTS_US.COMMODITY_CODE NE 'MISC' OR 'ADVERTISING';
WHERE J1.PRODUCTS_US.BRAND EQ 'HERCULES' OR 'MERIT' OR 'AVALANCHE' OR 'ELECTRA' OR 'IRONMAN' OR 'SIGNET' OR 'SUPERIOR' OR 'ROAD FORCE' OR 'ROADFORCE' OR 'DEESTONE';
WHERE EDIT(J1.PRODUCTS_US.COMMODITY_CODE,'9999999') NE 'BRANDED' OR 'FREIGHT';
WHERE J1.PRODUCTS_US.CATEGORY EQ 'PASSENGER' OR 'LIGHT TRUCK';
WHERE SALES_COMPLETE_US.SALES_COMPLETE_US.CUSTOMER_ID EQ J4.HERCDIVEUGOALSSQL.CUSTOMER_ID;
ON TABLE HOLD AS EUHOLD FORMAT ALPHA
END
JOIN
EUHOLD.EUHOLD.CUSTOMER_ID IN EUHOLD TO UNIQUE
HERCDIVEUGOALSSQL.HERCDIVEUGOALSSQL.CUSTOMER_ID IN HERCDIVEUGOALSSQL TAG J7 AS J7
END
TABLE FILE EUHOLD
SUM
YTDEUPS
BY CUSTOMER_ID
ON TABLE HOLD AS EUHOLD2 FORMAT ALPHA
END
JOIN
EUHOLD.EUHOLD.CUSTOMER_ID IN EUHOLD TO UNIQUE
CUSTOMER_US.CUSTOMER_US.CUSTOMER_ID IN CUSTOMER_US TAG J5 AS J5
END
JOIN
EUHOLD.EUHOLD.CUSTOMER_ID IN EUHOLD TO UNIQUE
EUHOLD2.EUHOLD2.CUSTOMER_ID IN EUHOLD2 TAG J8 AS J8
END
DEFINE FILE EUHOLD
ADDR_TMP/A200 = IF ADDRESS_LINE_2 NE '' THEN ADDRESS_LINE_1 | '_' | ' ' | ADDRESS_LINE_2 ELSE ADDRESS_LINE_1;
ADDR/A200 = CTRAN(200,ADDR_TMP,95,10,ADDR);
END
TABLE FILE EUHOLD
SUM
'EUHOLD.EUHOLD.CY_MTD_QTY' AS '&CurrentFY,Units,MTD'
'EUHOLD.EUHOLD.CY_YTD_QTY' AS 'YTD'
'EUHOLD.EUHOLD.CY_MTD_EU' AS 'EUs,MTD'
'EUHOLD.EUHOLD.CY_YTD_EU' AS 'YTD'
'EUHOLD.EUHOLD.CY_MTD_AMT' AS 'Inv Dollar,MTD'
'EUHOLD.EUHOLD.CY_YTD_AMT' AS 'YTD'
'EUHOLD.EUHOLD.PY_MTD_QTY' AS '&PreviousFY,Units,MTD'
'EUHOLD.EUHOLD.PY_YTD_QTY' AS 'YTD'
'EUHOLD.EUHOLD.PY_MTD_EU' AS 'EUs,MTD'
'EUHOLD.EUHOLD.PY_YTD_EU' AS 'YTD'
'EUHOLD.EUHOLD.PY_MTD_AMT' AS 'Inv Dollar,MTD'
'EUHOLD.EUHOLD.PY_YTD_AMT' AS 'YTD'
'EUHOLD.EUHOLD.YTDEUPS' NOPRINT
BY 'J7.HERCDIVEUGOALSSQL.CUSTOMER_ID' NOPRINT
BY 'EUHOLD.EUHOLD.COMMODITY_CODE' AS 'Commodity Code'
ON J7.HERCDIVEUGOALSSQL.CUSTOMER_ID SUBTOTAL AS 'TOTAL'
HEADING
"Total Actual/Equivalent Units & Dollars for &BeginDateFY2 through &EndDate2"
"Compared to Last Year"
" "
"CONSUMER PRODUCTS"
" "
"<NAME"
"<ADDR"
"<CITY , <STATE <ZIP_CODE "
" "
FOOTING
""
ON TABLE SET EMPTYCELLS OFF
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
$
TYPE=DATA,
COLUMN=N10,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N12,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N14,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N2,
BORDER-RIGHT=MEDIUM,
$
TYPE=DATA,
COLUMN=N6,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N3,
BORDER-RIGHT=OFF,
$
TYPE=DATA,
COLUMN=N4,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
COLUMN=N8,
BORDER-RIGHT=HEAVY,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N10,
BORDER-BOTTOM=MEDIUM,
BORDER-RIGHT=LIGHT,
$
TYPE=TITLE,
COLUMN=N12,
BORDER-BOTTOM=MEDIUM,
BORDER-RIGHT=LIGHT,
$
TYPE=TITLE,
COLUMN=N14,
BORDER-BOTTOM=MEDIUM,
BORDER-RIGHT=LIGHT,
$
TYPE=TITLE,
COLUMN=N2,
STYLE=ITALIC,
$
TYPE=TITLE,
COLUMN=N6,
BORDER-BOTTOM=MEDIUM,
BORDER-RIGHT=LIGHT,
$
TYPE=TITLE,
COLUMN=N3,
BORDER-BOTTOM=MEDIUM,
BORDER-RIGHT=OFF,
$
TYPE=TITLE,
COLUMN=N4,
BORDER-BOTTOM=MEDIUM,
BORDER-RIGHT=LIGHT,
$
TYPE=TITLE,
COLUMN=N8,
BORDER-BOTTOM=MEDIUM,
BORDER-RIGHT=HEAVY,
$
TYPE=TITLE,
COLUMN=N9,
BORDER-BOTTOM=MEDIUM,
$
TYPE=TITLE,
COLUMN=N11,
BORDER-BOTTOM=MEDIUM,
$
TYPE=TITLE,
COLUMN=N13,
BORDER-BOTTOM=MEDIUM,
$
TYPE=TITLE,
COLUMN=N5,
BORDER-BOTTOM=MEDIUM,
$
TYPE=TITLE,
COLUMN=N7,
BORDER-BOTTOM=MEDIUM,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=6.375,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=2.125,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=1.375,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=4.000,
$
TYPE=HEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
SIZE=11,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=HEADING,
LINE=4,
OBJECT=TEXT,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=1.125,
$
TYPE=HEADING,
LINE=4,
OBJECT=FIELD,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=4.000,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=1.125,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=4.000,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=2.250,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=2.250,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=3,
JUSTIFY=LEFT,
WIDTH=.250,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=4,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=1,
FONT='TIMES NEW ROMAN',
SIZE=11,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.625,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=2,
JUSTIFY=LEFT,
WIDTH=.375,
$
TYPE=HEADING,
LINE=6,
OBJECT=FIELD,
ITEM=3,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=7,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=7,
OBJECT=FIELD,
ITEM=1,
FONT='TIMES NEW ROMAN',
SIZE=11,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.625,
$
TYPE=HEADING,
LINE=8,
OBJECT=TEXT,
ITEM=1,
FONT='TIMES NEW ROMAN',
SIZE=11,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.264,
$
TYPE=HEADING,
LINE=8,
OBJECT=TEXT,
ITEM=2,
FONT='TIMES NEW ROMAN',
SIZE=11,
JUSTIFY=LEFT,
WIDTH=.389,
$
TYPE=HEADING,
LINE=8,
OBJECT=TEXT,
ITEM=3,
JUSTIFY=LEFT,
WIDTH=.181,
$
TYPE=HEADING,
LINE=8,
OBJECT=TEXT,
ITEM=4,
JUSTIFY=LEFT,
WIDTH=.181,
$
TYPE=HEADING,
LINE=8,
OBJECT=FIELD,
ITEM=1,
FONT='TIMES NEW ROMAN',
SIZE=11,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.556,
$
TYPE=HEADING,
LINE=8,
OBJECT=FIELD,
ITEM=2,
FONT='TIMES NEW ROMAN',
SIZE=11,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=.792,
$
TYPE=HEADING,
LINE=8,
OBJECT=FIELD,
ITEM=3,
FONT='TIMES NEW ROMAN',
SIZE=11,
STYLE=NORMAL,
JUSTIFY=LEFT,
WIDTH=1.056,
$
TYPE=HEADING,
LINE=9,
OBJECT=TEXT,
ITEM=1,
JUSTIFY=LEFT,
WIDTH=.181,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=TEXT,
ITEM=1,
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=2,
OBJECT=TEXT,
ITEM=1,
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=2,
OBJECT=TEXT,
ITEM=3,
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=2,
OBJECT=TEXT,
ITEM=5,
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=2,
OBJECT=TEXT,
ITEM=9,
STYLE=BOLD+UNDERLINE,
$
TYPE=SUBFOOT,
BY=1,
LINE=2,
OBJECT=TEXT,
ITEM=10,
COLOR='RED',
$
TYPE=SUBFOOT,
BY=1,
LINE=2,
OBJECT=TEXT,
ITEM=11,
SIZE=9,
COLOR='RED',
$
TYPE=SUBFOOT,
BY=1,
LINE=2,
OBJECT=FIELD,
ITEM=1,
SIZE=9,
COLOR='RED',
BACKCOLOR=RGB(205 205 205),
$
TYPE=SUBFOOT,
BY=1,
LINE=2,
OBJECT=FIELD,
ITEM=2,
SIZE=9,
COLOR='RED',
$
TYPE=SUBFOOT,
BY=1,
LINE=2,
OBJECT=FIELD,
ITEM=3,
SIZE=9,
COLOR='RED',
$
TYPE=SUBFOOT,
BY=1,
LINE=2,
OBJECT=FIELD,
ITEM=4,
SIZE=9,
COLOR='RED',
$
TYPE=SUBFOOT,
BY=1,
LINE=3,
OBJECT=TEXT,
ITEM=2,
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=3,
OBJECT=TEXT,
ITEM=3,
SIZE=9,
COLOR='RED',
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=3,
OBJECT=TEXT,
ITEM=4,
SIZE=9,
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=3,
OBJECT=TEXT,
ITEM=5,
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=3,
OBJECT=TEXT,
ITEM=8,
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=3,
OBJECT=TEXT,
ITEM=9,
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=3,
OBJECT=TEXT,
ITEM=12,
COLOR='RED',
$
TYPE=SUBFOOT,
BY=1,
LINE=3,
OBJECT=TEXT,
ITEM=13,
SIZE=9,
COLOR='RED',
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=3,
OBJECT=FIELD,
ITEM=1,
SIZE=9,
COLOR='RED',
BACKCOLOR=RGB(205 205 205),
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=3,
OBJECT=FIELD,
ITEM=2,
SIZE=9,
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=3,
OBJECT=FIELD,
ITEM=3,
SIZE=9,
COLOR='RED',
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=3,
OBJECT=FIELD,
ITEM=4,
SIZE=9,
COLOR='RED',
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=4,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=5,
OBJECT=TEXT,
ITEM=2,
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=5,
OBJECT=TEXT,
ITEM=3,
SIZE=9,
STYLE=NORMAL,
$
TYPE=SUBFOOT,
BY=1,
LINE=5,
OBJECT=FIELD,
ITEM=1,
SIZE=9,
STYLE=NORMAL,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=SUBTOTAL,
BY=1,
BACKCOLOR=RGB(218 218 218),
STYLE=BOLD,
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END
It runs fine if I just run it from Dev Studio, but it gives me an error when it tries to reference in the document. I can't copy/paste the error because it won't let me highlight the text.
It says that it can't find my hold file named EUHOLD. I get that same error 4 different times.
I think it's just a compound report? This is the first component I'm trying to add to the document. The only other thing I will need is some static text and charts that I will just create for the doc.
Thank you.