Problems With Renderchart()

JezLisle · September 19, 2011

I am putting multiple charts on a single file. I have created 2 graphs so far that render fine. The problem is that for some reason the second graph doesnt plot correctly. It seems to pick up some of the data set from the 1st chart and I dont know why.

Below is my code

Where have I gone wrong?

BuildGraph1.php

<?php

include("connection.php");

include("sql.php");

$sql = $strsql;

$rs=odbc_exec($cnn,$sql);

if (!$rs)

{exit("Error in SQL");}

$i = 0;

while (odbc_fetch_row($rs))

{

$monthname =odbc_result($rs,"MonthName");

$referral =odbc_result($rs,"Referrals");

$discharge =odbc_result($rs,"Discharges");

$arrData[$i++]['1'] = $monthname;

$arrData[$i++]['2'] = $referral;

$arrData[$i++]['3'] = $discharge;

}

//Initialize <chart> element

$strbuildgraph1xml = "<chart caption='Referrals Against Discharges' xAxisName='Months' yAxisName='Counts' bgAlpha='0,0' canvasBgAlpha='0' showExportDataMenuItem='1' exportEnabled='1' exportHandler='class/exporter' exportAtClient='0' exportAction='download' exportTargetWindow='_blank' exportFileName='MyFileName' numberPrefix='' formatNumberScale='1' rotateValues='1' placeValuesInside='1' decimals='0' >";

//Initialize <categories> element - necessary to generate a multi-series chart

$strCategories = "<categories>";

//Initiate <dataset> elements

$strDataCurr = "<dataset seriesName='Referrals'>";

$strDataPrev = "<dataset seriesName='Discharges'>";

//Iterate through the data

foreach ($arrData as $arSubData)

{

//Append <category name='...' /> to strCategories

$strCategories .= "<category name='" . $arSubData['1'] . "' />";

//Add <set value='...' /> to both the datasets

$strDataCurr .= "<set value='" . $arSubData['2'] . "' />";

$strDataPrev .= "<set value='" . $arSubData['3'] . "' />";

}

//Close <categories> element

$strCategories .= "</categories>";

//Close <dataset> elements

$strDataCurr .= "</dataset>";

$strDataPrev .= "</dataset>";

//Assemble the entire XML now

$strbuildgraph1xml .= $strCategories . $strDataCurr . $strDataPrev . "</chart>";

odbc_close($cnn);

?>

BuildGraph2.php

<?php

include("connection.php");

include("sql2.php");

$sql = $strsqlconsortia;

$rs=odbc_exec($cnn,$sql);

if (!$rs)

{exit("Error in SQL");}

$i = 0;

while (odbc_fetch_row($rs))

{

$monthname =odbc_result($rs,"MonthName");

$boston =odbc_result($rs,"Boston");

$eastlindsey =odbc_result($rs,"EastLindsey");

$lincolnshiresouthwest =odbc_result($rs,"LincolnshireSouthWest");

$lincolnshirewest =odbc_result($rs,"LincolnshireWest");

$skegnesscoast =odbc_result($rs,"SkegnessCoast");

$southholland =odbc_result($rs,"SouthHolland");

$wellcomm =odbc_result($rs,"Wellcomm");

$arrData[$i++][1] = $monthname;

$arrData[$i++][2] = $boston;

$arrData[$i++][3] = $eastlindsey;

$arrData[$i++][4] = $lincolnshiresouthwest;

$arrData[$i++][5] = $lincolnshirewest;

$arrData[$i++][6] = $skegnesscoast;

$arrData[$i++][7] = $southholland;

$arrData[$i++][8] = $wellcomm;

}

//Initialize <chart> element

$strbuildgraph2xml = "<chart caption='Referrals By Month' xAxisName='Months' yAxisName='Counts' bgAlpha='0,0' canvasBgAlpha='0' numberPrefix='' formatNumberScale='1' rotateValues='1' placeValuesInside='1' decimals='0' >";

//Initialize <categories> element - necessary to generate a multi-series chart

$strCategories = "<categories>";

//Initiate <dataset> elements

$strDataRow1 = "<dataset seriesName='Boston'>";

$strDataRow2 = "<dataset seriesName='EastLindsey'>";

$strDataRow3 = "<dataset seriesName='LincolnshireSouthWest'>";

$strDataRow4 = "<dataset seriesName='LincolnshireWest'>";

$strDataRow5 = "<dataset seriesName='SkegnessCoast'>";

$strDataRow6 = "<dataset seriesName='SouthHolland'>";

$strDataRow7 = "<dataset seriesName='Wellcomm'>";

//Iterate through the data

// as $arSubData

//while ($arrData as $arSubData) {

foreach ($arrData as $arSubData) {

//Append <category name='...' /> to strCategories

$strCategories .= "<category name='" . $arSubData[1] . "' />";

//Add <set value='...' /> to both the datasets

$strDataRow1 .= "<set value='" . $arSubData[2] . "' />";

$strDataRow2 .= "<set value='" . $arSubData[3] . "' />";

$strDataRow3 .= "<set value='" . $arSubData[4] . "' />";

$strDataRow4 .= "<set value='" . $arSubData[5] . "' />";

$strDataRow5 .= "<set value='" . $arSubData[6] . "' />";

$strDataRow6 .= "<set value='" . $arSubData[7] . "' />";

$strDataRow7 .= "<set value='" . $arSubData[8] . "' />";

}

