Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Report caster generate error on some dates..
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Report caster generate error on some dates..
 Login/Join
 
Member
posted
Hi,

I have an issue when running my report in report caster as scheduled...SOme days it run properly and email the report to users and some days it fails...On the failed days i still can see the report if i run the report manually(not using report caster)...

The error i can see when in run manually on some days is as below..
BTP1020 DUPLICATES IN JOIN FROM FIELD : H_HLDY1/EUR
BTP1020 DUPLICATES IN JOIN FROM FIELD : H_FIFTH/EUR
BTP1010 Task error: DUPLICATES IN JOIN FROM FIELD : H_HLDY1/EUR

But even if with this error i still can see the report when run manully(not using Report caster)..but when scheduled this report on that day it fails...

Is there a way if report caster can overwrite the error and gnearte the report same way when it run manullay...any setting to be done to avoid warnings so to have the report generated in report caster...

-*-SET XRETRIEVAL=OFF
SET EMPTYREPORT = ON
-SET ASNAMES = ON;
-SET ALL = ON;
-SET &GDP_SITE= 'PRO';
-SET &BB_CLOSING_BALANCE_TYPE = '015';
-SET &SWIFT_MESSAGE_TYPE = '940';
-* Currency Area
-SET &CCY_AREA = '0248';
-* Currency Variable for the USD currencies
-SET &BANK_CODE = 'CITI';
-* Defining Day of the Week spelled with first 3 letters i.e MON, TUE, WED etc.
-SET &DOFWEEK = DOWK(&YYMD,'A3');
-SET &ADJ = DECODE &DOFWEEK('MON' 3 'SUN' 2 ELSE 1);
-SET &ADJ = -1 * &ADJ;
-* Getting the previous day for the value date
-SET &VALUE_DATE = AYMD(&YYMD, &ADJ, 'I8YYMD');
-SET &RUN_DATEX = CHGDAT('YYMD', 'DMXYY', &VALUE_DATE, 'A17');
-SET &RUN_DATE = LCWORD(&RUN_DATEX.LENGTH, &RUN_DATEX, 'A17');
-* Sets the BY field display
-SET BYDISPLAY = ON;
-TYPE &DOFWEEK;
-TYPE &VALUE_DATE;
-* Join the Area table to get Area Code
JOIN
LEFT_OUTER ORD_BB.WSS_GDP_SITE AND ORD_BB.GL_UNIT IN ORD_BB
TO UNIQUE ORD_AREA.ORD_AREA.WSS_GDP_SITE AND ORD_AREA.ORD_AREA.AREA_UNIT
IN ORD_AREA TAG J3 AS J3
END
-* Join the SWCODE table via Nostro table to get Bank name.
JOIN
LEFT_OUTER ORD_BB.WSS_GDP_SITE AND ORD_BB.CCY
AND ORD_BB.GL_UNIT AND ORD_BB.NOSTRO_SHORT IN ORD_BB TO UNIQUE
ORD_NOSTRO.ORD_NOSTRO.WSS_GDP_SITE AND ORD_NOSTRO.ORD_NOSTRO.CURRENCY
AND ORD_NOSTRO.ORD_NOSTRO.AREA_UNIT AND ORD_NOSTRO.ORD_NOSTRO.SHORT_CODE
IN ORD_NOSTRO TAG J4 AS J4
END
JOIN
LEFT_OUTER J4.ORD_NOSTRO.SWIFT_NUMBER AND J4.ORD_NOSTRO.WSS_GDP_SITE IN ORD_BB
TO UNIQUE ORD_SWCODE.ORD_SWCODE.SWIFT_ID AND ORD_SWCODE.ORD_SWCODE.WSS_GDP_SITE
IN ORD_SWCODE TAG J1 AS J1
END
-* Join the Currency table to get CCY rates
JOIN
ORD_BB.WSS_GDP_SITE AND ORD_BB.CCY AND ORD_BB.VALUE_DATE
IN ORD_BB TO UNIQUE WSS_CURRENCIES.WSS_CURRENCIES.WSS_GDP_SITE
AND WSS_CURRENCIES.WSS_CURRENCIES.WSS_CCY_CODE
AND WSS_CURRENCIES.WSS_CURRENCIES.WSS_CCY_DATE IN WSS_CURRENCIES TAG J2 AS J2
END


