I'm hoping someone can give me a synopsis of what I need to know about passing parameters in to PDF documents via Document Composer. Yes, I've searched the forum and I have all of my books open on my desk and I have searched documentation. I even asked an SE at IBI but she doesn't have the time to respond.

I've tried creating 2 documents via this composer. When I add a report component, and I 'reference an existing procedure', my procedure bombs out and tells me my Hold files don't exist. Both documents I've tried has a parameter the user enters of End Date. In the .fex, I have this defaulted.

Are there 'tricks' I need to know about getting parameters and/or hold files to render correctly when I pull them in to Document Composer?

Going on 2 days worth of trying to figure this out and I'm afraid to post on here without doing my own research first.

Any advice is appreciated.

This message has been edited. Last edited by: jseaburn,

What sort of document is it ? Compound, Coordinated compound ?

Can you post you code ?

What is the exact error message ?

A step by step explanation would be useful as well.

Here 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.

Wow...I'm 2 for 2 on rookie mistakes today. It was failing on the (( in my WHERE statement. It's weird that it doesn't fail when I run from dev studio, but it does when I'm in the document composer.

Do you know why that might be?

What is the error message ?

Have you checked for other errors ?

If a hold file is missing, check to see if it is being created .

It was complaining about the hold file EUHOLD, it said it couldn't find it as soon as I moved the WHERE statement all on one line, it ran.

I just find it odd that it does this in doc composer but not dev studio.

Can you -SET &ECHO=ALL; and post the output of the run ?

Is there a FILEDEF of EUHOLD that points somewhere else ?

Are there previous errors ?

It irritates me that I don't get the notifications that someone responded! Thank you for your patience Waz...I've moved on from this one because I got it to run. Just not sure why the WHERE statement made the difference!

Thanks!

jseaburn, you can receive notification of any responses for a particular posting by clicking the Flag button on the post window (the one you type your question/answer into). That Flag button offers you different ways of following the topic, one of them is "Immediate Notification by Email".

Of course, I always forget to do this.

Thanks Francis!

I actually do have the Notifications turned to "On" for this post. If I click on the flag, the box is checked for "Immediate Notification....". I've been pretty good at setting this flag on my posts because I want to know right away that someone answered.

So I'm not sure what the problem is then