//Close <categories> element

$strCategories .= "</categories>";

//Close <dataset> elements

$strDataRow1 .= "</dataset>";

$strDataRow2 .= "</dataset>";

$strDataRow3 .= "</dataset>";

$strDataRow4 .= "</dataset>";

$strDataRow5 .= "</dataset>";

$strDataRow6 .= "</dataset>";

$strDataRow7 .= "</dataset>";

//Assemble the entire XML now

$strbuildgraph2xml .= $strCategories . $strDataRow1 . $strDataRow2 . $strDataRow3 . $strDataRow4 . $strDataRow5 . $strDataRow6 . $strDataRow7 . "</chart>";

odbc_close($cnn);

?>

This is my render file pulling both php files above together

<?php

// Turn off all error reporting

error_reporting(0);

include("class/FusionCharts.php");

include("buildgraph1.php");

include("buildgraph2.php");

?>

<!DOCTYPE html>

<head>

</head>

<body>

<?php

$strXML = $strbuildgraph1xml;

//Create the chart - MS Column 3D Chart with data contained in strXML

echo renderChartHTML("charts/MSColumn3D.swf", "", $strXML, "ReferralsAgainstDischarges", 430, 230, false, true);

?>

</div>

<?php

$strXML1 = $strbuildgraph2xml;

//Create the chart - MS Column 3D Chart with data contained in strXML

echo renderChartHTML("charts/MSColumn3D.swf", "", $strXML1, "ReferralsByMonthByConsortia", 900, 230, false, false);

?>

</div>

</body>

</html>

September 20, 2011

Hi,

Thanks for your post.

Could you please try once by using renderChart() method instead of renderChartHTML() ?

Awaiting for your response.

JezLisle · September 20, 2011

I had already tried that, and was experiencing the same issue. 2 charts render ok, but the second chart displays data from the first data set and other data that doesn't match what it should. If I was to take the first chart off the page then the second chart renders the correct data set. It's only when I put them both together it doesnt render correctly

Jez

JezLisle · September 21, 2011

Can anyone help with this?

It's difficult trying to understand the online documentation and think how it's fits to your own individual need and this being the only forum for advice

JezLisle · October 20, 2011

Can anyone help with this?

It's difficult trying to understand the online documentation and think how it's fits to your own individual need and this being the only forum for advice

I am still struggling with this, has anyone any ideas how I can resolve it?

Thanks

October 21, 2011

Hi,

Thanks for your response.

Could you please send us the generated XML code to test it from our end?

Awaiting for your response.

JezLisle · October 21, 2011

Hi,

Thanks for your response.

Could you please send us the generated XML code to test it from our end?

Awaiting for your response.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>InformationTeam</title>

</head>

<body>

<ul>

</ul>

</div>

<h1><a href="#">InformationTeam</a></h1>

</div>

</object>

</div>

</object>

</div>

</div>

</div>

</body>

</html>

JezLisle · October 26, 2011

Have you had a chance to look over the generated XML. How can I fix the problem?

JezLisle · November 2, 2011

From this generated

code I have posted, how can I fix the issue of showing multiple charts?

JezLisle · November 28, 2011

From this generated

code I have posted, how can I fix the issue of showing multiple charts?

Can anyone help with this issue?

Thanks,

Jez

November 28, 2011

Hi,

Thanks for your response.

I am afraid, we are unable to replicate the issue, as the code sent by you is working fine from our end.

Please find the screenshot attached for your reference.

JezLisle · November 28, 2011

Hi,

Thanks for your response.

I am afraid, we are unable to replicate the issue, as the code sent by you is working fine from our end.

Please find the screenshot attached for your reference.

Thanks for the response, my problem isnt with displaying multiple graphs, the problem is displaying correct data on the second chart. If you run the code and display the charts, look at the second chart and you will see that for some reason it populates some of the data from Chart1 into chart2 and I dont understand why?

Jez

JezLisle · November 29, 2011

Thanks for the response, my problem isnt with displaying multiple graphs, the problem is displaying correct data on the second chart. If you run the code and display the charts, look at the second chart and you will see that for some reason it populates some of the data from Chart1 into chart2 and I dont understand why?

Jez

Have you been able to replicate the problem?

I can't understand why a second, third chart would pick up the data set from chart1 and not include the apropriate data set even though they are split out as 2 data sets

Jez

JezLisle · November 29, 2011

I have found the problem, it was down to the naming conventions of the Arrays in both charts, as they were named the same the second chart was always picking data from the first chart.

Jez

November 29, 2011

Hi,

Glad to know that you have managed to resolve your problem.

Happy FusionCharting!!!

Problems With Renderchart()

Recommended Posts

Share this post

Link to post

Share on other sites

Guest Angshu

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Guest Angshu

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Guest Angshu

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Guest Angshu

Share this post

Link to post

Share on other sites

Create an account or sign in to comment

Create an account

Sign in