I'm trying to send a graph report as an email attachment using Report Caster. The caster task completes, and the htm file is attached to the email, but when I try to open the email, it will not display. The forum searches I did gave me the "SET GRAPHEDIT=SERVER" line of code, but that does not appear to have fixed the problem.

Any help would be appreciated.

-*FINAL GRAPH >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
DEFINE FILE SF86GRAPH
END

SET GRAPHEDIT=SERVER
SET LOOKGRAPH=VBAR
SET 3D=OFF 
SET HAXIS=1500
SET VAXIS=1100

GRAPH FILE SF86GRAPH
-*"SF86 Worksheet Section Rejections - Last 90 Days"
SUM
TOTAL_30 AS '30 Days'
TOTAL_60 AS '60 Days'
TOTAL_90 AS '90 Days'

ACROSS SECTION AS ''

ON GRAPH SET GRAPHSTYLE *

-*Move the graph closer to the title
setPlace(true);

-*Display Numerical Value Above Graph Bar
setDataTextDisplay (true);
setDataTextPosition(1);

setFontName(getDataText(),"Arial");
setFontSizeAbsolute(getDataText(),true);
setAutofit(getDataText(),false);
setFontSize(getDataText(),10);

-*Adjust Riser Column Width
setRiserWidth(90);
setLineWidth(getSeries(0),6)
setLineWidth(getSeries(1),6)
setLineWidth(getSeries(2),6)

-*Graph Title and Orientation
setTitleString("SF86 Worksheet Section Rejections - Last 90 Days");
setTextJustHoriz(getTitle(),1);
setFontName(getTitle(),"Arial");
setAutofit(getTitle(),false);
setFontSizeAbsolute(getTitle(),true);
setFontSize(getTitle(),16);

-*Enable/Disable Legend Box
setLegendDisplay(true);
setFontName(getLegendText(),"Arial");
setAutofit(getLegendText(),false);
setFontSizeAbsolute(getLegendText(),true);
setFontSize(getLegendText(),12);

-*Set the font and size of the X-Axis Title
setO1TitleString("Section");
setFontName(getO1Title(),"Arial");
setAutofit(getO1Title(),false);
setFontSizeAbsolute(getO1Title(),true);
setFontSize(getO1Title(),14);

-*Set the display angle of the X-Axis labels
setO1LabelRotate(2);

-*Set the font and size of the X-Axis labels
setFontName(getO1Label(0),"Arial");
setAutofit(getO1Label(0),false);
setFontSizeAbsolute(getO1Label(0),true);
setFontSize(getO1Label(0),14);

-*Set the font and size of the Y-Axis Title
setY1TitleString("Number of Rejects");
setFontName(getY1Title(),"Arial");
setAutofit(getY1Title(),false);
setFontSizeAbsolute(getY1Title(),true);
setFontSize(getY1Title(),14);
setTextWrap(getY1Title(),true);

-*Set the font and size of the Y-Axis labels
setFontName(getY1Label(),"Arial");
setFontSizeAbsolute(getY1Label(),true);
setAutofit(getY1Label(),false);
setFontSize(getY1Label(),14);

-*Set the Y-Axis Increments
setY1MajorGridStep(100);
setY1MajorGridStepAuto(false);

-*Set the number formatting of the Y-Axis Increments
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"###,###");

-*Set the fill color of the 30 day graph bar values
-*Red = (255,0,0)
-*Yellow = (255,255,0)
-*Green = (0,255,0)
-*White = (255,255,255)
setFillType(1);
setFillColor(getSeries(0), new Color(255,0,0));
setFillColor(getSeries(1), new Color(255,255,0));
setFillColor(getSeries(2), new Color(0,255,0));

-*Gridlines
setY1MajorGridDisplay(false);
setX1MajorGridDisplay(false);

ENDSTYLE
ON GRAPH SET STYLE *
     PAGESIZE='Letter',
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.250000,
     TOPMARGIN=0.100000,
     BOTTOMMARGIN=0.100000,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
END

This message has been edited. Last edited by: Kerry,

Put this at the beginning of your focexec:

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

Todd,

What report format are you specifying in the ReportCaster task?

In the WebFOCUS 76 Best Practices document called "Considerations When Using ReportCaster," the following is specified on p. 13:

"In order to distribute a graph, you must use the GIF, JPG, PNG, or SVG format, or embed it in a PDF file."

The link for the Best Practices document is below:

http://documentation.informati...bestpractices767.pdf

Terry

My output is:

ON GRAPH PCHOLD FORMAT GIF
END

The error I'm getting seems to be Java related:

Java Plug-in 1.6.0_13
Using JRE version 1.6.0_13 Java HotSpot(TM) Client VM
User home directory = C:\Documents and Settings\mosest
----------------------------------------------------
c: clear console window
f: finalize objects on finalization queue
g: garbage collect
h: display this help message
l: dump classloader list
m: print memory usage
o: trigger logging
q: hide console
r: reload policy configuration
s: dump system and deployment properties
t: dump thread list
v: dump thread stack
x: clear classloader cache
0-5: set trace level to
----------------------------------------------------


