Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Document Composer and parameters

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Document Composer and parameters
 Login/Join
 
Gold member
posted
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,


WebFOCUS 7.7.03
Linux / Universe Db
HTML/PDF/EXCEL/HTML Active
 
Posts: 90 | Registered: November 03, 2009Report This Post
Expert
posted Hide Post
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.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
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.


WebFOCUS 7.7.03
Linux / Universe Db
HTML/PDF/EXCEL/HTML Active
 
Posts: 90 | Registered: November 03, 2009Report This Post
Gold member
posted Hide Post
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?


WebFOCUS 7.7.03
Linux / Universe Db
HTML/PDF/EXCEL/HTML Active
 
Posts: 90 | Registered: November 03, 2009Report This Post
Expert
posted Hide Post
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 .


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
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.


WebFOCUS 7.7.03
Linux / Universe Db
HTML/PDF/EXCEL/HTML Active
 
Posts: 90 | Registered: November 03, 2009Report This Post
Expert
posted Hide Post
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 ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
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!


WebFOCUS 7.7.03
Linux / Universe Db
HTML/PDF/EXCEL/HTML Active
 
Posts: 90 | Registered: November 03, 2009Report This Post
Expert
posted Hide Post
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.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Gold member
posted Hide Post
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 Frowner


WebFOCUS 7.7.03
Linux / Universe Db
HTML/PDF/EXCEL/HTML Active
 
Posts: 90 | Registered: November 03, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Document Composer and parameters

Copyright © 1996-2020 Information Builders