TABLE FILE ORD_BB
SUM
'MAX.ORD_BB.ORD_BB.WSS_GDP_TIME' AS 'MAX,ORD_BB.ORD_BB.WSS_GDP_TIME'
BY 'J4.ORD_NOSTRO.ACCOUNT_ID'
BY 'ORD_BB.ORD_BB.NOSTRO_SHORT'
BY 'J3.ORD_AREA.AREA_CODE'
BY 'ORD_BB.ORD_BB.GL_UNIT'
BY 'ORD_BB.ORD_BB.TYPE'
BY 'ORD_BB.ORD_BB.FILE_TYPE'
BY 'ORD_BB.ORD_BB.CCY'
BY 'J1.ORD_SWCODE.SWIFT_LINE_1'
PRINT
COMPUTE USDEquiv/D16.2 = IF ORD_BB.CCY EQ 'USD' THEN ABS(ORD_BB.AMT * J2.WSS_CURRENCIES.WSS_CCY_SPOTRATE) ELSE IF ORD_BB.CCY EQ 'AUD' THEN ABS(ORD_BB.AMT * J2.WSS_CURRENCIES.WSS_CCY_SPOTRATE) ELSE IF ORD_BB.CCY EQ 'GBP' THEN ABS(ORD_BB.AMT * J2.WSS_CURRENCIES.WSS_CCY_SPOTRATE) ELSE IF ORD_BB.CCY EQ 'EUR' THEN ABS(ORD_BB.AMT * J2.WSS_CURRENCIES.WSS_CCY_SPOTRATE) ELSE IF ORD_BB.CCY EQ 'NZD' THEN ABS(ORD_BB.AMT * J2.WSS_CURRENCIES.WSS_CCY_SPOTRATE) ELSE ABS(ORD_BB.AMT / J2.WSS_CURRENCIES.WSS_CCY_SPOTRATE);
'J2.WSS_CURRENCIES.WSS_CCY_SPOTRATE'
BY 'J4.ORD_NOSTRO.ACCOUNT_ID'
BY 'ORD_BB.ORD_BB.NOSTRO_SHORT'
BY 'J3.ORD_AREA.AREA_CODE'
BY 'ORD_BB.ORD_BB.GL_UNIT'
BY 'ORD_BB.ORD_BB.TYPE'
BY 'ORD_BB.ORD_BB.FILE_TYPE'
BY 'ORD_BB.ORD_BB.CCY'
BY 'J1.ORD_SWCODE.SWIFT_LINE_1'
BY 'ORD_BB.ORD_BB.AMT'
BY 'ORD_BB.ORD_BB.VALUE_DATE'
HEADING
" "
ON TABLE SUBFOOT
" "
WHERE ( ORD_BB.WSS_GDP_SITE EQ &GDP_SITE.QUOTEDSTRING )
AND ( ORD_BB.TYPE EQ &BB_CLOSING_BALANCE_TYPE.QUOTEDSTRING )
AND ( ORD_BB.FILE_TYPE EQ &SWIFT_MESSAGE_TYPE.QUOTEDSTRING )
AND ( J1.ORD_SWCODE.SWIFT_LINE_1 CONTAINS &BANK_CODE.QUOTEDSTRING )
AND ( J3.ORD_AREA.AREA_CODE NE 'JBELGL' OR 'JESGL' OR 'JDECGL' OR 'JLGTGL' OR 'JITGL' OR 'JLGTGL' OR 'LPPGL' OR 'LRALGL' OR 'LRASGL' OR 'LRBEGL' OR 'LRDGGL' OR 'LREGGL' OR 'LRESGL' OR 'LREXGL' OR 'LRIRGL' OR 'LRITGL' OR 'LRNAGL' OR 'LRNLGL' OR 'LRPVGL' OR 'JAGHGL' OR 'JAGGL' )
AND ( ORD_BB.VALUE_DATE EQ DT(&VALUE_DATE 00:00:00) )
AND ( ORD_BB.AMT LT 0 )
AND ( J4.ORD_NOSTRO.ACCOUNT_ID NE ''' ''' )
AND (J2.WSS_CURRENCIES.WSS_CCY_AREA EQ &CCY_AREA.QUOTEDSTRING);
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS FIRST
END
-* Join ORD_BB table again for that set of data from FIRST and pull MAX value date where Amt is > 0
-* or amt is missing means 0 and store the data into HOLD File AS "SECOND"
JOIN
LEFT_OUTER NOSTRO_SHORT AND CCY AND GL_UNIT
AND TYPE AND FILE_TYPE IN FIRST TO MULTIPLE
ORD_BB.NOSTRO_SHORT AND ORD_BB.CCY AND ORD_BB.GL_UNIT
AND ORD_BB.TYPE AND ORD_BB.FILE_TYPE IN ORD_BB TAG JJ AS JJ
END
TABLE FILE FIRST
SUM
'FIRST.FIRST.WSS_CCY_SPOTRATE/D10.4'
'FIRST.FIRST.USDEquiv'
'MAX.JJ.ORD_BB.VALUE_DATE'
'JJ.ORD_BB.WSS_GDP_SITE'
BY 'FIRST.FIRST.ACCOUNT_ID'
BY 'FIRST.FIRST.NOSTRO_SHORT'
BY 'FIRST.FIRST.GL_UNIT'
BY 'JJ.ORD_BB.TYPE'
BY 'FIRST.FIRST.FILE_TYPE'
BY 'FIRST.FIRST.AREA_CODE'
BY 'FIRST.FIRST.CCY'
BY 'FIRST.FIRST.SWIFT_LINE_1'
HEADING
" "
FOOTING
""
WHERE (( JJ.ORD_BB.AMT GT 0 ) OR ( JJ.ORD_BB.AMT EQ MISSING ))
AND ( JJ.ORD_BB.TYPE EQ &BB_CLOSING_BALANCE_TYPE.QUOTEDSTRING )
AND ( JJ.ORD_BB.FILE_TYPE EQ &SWIFT_MESSAGE_TYPE.QUOTEDSTRING )
AND ( JJ.ORD_BB.VALUE_DATE LT FIRST.VALUE_DATE )
AND ( JJ.ORD_BB.WSS_GDP_SITE EQ &GDP_SITE.QUOTEDSTRING );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS SECOND
END

