Hello , I am trying to create a graphical report from a fex that I have created. I wish to save this fex as a hold file, which i know can be done with TABLE HOLD AS in coding and save it on QA. There are certain fields that i have given in the fex that i wish to be shown in stacked vertical bar graph in a certain format. So I have tried to do the same posting the code beginning with GRAPH FILE and then giving output as VBRSTK1 but somehow its not giving me the output I want, can anyone correct me or point me in the right direction.
I have posted my code for fex below, TABLE FILE FEB_2018
-*PRINT SUM YEAR_OF_CREATING MOUNT_OF_CREATION
BY CR_NUMBER BY CR_CATEGORIE BY STATUS
ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT AHTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt,$ ENDSTYLE ENDThis message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8 Windows, all Outputs
March 19, 2018, 04:15 AM
Chaudhary
This will be the Graph file request,
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE FEB_2018
-* Created by Info Assist for Graph
SUM YEAR_OF_CREATING
MOUNT_OF_CREATION
BY CR_NUMBER
BY CR_CATEGORIE
BY STATUS
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N4, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N5, BUCKET=y-axis, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
*GRAPH_JS_FINAL
"pieProperties": {
"holeSize": "0%"
},
"blaProperties": {
"seriesLayout": "stacked"
},
"agnosticSettings": {
"chartTypeFullName": "Bar_Stacked"
}
*END
ENDSTYLE
END
-RUN