Hi,
Recently we migrated to webfocus 7.7.03 from 7.6.11.
When we run the following procedure agent is getting crashed. The procedure will be exporting a compound report to excel containing data and graph. The same procedure was working earlier. For better understanding, I have created a car file with the following code.
-SET ECHO=ALL;
-SET &GRAPHSVR='http://servername:80/ibi_apps/IBIGraphServlet';
SET GRAPHSERVURL=&GRAPHSVR;
TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
BY CAR
ON TABLE HOLD AS CAR2
END
TABLE FILE CAR2
PRINT *
ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK
END
GRAPH FILE CAR2
PRINT DEALER_COST
BY COUNTRY
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON TABLE PCHOLD FORMAT EXL2K CLOSE
-*ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
ENDSTYLE
END
Please let us know in case anyone has faced this issue.
7.6.11, Windows
Excel, HTML,PDF