JOIN
LEFT_OUTER FIRST.ACCOUNT_ID IN FIRST TO UNIQUE SECOND.SECOND.ACCOUNT_ID IN SECOND TAG JO
AS JO
END
DEFINE FILE FIRST
MinDate/YYMD=HDATE(JJ.ORD_BB.VALUE_DATE , 'YYMD');
MaxDate/YYMD=HDATE(SECOND.VALUE_DATE , 'YYMD');
DOWeek/A3=;
END
TABLE FILE FIRST
SUM
COMPUTE DateSince/DMtYY = MAX(MaxDate, ( MIN.MinDate - 1 ));
COMPUTE NumDate/I8YYMD = DateSince;
COMPUTE DOfWeek/A4 = DOWK(NumDate, DOfWeek);
COMPUTE DS/DMtYY = IF DOfWeek EQ 'FRI' THEN DateSince + 3 ELSE DateSince + 1;
COMPUTE DateS/YY|M|D = DS;
COMPUTE SYSDATE/YY|M|D = &YYMD;
COMPUTE NoOfDays/I3 = DATEDIF(DateS, SYSDATE, 'D');
BY HIGHEST 'FIRST.FIRST.USDEquiv'
BY 'FIRST.FIRST.SWIFT_LINE_1'
BY 'FIRST.FIRST.ACCOUNT_ID'
BY TOTAL COMPUTE ValueD/DMtYY = HDATE(FIRST.VALUE_DATE, 'MDTYY');
BY 'FIRST.FIRST.VALUE_DATE'
BY 'FIRST.FIRST.CCY'
BY 'FIRST.FIRST.AMT'
BY TOTAL COMPUTE ABSAMT/D18.2 = ABS(FIRST.AMT);
BY TOTAL COMPUTE RATE/D10.4 = FIRST.WSS_CCY_SPOTRATE;
BY 'FIRST.FIRST.WSS_CCY_SPOTRATE'
BY 'FIRST.FIRST.GL_UNIT'
BY 'FIRST.FIRST.AREA_CODE'
BY 'FIRST.FIRST.NOSTRO_SHORT'
WHERE ( JJ.ORD_BB.AMT LT 0 );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS THIRD
END
-* Report generated from THIRD file because of issue with the No of Days and Date Since Account in OD columns and their calculations
TABLE FILE THIRD
PRINT
'THIRD.THIRD.USDEquiv'
'THIRD.THIRD.SWIFT_LINE_1'
'THIRD.THIRD.ValueD'
'THIRD.THIRD.VALUE_DATE'
'THIRD.THIRD.AMT'
'THIRD.THIRD.ABSAMT'
'THIRD.THIRD.RATE'
'THIRD.THIRD.WSS_CCY_SPOTRATE'
'THIRD.THIRD.GL_UNIT'
'THIRD.THIRD.AREA_CODE'
'THIRD.THIRD.NOSTRO_SHORT'
'THIRD.THIRD.MaxDate'
'THIRD.THIRD.MinDate'
'THIRD.THIRD.DateSince'
'THIRD.THIRD.NumDate'
'THIRD.THIRD.DOfWeek'
'THIRD.THIRD.DS'
'THIRD.THIRD.DateS'
'THIRD.THIRD.SYSDATE'
'THIRD.THIRD.NoOfDays'
'THIRD.THIRD.VALUE_DATE'
'THIRD.THIRD.ValueD'
'THIRD.THIRD.ABSAMT'
'THIRD.THIRD.WSS_CCY_SPOTRATE'
'THIRD.THIRD.RATE'
BY 'THIRD.THIRD.CCY'
BY 'THIRD.THIRD.ACCOUNT_ID'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS H_FOURTH
END
-* this Hold file is Just to sort with CCY
DEFINE FILE WSS_HOLIDAYS
HLYDate/YY|M|D=HDATE(WSS_HOLIDAYS.WSS_HOLIDAYS.WSS_HOLIDAY_DATE , 'YYMD');
END
-* Holiday Define Field to check for any holidays during the Overdraft period.
TABLE FILE WSS_HOLIDAYS
SUM
'CNT.WSS_HOLIDAYS.WSS_HOLIDAYS.WSS_GDP_SITE' AS 'COUNT,GDP_SITE'
BY 'WSS_HOLIDAYS.WSS_HOLIDAYS.WSS_HOLIDAY_CCY'
BY 'WSS_HOLIDAYS.WSS_HOLIDAYS.HLYDate'
HEADING
""
FOOTING
""
WHERE ( WSS_HOLIDAYS.WSS_HOLIDAYS.WSS_GDP_SITE EQ &GDP_SITE.QUOTEDSTRING ) AND
( WSS_HOLIDAYS.WSS_HOLIDAYS.WSS_DELETE_FLAG EQ MISSING ) ;
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS H_HLDY
END
-* WSS_GDP_SITE is the field used to get the count of Holidays from Holidays Table.
TABLE FILE H_HLDY
PRINT
'H_HLDY.H_HLDY.WSS_GDP_SITE'
'H_HLDY.H_HLDY.HLYDate'
BY 'H_HLDY.H_HLDY.WSS_HOLIDAY_CCY'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS H_HLDY1
END
JOIN
LEFT_OUTER H_FOURTH.H_FOURTH.CCY IN H_FOURTH TO MULTIPLE
H_HLDY1.H_HLDY1.WSS_HOLIDAY_CCY IN H_HLDY1 TAG JH AS JH
END
-* Holiday FIle Join with BB File with CCY to get number of Holidays sorted by CCY