IBIApplets: ibi.mra.IBIMRADmin1 run on Jun 16, 2009 2:38:03 PM EDT
IBIApplets: gen on Wed Nov 14 23:04:33 EST 2007, gen number=168, gen key=nUOt8oRcjnWOgNkl
IBIApplets: java.version='1.6.0_13',java.vendor='Sun Microsystems Inc.',java.vendor.url='http://java.sun.com/',java.class.version='50.0',os.name='Windows XP',os.arch='x86',os.version='5.1',
Directive not found in IBIMRcgi: ---VAR---START
Directive not found in IBIMRcgi: ---VAR---END
Directive not found in IBIMRcgi: ---VAR---START
Directive not found in IBIMRcgi: ---VAR---END
Directive not found in IBIMRcgi: ---VAR---START
Directive not found in IBIMRcgi: ---VAR---END
Directive not found in IBIMRcgi: ---VAR---START
Directive not found in IBIMRcgi: ---VAR---END
JVM version : 1.6.0_13
JVM vendor : Sun Microsystems Inc.
JVM version integer: 16013
Directive not found in IBIMRcgi: ---VAR---START
Directive not found in IBIMRcgi: ---VAR---END
Directive not found in IBIMRcgi: ---VAR---START
Directive not found in IBIMRcgi: ---VAR---END
Directive not found in IBIMRcgi: ---VAR---START
Directive not found in IBIMRcgi: ---VAR---END
Directive not found in IBIMRcgi: ---VAR---START
Directive not found in IBIMRcgi: ---VAR---END
load: class ibi.applet.graph.ServerSideGraph.class not found.
java.lang.ClassNotFoundException: ibi.applet.graph.ServerSideGraph.class
at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.plugin2.applet.Plugin2ClassLoader.loadCode(Unknown Source)
at sun.plugin2.applet.Plugin2Manager.createApplet(Unknown Source)
at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.FileNotFoundException: C:\ibi_html\javaassist\ibi\applet\graph\ServerSideGraph\class.class (The system cannot find the path specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(Unknown Source)
at java.io.FileInputStream.(Unknown Source)
at sun.net.www.protocol.file.FileURLConnection.connect(Unknown Source)
at sun.net.www.protocol.file.FileURLConnection.getInputStream(Unknown Source)
at sun.plugin2.applet.Applet2ClassLoader.getBytes(Unknown Source)
at sun.plugin2.applet.Applet2ClassLoader.access$000(Unknown Source)
at sun.plugin2.applet.Applet2ClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
... 7 more
Exception: java.lang.ClassNotFoundException: ibi.applet.graph.ServerSideGraph.class
Directive not found in IBIMRcgi: ---VAR---START
Directive not found in IBIMRcgi: ---VAR---END
Directive not found in IBIMRcgi: ---VAR---START
Directive not found in IBIMRcgi: ---VAR---END
load: class ibi.applet.graph.ServerSideGraph.class not found.
java.lang.ClassNotFoundException: ibi.applet.graph.ServerSideGraph.class
at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.plugin2.applet.Plugin2ClassLoader.loadCode(Unknown Source)
at sun.plugin2.applet.Plugin2Manager.createApplet(Unknown Source)
at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.FileNotFoundException: C:\ibi_html\javaassist\ibi\applet\graph\ServerSideGraph\class.class (The system cannot find the path specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(Unknown Source)
at java.io.FileInputStream.(Unknown Source)
at sun.net.www.protocol.file.FileURLConnection.connect(Unknown Source)
at sun.net.www.protocol.file.FileURLConnection.getInputStream(Unknown Source)
at sun.plugin2.applet.Applet2ClassLoader.getBytes(Unknown Source)
at sun.plugin2.applet.Applet2ClassLoader.access$000(Unknown Source)
at sun.plugin2.applet.Applet2ClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
... 7 more
Exception: java.lang.ClassNotFoundException: ibi.applet.graph.ServerSideGraph.class

Production - 7.6.4
Sandbox - 7.6.4

Did you add the line I suggested. That is required.

I added it to the very beginning of my code. Does it need to be in a specific spot?

You had best read the documentation on distributing graphs with ReportCaster. There are some very specific requirements both for WF coding/usage, as well as java requirements for the application server.

Start with Appendix C of the ReportCaster Administrator's manual and the "Configuring ReportCaster for Graphs" section of the installation manual.

Wow. WebFOCUS just gets more and more complicated with each report I run.

Why would a HTML file that is a graph be handled differently than an HTML file that is just a table?

This works for me. I run it as a test RC job every night.

SET GRAPHSERVURL=http://my_web_server/ibi_apps/IBIGraphServlet
GRAPH FILE CAR
SUM SALES
BY COUNTRY
ON GRAPH SET LOOKGRAPH PIEMULTI
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 GRAPH SET GRAPHSTYLE *
...
ENDSTYLE
END

I'm checking with our IT folks to see if we have ever configured WebFOCUS to send the graphs with Report Caster.

Thank you for your help.