FusionCharts Forum / FusionCharts Free / FusionCharts Free and JSP

How to save FusionChart as Image (Jpeg,gif)

Abhi — Thu, 17 Apr 2008 00:53:36 GMT

Hello Fusion Chart,

I am exploring Fusion Charts Free and need to know how to save FusionChart as an Image (Jpeg,gif). I am not able to find any option to save it as jpeg etc.

Pls help.

Regards,

Abhi

JSP and CreateChart method

Abhi — Wed, 16 Apr 2008 01:57:31 GMT

Hello,

I am trying to use Fusion Free Charts with jsp. When i run my code below from browser i am getting the following error as its asking for CreateChart method -

Pls help resolve this error. What is there create chart method and how can i find it ?

ERROR :

************************************************************

An error occurred at line: 87 in the jsp file: /FusionCharts/MyChart/fusion.jsp
The method createChart(String, String, String, String, int, int, boolean, boolean) is undefined for the type fusion_jsp
84: }

************************************************************

Code is below

************************************************************

<jsp:useBean id="dbconn" class = "dbcon.ConnectionUtil" scope="page"/>

<%@ page import="java.sql.Statement"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.sql.Date"%>
<HTML>
<HEAD>
<TITLE>FusionCharts - Database Example</TITLE>
<SCRIPT LANGUAGE="Javascript" SRC="FusionCharts.js"></SCRIPT>
</HEAD>
<BODY>

<%
/*
In this example, we show how to connect FusionCharts to a database.
For the sake of ease, we've used a database which contains two tables,
which are linked to each other.
*/
Connection conn;
conn = dbconn.getConnection();
//Database Objects - Initialization
Statement st1,st2;
ResultSet rs1,rs2;

String strQuery="";

//strXML will be used to store the entire XML document generated
String strXML="";

//Generate the chart element
strXML = "<chart caption='Factory Output report' subCaption='By Quantity pieSliceDepth='30' showBorder='1' formatNumberScale='0' numberSuffix='Units'>";

//Construct the query to retrieve data
strQuery = "select * from sarlogs";

st1=conn.createStatement();
rs1=st1.executeQuery(strQuery);
String factoryvalue= null;
String factoryId=null;
String factoryName=null;
String totalOutput="";
//Iterate through each factory
while(rs1.next()) {

factoryId=rs1.getString("timestamp");
factoryvalue=rs1.getString("value");
factoryName="SERVER1";
//Now create second recordset to get details for this factory
//Generate <set label='..' value='..'/>
strXML += "<set label='" + factoryName + "' value='" +factoryvalue+ "'/>";
//Close resultset
} //end of while
//Finally, close <chart> element
strXML += "</chart>";
//close the resulset,statement,connection
try {
if(null!=rs1){
rs1.close();
rs1=null;
}
}catch(java.sql.SQLException e){
System.out.println("Could not close the resultset");
}
try {
if(null!=st1) {
st1.close();
st1=null;
}
}catch(java.sql.SQLException e){
System.out.println("Could not close the statement");
}
try {
if(null!=conn) {
conn.close();
conn=null;
}
}catch(java.sql.SQLException e){
System.out.println("Could not close the connection");
}

//Create the chart - Pie 3D Chart with data from strXML
String chartCode=createChart("../../FusionCharts/line.swf", "", strXML,
"FactorySum", 600, 300, false, false);

%>
<%=chartCode%>

</BODY>
</HTML>

************************************************************

Scriptless JSP Page?

Jooly — Sun, 23 Mar 2008 23:58:16 GMT

hi there,

is there any way to embed fusionchart in a jsp without using scriptlets?

Thanks in advance:)

Charts in Liferay Portlet

scharan — Mon, 21 Jan 2008 01:30:33 GMT

Hi i am using LIferay portlet environment, on portlet i am displaying the fusion charts but i am unable to load the swf object

"Error in Loading Data" in IE7 but not in Firefox.

Leonardo — Tue, 10 Jul 2007 13:47:17 GMT

I'm using the code below..
[code]var chart = new FusionCharts("shockwaves/charts/FCF_Column3D.swf", "ChartId", "450", "300", "0", "0");
chart.setDataXML("${wco:valueStack('primeiroGrafico')}");
chart.render("chartdiv");[/code]
and the value returned in [code]${wco:valueStack('primeiroGrafico')}[/code] is:
[code]
< graph caption='Clique Sobre a Barra' xAxisName='Safra' yAxisName='Faturamento' showNames='1' showValues='0' decimalPrecision='2' formatNumberScale='2' formatNumber='1' decimalSeparator=',' thousandSeparator='.' numberPrefix='R$' hovercapbg='FFECAA' hovercapborder='F47E00'>< set name='Atual' value='121342' color='FF0000'/>
[/code]

I'm using dataXML mode and not dataURL mode..
In Firefox the chart load but in IE7 no...what's the error??

fcgeneral.war

anners — Tue, 08 Jan 2008 17:38:44 GMT

Hi -

In the readme.txt file for FusionCharts_Evaluation/Code/JSP it says to install the fcgeneral.war file in your Tomcat webapp dir, but I cannot find the fcgeneral.war file. Can you let me know where I can get this?

thanks.
ann

Fusion chart with Java on server side

lauvshree — Sun, 26 Aug 2007 22:24:44 GMT

I would like to know if it is possible to generate a Fusion chart on the server side and store it on the server side.

feedData() and "numDisplaySets" pp

fusionchartsuser — Fri, 26 Oct 2007 07:33:06 GMT

Hello.

I'm trying to send a certain number of sets to de show using feedData method.

The parameter has to have the form:"&value=10,12,14&numDisplaySets=23" (for example).Is it possible to do that?

Thank you!

Odd behavior in setDataXML

cutigersfan — Mon, 02 Jul 2007 13:32:22 GMT

I originally used setDataURL until I found out that the free version doesn't support updating. No problem, I can retrieve the XML and use setDataXML in JSP. Once doing that, I found out that the VERY SAME XML doesn't work using both methods. It seems that setDataXML hates double quotes ("). So, I removed all of them... almost.

Here's the problem. Using setDataXML, I'd like to have a link to call a javascript function. That function should be able to have a parameter of type string like this:

[quote][code]<set value='5' link="javascript :myFunction('hello world')">[/code][/quote]

This syntax is represented in the drill down docs, but I can't seem to get it formatted so that setDataXML will take it.

Any help? Thanks!