Hello,

I have built a report in which I have created through Text Editor conditions that when met populate a .png file. When I run this report via text editor it works perfectly. When I open the procedure via Report Painter (App Studio Version)the report no longer populates the image files. When we check the source code all of the conditions are missing the image files and some of the when statements. Any thoughts?

I am on Webfocus 8.008

This message has been edited. Last edited by: <Kathryn Henning>,

Not sure about v8, but in previous versions if you wrote code via text editor that is not supported by Painter, an advise is popup and if you decide to continue to open with Painter, the 'non-supported' code can be deleted.

I am not sure if it would help but here is the code...

ENGINE INT CACHE SET ON
-SET &TODAY_DATE = &YYMD;
-SET &CURMON=EDIT(&TODAY_DATE, '$$$$99$$');

DEFINE FILE DAILY_VERTICAL ADD
Month/Mtr=DAILY_VERTICAL.DAILY_VERTICAL.MONTH1;
END
DEFINE FILE DAILY_VERTICAL
DayOfWeek/W=DAILY_VERTICAL.DAILY_VERTICAL.DATE1 ;
Month/Mtr=DAILY_VERTICAL.DAILY_VERTICAL.MONTH1;
MONTHVAL/M = DAILY_VERTICAL.DAILY_VERTICAL.MONTH1;
END
-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE DAILY_VERTICAL
PRINT
DAILY_VERTICAL.DAILY_VERTICAL.CALLS_ANSWERED_METRIC_VALUE AS 'Answered Vol'
COMPUTE SVL1/D12.1%=( DAILY_VERTICAL.DAILY_VERTICAL.SERVICE_LEVEL_METRIC_VALUE * 100); NOPRINT
COMPUTE SVLP/A16 = FTOA(SVL1, '(D12.1)', SVLP) ; NOPRINT
COMPUTE SVL/A20 = IF SVL1 GT 0 THEN SVLP || '%' ELSE ' '; AS 'SVL'
COMPUTE FLG_SVL/A1 = IF SVL1 EQ 0 THEN 'Z'
ELSE IF SVL1 GT 0 AND SVL1 LE 60 THEN 'R'
ELSE IF SVL1 GT 60 AND SVL1 LT 70 THEN 'Y'
ELSE IF SVL1 GT 70 THEN 'G'
ELSE ''; NOPRINT
COMPUTE S_Res1/D8=( DAILY_VERTICAL.DAILY_VERTICAL.SERVICE_LEVEL_METRIC_VALUE * 100 ) ;NOPRINT
COMPUTE S_ResP/A10 = FTOA(S_Res1, '(D8)', S_ResP) ; NOPRINT
COMPUTE S_Res/A12 = IF S_Res1 GT 0 THEN S_ResP ELSE ' '; AS 'S_Res'
COMPUTE ABR1/D12.2%=( DAILY_VERTICAL.DAILY_VERTICAL.ABANDON_RATE_METRIC_VALUE * 100 ) ; NOPRINT
COMPUTE ABRP/A16 = FTOA(ABR1, '(D12.2)', ABRP); NOPRINT
COMPUTE ABR/A20 = IF ABR1 GT 0 THEN ABRP || '%' ELSE ''; AS 'ABR'
COMPUTE FLG_ABR/A1 = IF ABR1 EQ 0 THEN 'Z'
ELSE IF ABR1 GT 4 THEN 'R'
ELSE IF ABR1 GT 0 AND ABR1 LE 4 THEN 'G'
ELSE ''; NOPRINT
COMPUTE AB_Res1/D8=( DAILY_VERTICAL.DAILY_VERTICAL.ABANDON_RATE_METRIC_VALUE * 100 ) ;NOPRINT
COMPUTE AB_ResP/A10= FTOA(AB_Res1, '(D8)',AB_ResP); NOPRINT
COMPUTE AB_Res/A12 = IF AB_Res1 GT 0 THEN AB_ResP ELSE ''; AS 'AB_Res'
COMPUTE ABR_ADH1/D12.1%=( DAILY_VERTICAL.DAILY_VERTICAL.ABANDON_RATE_ADHERENCE_METRIC_VALUE * 100 ) ; NOPRINT
COMPUTE ABR_ADHP/A16 = FTOA(ABR_ADH1, '(D12.1)', ABR_ADHP); NOPRINT
COMPUTE ABR_ADH/A20 = IF ABR_ADH1 GT 0 THEN ABR_ADHP || '%' ELSE ''; AS 'ABR_ADH'
COMPUTE FLG_ABRADH/A1 = IF ABR_ADH1 EQ 0 THEN 'Z'
ELSE IF ABR_ADH1 GE 70 THEN 'G'
ELSE IF ABR_ADH1 LT 70 THEN 'R'
ELSE ''; NOPRINT
COMPUTE AAD_Res1/D8=( DAILY_VERTICAL.DAILY_VERTICAL.ABANDON_RATE_ADHERENCE_METRIC_VALUE * 100 ) ;NOPRINT
COMPUTE AAD_ResP/A10= FTOA(AAD_Res1, '(D8)',AAD_ResP); NOPRINT
COMPUTE AAD_Res/A12 = IF AAD_Res1 GT 0 THEN AAD_ResP ELSE ''; AS 'AAD_Res'
COMPUTE CSAT1/D12.1%=( DAILY_VERTICAL.DAILY_VERTICAL.PCS_METRIC_VALUE * 100 ) ;NOPRINT
COMPUTE CSATP/A16 = FTOA(CSAT1, '(D12.1)', CSATP); NOPRINT
COMPUTE CSAT/A20 = IF CSAT1 GT 0 THEN CSATP || '%' ELSE ''; AS 'CSAT'
COMPUTE C_Res1/D8=( DAILY_VERTICAL.DAILY_VERTICAL.PCS_METRIC_VALUE * 100 ) ;NOPRINT
COMPUTE C_ResP/A10= FTOA(C_Res1, '(D8)',C_ResP); NOPRINT
COMPUTE C_Res/A12 = IF C_Res1 GT 0 THEN C_ResP ELSE ''; AS 'C_Res'
COMPUTE FLG_C_Res/A1 = IF C_Res1 EQ 0 THEN 'Z'
ELSE IF C_Res1 GE 70 THEN 'G'
ELSE IF C_Res1 LT 70 THEN 'R'
ELSE ''; NOPRINT
BY Month AS 'Month'
ON TABLE SUBHEAD
"Inbound"
WHERE MONTHVAL LE '&CURMON.EVAL'
WHERE DAILY_VERTICAL.DAILY_VERTICAL.DAY_OF_WEEK EQ 'MTD';
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
DEFMACRO=Condition_6, MACTYPE=RULE, WHEN=ABR_ADH GT '70', $
DEFMACRO=Condition_7, MACTYPE=RULE, WHEN=ABR_ADH LT '70', $
DEFMACRO=Condition_9, MACTYPE=RULE, WHEN=SVL GE '70.0', $
DEFMACRO=Condition_10, MACTYPE=RULE, WHEN=SVL LE '60.00', $
DEFMACRO=Condition_11, MACTYPE=RULE, WHEN=SVL GT '60.0', $
DEFMACRO=Condition_12, MACTYPE=RULE, WHEN=ABR GT '4', $
DEFMACRO=Condition_13, MACTYPE=RULE, WHEN=ABR LE '4', $
DEFMACRO=Condition_14, MACTYPE=RULE, WHEN=CSAT GE '70', $
DEFMACRO=Condition_15, MACTYPE=RULE, WHEN=CSAT LT '70', $
DEFMACRO=Condition_16, MACTYPE=RULE, WHEN=SVL EQ '0', $