TABLE FILE H_FOURTH
SUM
'JH.H_HLDY1.WSS_GDP_SITE'
BY 'H_FOURTH.H_FOURTH.CCY'
HEADING
""
FOOTING
""
WHERE ( JH.H_HLDY1.HLYDate GE H_FOURTH.H_FOURTH.DateS )
AND ( JH.H_HLDY1.HLYDate LE H_FOURTH.H_FOURTH.SYSDATE );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS H_FIFTH
END
JOIN
LEFT_OUTER H_FOURTH.H_FOURTH.CCY IN H_FOURTH TO MULTIPLE H_FIFTH.H_FIFTH.CCY
IN H_FIFTH TAG JJ AS JJ
END
TABLE FILE H_FOURTH
SUM
'JJ.H_FIFTH.WSS_GDP_SITE'
'H_FOURTH.H_FOURTH.USDEquiv'
'H_FOURTH.H_FOURTH.SWIFT_LINE_1'
'H_FOURTH.H_FOURTH.ValueD'
'H_FOURTH.H_FOURTH.VALUE_DATE'
'H_FOURTH.H_FOURTH.AMT'
'H_FOURTH.H_FOURTH.ABSAMT'
'H_FOURTH.H_FOURTH.RATE'
'H_FOURTH.H_FOURTH.WSS_CCY_SPOTRATE'
'H_FOURTH.H_FOURTH.GL_UNIT'
'H_FOURTH.H_FOURTH.AREA_CODE'
'H_FOURTH.H_FOURTH.NOSTRO_SHORT'
'H_FOURTH.H_FOURTH.MaxDate'
'H_FOURTH.H_FOURTH.MinDate'
'H_FOURTH.H_FOURTH.DateSince'
'H_FOURTH.H_FOURTH.NumDate'
'H_FOURTH.H_FOURTH.DOfWeek'
'H_FOURTH.H_FOURTH.DS'
'H_FOURTH.H_FOURTH.DateS'
'H_FOURTH.H_FOURTH.SYSDATE'
'H_FOURTH.H_FOURTH.NoOfDays'
'H_FOURTH.H_FOURTH.VALUE_DATE'
'H_FOURTH.H_FOURTH.ValueD'
'H_FOURTH.H_FOURTH.ABSAMT'
'H_FOURTH.H_FOURTH.WSS_CCY_SPOTRATE'
'H_FOURTH.H_FOURTH.RATE'

