1dmf

Hi, Can someone point me in the right direction on how i would go about automating reporting using Fusion Charts. We currently use the free version for our extranet application where a user needs to open a browser, navigate to the reporting GUI, select parameters and run the report to generate the charts. Management would like automated reproting emailed to them in PDF format without the need for manual intervention. How would I go about doing this? Thanks, 1DMF.

I use JS and AJAX to create graphs like this... function disp_charts(myxml){ mytype = document.getElementById('chart_type').value; var myChart = new FusionCharts("myurl/FusionCharts/" + mytype, "myChart", mywidth, myheight); myChart.setDataXML(escape(myxml)); myChart.render("report_chart"); gXML = myxml; } So the ajax call is made, which returns the XML and draws the chart, i then store the returned xml in gXML. So on my user interface I have a select list for ZOOM function , you'll notice the global vars mywidth & myheight. I then use the following onchange event for the zoom selector tool.... // Zoom Graph function zoom(per){ mywidth= 900; myheight = 400; mywidth = mywidth * per; myheight = myheight * per; mytype = document.getElementById('chart_type').value; if(mytype.match("Pie") != null || mytype.match("Dough") != null){ if(mytype.match("FCF_Pie3D") != null){ pRad = 300; } else{ pRad = 150; } var oVal = cPer * pRad; var nVal = per * pRad; cPer = per; gXML = gXML.replace("pieRadius='"+oVal+"'","pieRadius='"+nVal+"'"); } var myChart = new FusionCharts("myurl/FusionCharts/" + mytype, "myChart", mywidth, myheight); myChart.setDataXML(escape(gXML)); myChart.render("report_chart"); } You will notice i've had to deal with pie charts and the fact that 2d & 3d use different sizes for radius. So you could possibly use this logic to enable 're-rendering' of charts with a different chart type via an onchange event select list. Hope this helps.

does this help.... http://www.fusioncharts.com/Docs/Contents/PercentResize.html

Ah right, no wonder you weren't making any sense! I've used the correct SWF and it sort of works, why does it not show the headings / legend for each column? I.E Mortgages, Insurance, Loans, I just get the subset legend for completions , submissions and NPW, plus it shows them 3 times, so i';ve had to remove the name from two lots to get the correct legend colour display! Thanks, 1DMF.

what chart types are relevant for a multi-series chart if it's not the multi-series SWF's ? I'm confused! :hehe: Edit: I just tried the following types... FCF_MSColumn3D.swf FCF_MSColumn2D.swf FCF_Column3D.swf FCF_Column2D.swf and got the same result, so I don't understand what you are saying? if neither Multi-Series and Non-Multi-Series chart swf's work, what's left? what swf are you talking about?

FCF_MSColumn3D.swf

? Can anyone spot an error ?

Well I've tried it and all the graph shows is 'no data to display', here is the XML - <graph caption="[b]Business Spread ( )[/b]" xAxisName="[b]Business Type[/b]" yAxisName="[b]Business Volume ( 6 )[/b]" showNames="[b]1[/b]" decimalPrecision="[b]0[/b]" formatNumberScale="[b]0[/b]">- <categories> <category name="[b]Craig Chant[/b]" /> </categories>- <dataset seriesName="[b]Mortgage (2)[/b]" color="[b]F6BD0F[/b]">- <dataset seriesName="[b]Submissions[/b]" color="[b]F6BD0F[/b]"> <set value="[b]1[/b]" /> </dataset>- <dataset seriesName="[b]Completions[/b]" color="[b]F6BD0F[/b]"> <set value="[b]1[/b]" /> </dataset>- <dataset seriesName="[b]NPW[/b]" color="[b]F6BD0F[/b]"> <set value="[b]0[/b]" /> </dataset> </dataset>- <dataset seriesName="[b]Loan (1)[/b]" color="[b]F6BD0F[/b]">- <dataset seriesName="[b]Submissions[/b]" color="[b]F6BD0F[/b]"> <set value="[b]1[/b]" /> </dataset>- <dataset seriesName="[b]Completions[/b]" color="[b]F6BD0F[/b]"> <set value="[b]0[/b]" /> </dataset>- <dataset seriesName="[b]NPW[/b]" color="[b]F6BD0F[/b]"> <set value="[b]0[/b]" /> </dataset> </dataset>- <dataset seriesName="[b]Insurance (3)[/b]" color="[b]F6BD0F[/b]">- <dataset seriesName="[b]Submissions[/b]" color="[b]F6BD0F[/b]"> <set value="[b]3[/b]" /> </dataset>- <dataset seriesName="[b]Completions[/b]" color="[b]F6BD0F[/b]"> <set value="[b]0[/b]" /> </dataset>- <dataset seriesName="[b]NPW[/b]" color="[b]F6BD0F[/b]"> <set value="[b]0[/b]" /> </dataset> </dataset> </graph>

ah so you wrap each dataset series with another dataset tag to group them together. I'll have a play and see what i can come up with. Thanks, 1DMF

Well in that case it doesn't work, i tried it and it made no difference.

*BUMP* , still have problem, don't know where to put this extra attribute you mention

Am I to take it it isn't possible? So no point in purchasing FCv3 ?

Ah ,yes could be , there is a caveat in the 'myChart.setDataXML' method usage notes which says large data can cause the chart to hang and recommends using the 'myChart.setDataURL' method. URL : http://www.fusioncharts.com/free/docs/?gMenuItemId=19 could this be the reason?

Really, mine don't, never have and never will, So if it is happening are you sure it's to do with AJAX, seings it's just javascript making a HTTP request to a server and receiving back simple XML. Unless you have the switch in the HTTPRequest component to be 'Syncronous' and that's causing the problem, because your telling the request to wait for a response, though I don't use syncronous mode normally , I did play with the switch out of curiosity and I couldn't see a difference in my AJAX apps.

AJAX requests do not hang a browser! and navigating away from a page will naturally stop the AJAX request. That's just how AJAX works.