Focal Point
Issues with Graph in Report Caster

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

February 14, 2005, 01:57 AM
thangam
Issues with Graph in Report Caster
Hi,
I have scheduled the fex file which gives o/p in Table format and Graph format in the same report. As Forum suggested, I am saving the each o/p and putting the final o/p through HTMLFORM.

But I could get the Table o/p, but not the graph.
The Java API calls in Graph are not getting executed. I am getting blank space with grey color backgroud in place of graph. When I see the view source, the following code is for Graph part.

APPLET name=graph codebase=/ibi_html/javaassist archive=IBITDGChartApplet.jar code=IBITDGChartApplet.class width=760 height=400

PARAM name=TDGSCRIPT value = '
setGraphType(17);
setDepthAngle(90);
setDepthRadius(0);
setTextRotation(getO2Label(),2);
setTextRotation(getX1Label(),2);
setFontSizeVC(getDataText(),1000);
setFontSizeVC(getFootnote(),1000);
setFontSizeVC(getLegendText(),1000);
setFontSizeVC(getO1Label(),1000);
setFontSizeVC(getO1Title(),1000);
setFontSizeVC(getO2Label(),1000);
setFontSizeVC(getO2Title(),1000);
setFontSizeVC(getPieLabel(),1000);
setFontSizeVC(getPieRingLabel(),1000);
setFontSizeVC(getPieSliceLabel(),1000);
setFontSizeVC(getSubtitle(),1000);
setFontSizeVC(getTitle(),1000);
setFontSizeVC(getX1Label(),1000);
setFontSizeVC(getX1Title(),1000);
setFontSizeVC(getY1Axis(),1000);
setFontSizeVC(getY1Label(),1000);
setFontSizeVC(getY1Title(),1000);
setFontSizeVC(getY2Label(),1000);
setFontSizeVC(getY2Title(),1000);
setToolTipDisplay(true);
setSeriesLabelArray(
"SKU count");
setDataSeries(
2.00,
2.00,
4.00);
setDataRangeToExtent();
setGroupLabelArray(
"Amazon",
"Woodbury",
"");
setDisplay(getCubeLeftWallGridY(),true);
setDisplay(getCubeRightWallGridY(),true);
setDisplay(getCubeFloorGridX(),true);
setDisplay(getCubeFloorGridZ(),true);
setDisplay(getCubeLeftWallGridZ(),true);
setDisplay(getCubeRightWallGridX(),true);
setY1MustIncludeZero(true);
setDecimalNotation(".");
setCentZero(false);
setDataTextPosition(0);
setDataTextRadiusDefault(10);
setDataTextFormat(-1);
setDataTextFormatPattern("#,###,###,###");
setY1TitleString("SKU count");
setO1TitleString("");
setFillColor(getFrame(),new Color(192,192,192));
/* GRAPHSTYLE BEGIN */
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setY1LabelDisplay(true);
setDataTextDisplay (true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieDepth(0);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setLegendDisplay(true);
setLegendTextAutofit(true);
setTitleString("SKU count by PFL");
setTextJustHoriz(getTitle(),1);
setFontSizeAbsolute(getTitle(),true);
setLegendTextAutofit(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSize(getY1Label(),11);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setFontSizeAbsolute(getO1Label(),true);
setFontSize(getO1Label(),11);
setFontSizeAbsolute(getDataText(),true);
setFontStyle(getDataText(),0);
setFontSize(getDataText(),11);
setO1LabelAutofit(true);
setReverseSeries(true);
setReverseGroups(true);
setTextRotation(getO1Label(),0);
/* GRAPHSTYLE END */
'>
/APPLET

It looks that APIs are not getting executed. Do I need to any setting in Report caster to execute these APIS? How do I overcome this issue?
February 15, 2005, 01:47 AM
thangam
Can someone respond to the above query?
February 15, 2005, 01:59 AM
susannah
save your graph as a .gif and dump it out that way. not an elegant solution, but it'll get you home for dinner.
February 15, 2005, 02:13 AM
thangam
At present I am saving as a gif only.

ON GRAPH HOLD AS HOLD2G FORMAT GIF

Even then, Getting Unexecuted APIs.

Please guide me.
February 15, 2005, 12:54 PM
j.gross
If memory serves, for client-side graphics you use
ON GRAPH HOLD AS xxx FORMAT HTMTABLE
(not GIF); and imbed as a report
(!IBI.FIL.xxxWink.
February 15, 2005, 02:31 PM
jodye
Try using GRAPHSERVURL to see if that helps.....

Try something like this...

(
Also the URL in GRAPHSERVURL might need a username and password like this:

SET GRAPHSERVURL= assword@whatever/ibi_apps/IBIGraphServlet" TARGET=_blank>http://usernameRazzerassword@whatever/ibi_apps/IBIGraphServlet
)

SET GRAPHSERVURL=http://whatever/ibi_apps/IBIGraphServlet

GRAPH FILE WHATEVER
CODE HERE...
ON GRAPH HOLD AS XXX FORMAT GIF
END
TABLE FILE CAR
SUM SALES NOPRINT
ON TABLE SET STYLE *
$
TYPE=REPORT, IMAGE=XXX .gif, POSITION=(0 0), SIZE=(3 3), $
ENDSTYLE
END