BY 'H_FOURTH.H_FOURTH.CCY'
BY 'H_FOURTH.H_FOURTH.ACCOUNT_ID'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS H_HLDYF
END
-* Get the count of Holidays(JH.H_HLDY1.WSS_GDP_SITE) during the Overdraft period DateS and SYSDATE time.
TABLE FILE H_HLDYF
PRINT
'H_HLDYF.H_HLDYF.CCY'
'H_HLDYF.H_HLDYF.USDEquiv'
'H_HLDYF.H_HLDYF.SWIFT_LINE_1'
'H_HLDYF.H_HLDYF.ACCOUNT_ID'
'H_HLDYF.H_HLDYF.ValueD'
'H_HLDYF.H_HLDYF.VALUE_DATE'
'H_HLDYF.H_HLDYF.ABSAMT'
'H_HLDYF.H_HLDYF.AMT'
'H_HLDYF.H_HLDYF.RATE'
'H_HLDYF.H_HLDYF.AREA_CODE'
'H_HLDYF.H_HLDYF.NOSTRO_SHORT'
'H_HLDYF.H_HLDYF.NoOfDays'
'H_HLDYF.H_HLDYF.DS'
'H_HLDYF.H_HLDYF.WSS_CCY_SPOTRATE'
'H_HLDYF.H_HLDYF.GL_UNIT'
COMPUTE FinalNDays/I5 = IF H_HLDYF.H_HLDYF.WSS_GDP_SITE LE 0 THEN H_HLDYF.H_HLDYF.NoOfDays ELSE H_HLDYF.H_HLDYF.NoOfDays - H_HLDYF.H_HLDYF.WSS_GDP_SITE;
BY HIGHEST 'H_HLDYF.H_HLDYF.USDEquiv'
BY 'H_HLDYF.H_HLDYF.SWIFT_LINE_1'
BY 'H_HLDYF.H_HLDYF.ACCOUNT_ID'
BY 'H_HLDYF.H_HLDYF.VALUE_DATE'
BY 'H_HLDYF.H_HLDYF.CCY'
BY 'H_HLDYF.H_HLDYF.AMT'
BY 'H_HLDYF.H_HLDYF.WSS_CCY_SPOTRATE'
BY 'H_HLDYF.H_HLDYF.GL_UNIT'
BY 'H_HLDYF.H_HLDYF.AREA_CODE'
BY 'H_HLDYF.H_HLDYF.NOSTRO_SHORT'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS H_FINAL
END
-* FinalNDays value gives the final count of No of Overdraft Days after subtracted with Number of Holidays for each CCY during the period
TABLE FILE H_FINAL
PRINT 'H_FINAL.H_FINAL.SWIFT_LINE_1' AS 'Bank Name'
'H_FINAL.H_FINAL.ACCOUNT_ID' AS 'Account'
'H_FINAL.H_FINAL.ValueD' AS 'Value Date'
'H_FINAL.H_FINAL.CCY' AS 'Currency'
'H_FINAL.H_FINAL.ABSAMT' AS 'Amount'
'H_FINAL.H_FINAL.USDEquiv' AS 'USD Equiv'
'H_FINAL.H_FINAL.RATE' AS 'USD Equiv Rate'
'H_FINAL.H_FINAL.AREA_CODE' AS 'Area Code'
'H_FINAL.H_FINAL.NOSTRO_SHORT' AS 'Nostro'
'H_FINAL.H_FINAL.FinalNDays' AS 'No of Consecutive Days in OD'
'H_FINAL.H_FINAL.DS' AS 'Date Since Account In OD'
HEADING
"Ford Motor Company and Affiliates "
"Daily Overdraft Report - Citibank Accounts"
"as of <+0>&RUN_DATE "
"Sort Order (USD Equivalent)"
FOOTING
" "
"Ford Proprietary<+0> -- Page&DATEtrMDYY &TOD"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
TITLETEXT='DailyOverdraft_PRO_&VALUE_DATE',
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N1,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N2,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N3,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N4,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N5,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N6,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N7,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N8,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N9,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N10,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N11,
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=8,
$
TYPE=REPORT,
COLUMN=N1,
SQUEEZE=0.852778,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=1.300000,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=0.75556,
$
TYPE=REPORT,
COLUMN=N4,
SQUEEZE=0.602778,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=0.902778,
$
TYPE=REPORT,
COLUMN=N6,
SQUEEZE=0.902778,
$
TYPE=REPORT,
COLUMN=N7,
SQUEEZE=0.680556,
$
TYPE=REPORT,
COLUMN=N8,
SQUEEZE=0.680556,
$
TYPE=REPORT,
COLUMN=N9,
SQUEEZE=0.625000,
$
TYPE=REPORT,
COLUMN=N10,
SQUEEZE=0.852778,
$
TYPE=REPORT,
COLUMN=N11,
SQUEEZE=0.75556,
$
TYPE=DATA,
COLUMN=N1,
STYLE=NORMAL,
JUSTIFY=LEFT,
$
TYPE=DATA,
COLUMN=N2,
STYLE=NORMAL,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N3,
STYLE=NORMAL,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N4,
STYLE=NORMAL,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N5,
STYLE=NORMAL,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N6,
STYLE=NORMAL,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N7,
STYLE=NORMAL,
JUSTIFY=RIGHT,
$
TYPE=DATA,
COLUMN=N8,
STYLE=NORMAL,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N9,
STYLE=NORMAL,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N10,
STYLE=NORMAL,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N11,
STYLE=NORMAL,
JUSTIFY=LEFT,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=2,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=14,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
SIZE=14,
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=1,
SIZE=14,
$
TYPE=HEADING,
LINE=3,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
SIZE=10,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=1,
SIZE=10,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=4,
OBJECT=FIELD,
ITEM=1,
SIZE=14,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=4,
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=5,
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=1,
OBJECT=FIELD,
ITEM=2,
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=2,
OBJECT=TEXT,
ITEM=3,
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=2,
OBJECT=TEXT,
ITEM=4,
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=2,
OBJECT=TEXT,
ITEM=5,
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=2,
OBJECT=FIELD,
ITEM=1,
SIZE=10,
STYLE=NORMAL,
$
TYPE=FOOTING,
LINE=2,
OBJECT=FIELD,
ITEM=2,
SIZE=10,
STYLE=NORMAL,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=8,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END
-EXIT

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


WebFOCUS 76
Windows
all formats
 
Posts: 18 | Registered: September 14, 2009Reply With QuoteReport This Post
Virtuoso
posted Hide Post
This will turn off warnings in the fex

SET WARNING=OFF
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
In the Report Caster configuration (General tab) you can set up FOC Message Numbers to be Processed as Warnings.
This should prevent certain error types stopping processing for all users of Report Caster. You would have to get the message number for this to work.


(Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats)
 
Posts: 391 | Location: California | Registered: April 14, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Report caster generate error on some dates..

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.