Julhas Sujan

Hi, Thank you very much for your response. I have added and tried, I got the prettyphoto after changing dropdown, but same data rendering. Here is my code. Please check: var myChart = new FusionCharts( "Pie3D.swf", "myChartId", "400", "300", "0", "1" ); myChart.setXMLUrl("sd_customer.xml"); FusionCharts("myChartId").render("chartContainer"); // I have added this but always contain the same data not change after changing dropdown. FusionCharts("myChartId").configureLink ({ width : '500', height: '320', id: 'linked-chart', renderAt : "linkedchart-container", overlayButton: { show : false } }, 0); FusionCharts("myChartId").addEventListener('BeforeLinkedItemOpen', function() { $.prettyPhoto.open("#prettyphoto-container",'LinkedCharts in PrettyPhoto','FusionCharts XT'); }); Julhas

Hi, I need urgent help. I am trying to show prettyphoto with jquery change event. In the first time change of html dropdown data, prettyphoto working fine but when I am changing again the html dropdown data the the prettyphoto does not work. And Can any1 help me? Here is the attachment of the full job. Thanks Julhas Sujan FusionCharts_Drill_down.zip

Hello Experts, Can any1 help me? Thanks

Hi, I need urgent help. I am trying to show prettyphoto with jquery change event. In the first time change of html dropdown data, prettyphoto working fine but when I am changing again the html dropdown data the the prettyphoto does not work. Can any1 help me? Here is the attachment of the full job. Thanks Julhas Sujan FusionCharts_Drill_down.zip

Ok thanks. I am trying.

Hi, My XML genersted by the following script: // Chart property $xml_output .= '<chart showBorder="0" caption="Yearly Sales" xAxisName="Year" yAxisName="Sales" exportEnabled="1" exportAtClient="1" exportHandler="fcExporter">'; $i=2004; while($a1=mysql_fetch_array($temp_count_data3)){ for($x2 = 0 ; $x2 < mysql_num_rows($temp_count_data2) ; $x2++) { $row2 = mysql_fetch_assoc($temp_count_data2); $qty=(integer)($row2['qty']); $xml_output .= "<set label='".$row2['ktext']."' value='".$row2['qty']."' link='newchart-xml-$i'/>\n"; $xml_output .="<linkeddata id='$i'>"; $xml_output .="<chart > <set label='".$row2['ktext']."' value='".$row2['qty']."' link='newchart-xml-$i'/>\n </chart> </linkeddata>"; $i++; } } $xml_output .= "</chart>\n"; echo $xml_output; ---------------------------------------------------------------------------------------------------------------------------------------------------- My XML looks like this: <?xml version="1.0"?> <chart showBorder="0" caption="Yearly Sales" xAxisName="Year" yAxisName="Sales" exportEnabled="1" exportAtClient="1" exportHandler="fcExporter"> <set label='Rangpur Area' value='58084.000' link='newchart-xml-2004'/> <linkeddata id='2004'> <chart > <set label='Rangpur Area' value='58084.000' link='newchart-xml-2004'/> </chart> </linkeddata> <set label='Khulna Area' value='35424.000' link='newchart-xml-2005'/> <linkeddata id='2005'> <chart > <set label='Khulna Area' value='35424.000' link='newchart-xml-2005'/> </chart> </linkeddata> <set label='Rajshahi Area' value='22724.000' link='newchart-xml-2006'/> <linkeddata id='2006'> <chart > <set label='Rajshahi Area' value='22724.000' link='newchart-xml-2006'/> </chart> </linkeddata> <set label='Kustia Area' value='18418.000' link='newchart-xml-2007'/> <linkeddata id='2007'> <chart > <set label='Kustia Area' value='18418.000' link='newchart-xml-2007'/> </chart> </linkeddata> <set label='Bogra Area' value='15028.000' link='newchart-xml-2008'/> <linkeddata id='2008'> <chart > <set label='Bogra Area' value='15028.000' link='newchart-xml-2008'/> </chart> </linkeddata> <set label='Faridpur Area' value='12688.000' link='newchart-xml-2009'/> <linkeddata id='2009'> <chart > <set label='Faridpur Area' value='12688.000' link='newchart-xml-2009'/> </chart> </linkeddata> <set label='Industrial Customers' value='11040.000' link='newchart-xml-2010'/> <linkeddata id='2010'> <chart > <set label='Industrial Customers' value='11040.000' link='newchart-xml-2010'/> </chart> </linkeddata> <set label='Barisal Area' value='9459.000' link='newchart-xml-2011'/> <linkeddata id='2011'> <chart > <set label='Barisal Area' value='9459.000' link='newchart-xml-2011'/> </chart> </linkeddata> <set label='Jessore Area' value='6656.000' link='newchart-xml-2012'/> <linkeddata id='2012'> <chart > <set label='Jessore Area' value='6656.000' link='newchart-xml-2012'/> </chart> </linkeddata> </chart> Thanks

Hi, Yes. I can not slove this issue. Can u help me? Thanks

