Focal Point
Error in opening

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2267074476

January 28, 2015, 07:41 AM
TMG_MA
Error in opening
the problem I am having is in my procedure opening (it runs properly) I get a missing value for one of my parameters that are populated when it runs. If I set the default value for that parameter, it won't use the run time input value only the default value. (it is a procedure with the dialogue manager to use and manipulate the parameters)[app studio]

what am I doing wrong?

-SET DATEFORMAT=YYMD;
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
-SET &PREV_MONTH=DATECVT(DATEADD('&RPT_DATE','M',-1),'YYMD','I8YYMD');
ENGINE INT CACHE SET ON
GRAPH FILE FTD_MASTER
-* Created by Info Assist for Graph
SUM FTD_MASTER.FACT_XFERS.IS_CLIENT_SUCCESS_LATE AS 'Late'
FTD_MASTER.FACT_XFERS.IS_CLIENT_FAILURE AS 'Failure'
FTD_MASTER.FACT_XFERS.IS_CLIENT_SUCCESS AS 'Success'
BY LOWEST 365 FTD_MASTER.DIM_DATE.FULL_DATE AS ' '
WHERE FTD_MASTER.DIM_DATE.FULL_DATE GE '&PREV_MONTH';
WHERE FTD_MASTER.DIM_DATE.FULL_DATE LE '&RPT_DATE';
WHERE FTD_MASTER.DIM_CLIENT.CLIENT_CODE EQ &CLIENT_NAME.(OR(FIND FTD_MASTER.DIM_CLIENT.CLIENT_CODE IN FTD_MASTER)).CLIENT_NAME:.;
WHERE FTD_MASTER.DIM_CLIENT_LOB.CLIENT_LOB_CODE EQ &CLIENT_LOB_CODE.(OR(FIND FTD_MASTER.DIM_CLIENT_LOB.CLIENT_LOB_CODE IN FTD_MASTER)).Client Line of Business:.;
WHERE FTD_MASTER.DIM_DEPARTMENT.DEPARTMENT_CODE EQ &DEPARTMENT.(OR(FIND FTD_MASTER.DIM_DEPARTMENT.DEPARTMENT_CODE IN FTD_MASTER)).DEPARTMENT:.;
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR2AX
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
DEFMACRO=Condition_1, MACTYPE=RULE, WHEN=N4 GT 0, $
DEFMACRO=Condition_2, MACTYPE=RULE, WHEN=N2 GT 0, $
DEFMACRO=Condition_3, MACTYPE=RULE, WHEN=N3 GT 0, $
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N3, MACRO=Condition_3, COLOR=RGB(255 0 0), $
TYPE=DATA, COLUMN=N4, MACRO=Condition_1, COLOR=RGB(0 255 64), $
TYPE=DATA, COLUMN=N2, MACRO=Condition_2, COLOR=RGB(255 255 0), $
*GRAPH_SCRIPT
setAutofit(getTitle(),false);
setTitleString("30 Day Historical View");
setRect(getTitle(),new Rectangle(-13471,11992,25806,1539));
setReportParsingErrors(false);
setSelectionEnableMove(false);
setTransparentFillColor(getFrame(),true);
setFillColor(getChartBackground(),new Color(218,238,243,0));
setRemoveDuplicateDataText(false);
setTextString(getY2Title(),"Success");
setDisplay(getY2Title(),true);
setTextString(getY1Title(),"Late/Failed");
setDisplay(getY1Title(),true);
setFillColor(getSeries(0),new Color(255,255,0));
setFillColor(getSeries(1),new Color(255,0,0));
setFillColor(getSeries(2),new Color(0,255,64));
setLabelStagger(getO1Label(),true);
setTextRotation(getO1Label(),3);
setAxisAssignment( $0, 0);
setAxisAssignment( $1, 0);
setAxisAssignment( $2, 1);
*END
ENDSTYLE
END
-RUN

-*IA_GRAPH_FINISH


WebFOCUS 7.6
Windows, All Outputs
January 29, 2015, 01:01 PM
Tamra
TMG_MA

What is the error message?
What version of WebFOCUS are you using?
Do you have prompt for parameters on/off - click the right mouse on the fex and view properties ( if in the CONTENT folder/MRE)?

Please verify the &RPT_DATE variable is the correct variable being passed into the report from the HTML.
Add on the first line in the Graph fex the following:

-SET &ECHO=ALL;
-? &
-EXIT

The variables will be displayed in the output - verify the name of the &VAR being passed from HTML.

Thank you for your response.

Kindest regards,
Tamra Colangelo
iWay Focal Point Forum Moderator


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5