Focal Point
Agent crashes when exporting compound reports containing data and graph to excel

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

November 23, 2011, 08:04 AM
Mayank Agrawal
Agent crashes when exporting compound reports containing data and graph to excel
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
November 29, 2011, 03:32 PM
Kerry
Hi Mayank,

Agent crash can have many different causes. To find out exactly what the cause is on your site, please open a case with Customer Support Services for assistance. The phone number is 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.