Hi, Yes, I have added exportEnabled attribute. Thanks

Hi, I am trying to export normal chart as jpg/png... by using fushion chart property. It is working fine. But when I am trying to export chart from linked chart then it is not working. Here is my code and chart: Can any1 help me how can i solve this problem? Thanks Julhas

Thanks

Hi Moonmi, Your link is helpful. I am trying by using this: http://docs.fusioncharts.com/charts/Code/JavaScript/Basics/UsingLinkedCharts/jqprettyphoto.html Thanks

Hi Moonmi, Thank you very much. Can u help me how can i make the drill down like the following link? http://www.fusioncharts.com/explore/management-dashboard/ Julhas

Hi, I have tried to call css class/id with link attribute like that: <set label='' value='' link='#info' id='facebox' /> But I can not call the following division when I click on the above data chart. <a href="#info" id="facebox" > include 'details.php'; </a> --------------------------------------------------------------------------------- <script type="text/javascript"> jQuery(document).ready(function($) { $('a[rel*=facebox]').facebox({ loadingImage : '../SAP_V1/chart/facebox/src/loading.gif', closeImage : '../SAP_V1/chart/facebox/src/closelabel.png' }) }) </script> --------------------------------------------------------------------------------- How can i call the css id? or can any1 suggest me the alternative way to call the css id/class? Thanks

Hi, You may try like this: <script language="JavaScript" src="FusionCharts/FusionCharts.js"></script> <div class="gen-chart-render"> <center> <div id="customerAgingContainer1">Customer Aging Pie Chart will load here</div> <script type="text/javascript"><!-- FusionCharts.setCurrentRenderer('JavaScript'); var Chart1 = new FusionCharts("chart/Charts/Pie3D.swf", "myChartId", "100%", "45%", "0", "0"); Chart1.setXMLUrl("chart/sd/sd_customer_aging_div_01_data.xml"); Chart1.render("customerAgingContainer1"); </script> </center> </div> Thanks

Hi, You may try like this: <?php // Database Load require(dirname(__FILE__)."/../../config/db.php"); // Company code $bukrs = $_GET['cust_agign_value']; // Temporary table for aging calculation mysql_query("CREATE TEMPORARY TABLE temp_customer_aging ENGINE=MEMORY as (select kunnr,name, range30 range1,range60 range2,range90 range3, (range120+range150+range180+range210+range999) range4, (range30+range60+range90+range120+range150+range180+range210+range999) total from aging where bukrs='$bukrs')"); // Customer aging result table for range calculation with percentage calculate mysql_query("CREATE TEMPORARY TABLE customer_aging_result ENGINE=MEMORY as (select round((sum(range1)/sum(total))*100,2) range30,round((sum(range2)/sum(total))*100,2) range60, round((sum(range3)/sum(total))*100,2) range90, round((sum(range4)/sum(total))*100,2) range90_above from temp_customer_aging)"); // Temporary table for first range data insert mysql_query("CREATE TEMPORARY TABLE temp_final select 'range30' as Header, range30 as DATA from customer_aging_result"); // Insert 2nd data in temporary table mysql_query("INSERT INTO temp_final select 'range60' as Header, range60 as DATA from customer_aging_result"); // Insert 3rd data mysql_query("INSERT INTO temp_final select 'range90' as Header, range90 as DATA from customer_aging_result"); // Insert 4th Data mysql_query("INSERT INTO temp_final select 'range90_above' as Header, range90_above as DATA from customer_aging_result"); // Combining row data into column data $customer_aging_result=mysql_query("select * from temp_final"); // XML Start here $xml_output = "<?xml version=\"1.0\" ?>\n"; // Chart property Define $xml_output .= "\t<chart caption='' showvalues='1' unescapeLinks='1' legendPosition='BOTTOM' xAxisName='Customer Name' yAxisName='Amount' ieRadius='75'>\n"; $xml_output.= "<dataset showValues='1'>\n"; for($x2 = 0 ; $x2 < mysql_num_rows($customer_aging_result) ; $x2++) { $row2 = mysql_fetch_assoc($customer_aging_result); $xml_output .= "<set label='".$row2['Header']."' value='".$row2['DATA']."' link='#info' id='popup' />\n"; } $xml_output .= "\t</dataset>\n"; $xml_output .= "</chart>\n"; echo $xml_output; //Create the XML file $fp = fopen(dirname(__FILE__)."/../sd/sd_customer_aging_div_01_data.xml","wb"); //Write the XML nodes fwrite($fp,$xml_output); //Close the database connection fclose($fp); // Load chart javascript page require(dirname(__FILE__)."/../sd/sd_customer_aging_01_result.php"); // Start time load require(dirname(__FILE__)."/../../config/end_time.php"); // Temporary Table drop mysql_query("DROP TABLE temp_customer_aging"); mysql_query("DROP TABLE customer_aging_result"); // MySQL Close mysql_close($link); // See db connection in ../config/db.php ?>