TYPE=TITLE, COLUMN=N1, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, $
TYPE=TITLE, COLUMN=N2, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, $
TYPE=TITLE, COLUMN=SVL, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, $
TYPE=TITLE, COLUMN=ABR, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, $
TYPE=TITLE, COLUMN=ABR_ADH, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, $
TYPE=TITLE, COLUMN=CSAT, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, $
TYPE=TITLE, COLUMN=S_Res, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, $
TYPE=TITLE, COLUMN=AB_Res, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, $
TYPE=TITLE, COLUMN=AAD_Res, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, $
TYPE=TITLE, COLUMN=C_Res, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, $
TYPE=DATA, COLUMN=N1, JUSTIFY=LEFT, FONT='ARIAL', SIZE=7, BACKCOLOR=RGB(244 244 244), $
TYPE=DATA, COLUMN=N2, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, BACKCOLOR=RGB(244 244 244), $
TYPE=DATA, COLUMN=SVL, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, BACKCOLOR=RGB(244 244 244), $
TYPE=DATA, COLUMN=ABR, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, BACKCOLOR=RGB(244 244 244), $
TYPE=DATA, COLUMN=ABR_ADH, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, BACKCOLOR=RGB(244 244 244), $
TYPE=DATA, COLUMN=CSAT, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, BACKCOLOR=RGB(244 244 244), $
TYPE=DATA, COLUMN=S_Res, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, BACKCOLOR=RGB(244 244 244), $
TYPE=DATA, COLUMN=AB_Res, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, BACKCOLOR=RGB(244 244 244), $
TYPE=DATA, COLUMN=AAD_Res, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, BACKCOLOR=RGB(244 244 244), $
TYPE=DATA, COLUMN=C_Res, JUSTIFY=CENTER, FONT='ARIAL', SIZE=7, BACKCOLOR=RGB(244 244 244), $
TYPE=DATA, COLUMN=AAD_Res, MACRO=Condition_6, IMAGE=IBFS:/WFC/Repository/Operations/~u452012/g1.gif, WHEN=FLG_ABRADH EQ 'G', $
TYPE=DATA, COLUMN=AAD_Res, MACRO=Condition_7, IMAGE=IBFS:/WFC/Repository/Operations/~u452012/r1.png, WHEN=FLG_ABRADH EQ 'R', $
TYPE=DATA, COLUMN=AB_Res, MACRO=Condition_13, IMAGE=IBFS:/WFC/Repository/Operations/~u452012/g1.png, WHEN=FLG_ABR EQ 'G',$
TYPE=DATA, COLUMN=AB_Res, MACRO=Condition_12, IMAGE=IBFS:/WFC/Repository/Operations/~u452012/r1.png, WHEN=FLG_ABR EQ 'R',$
TYPE=DATA, COLUMN=S_Res, MACRO=Condition_10, IMAGE=IBFS:/WFC/Repository/Operations/~u452012/r1.png, WHEN=FLG_SVL EQ 'R',$
TYPE=DATA, COLUMN=S_Res, MACRO=Condition_9, IMAGE=IBFS:/WFC/Repository/Operations/~u452012/g1.png, WHEN=FLG_SVL EQ 'G',$
TYPE=DATA, COLUMN=S_Res, MACRO=Condition_11, IMAGE=IBFS:/WFC/Repository/Operations/~u452012/y1.png, WHEN=FLG_SVL EQ 'Y',$
TYPE=DATA, COLUMN=C_Res, MACRO=Condition_14, IMAGE=IBFS:/WFC/Repository/Operations/~u452012/g1.png, WHEN=FLG_C_Res EQ 'G', $
TYPE=DATA, COLUMN=C_Res, MACRO=Condition_15, IMAGE=IBFS:/WFC/Repository/Operations/~u452012/r1.png, WHEN=FLG_C_Res EQ 'R', $
ENDSTYLE
END
-RUN