I am using classic asp to get data from database and loading into an xml string, how do I setup the new fusioncharts? It was working fine, but now we have upgraded to XT for single developer it is all different. I had an include file which does all the calcs from db then adds to strXML as below:
<%
'strXML will be used to store the entire XML document generated
Dim strXML
strXML = "<graph xaxisname='' yaxisname='Percent' numberSuffix='%25' basefontsize='12' basefont='Arial' hovercapbg='DEDEBE' decimalPrecision='0' hovercapborder='889E6D' rotateNames='0' animation='1' yAxisMaxValue='100' numdivlines='9' divLineColor='CCCCCC' divLineAlpha='80' decimalPrecision='0' showAlternateHGridColor='1' AlternateHGridAlpha='30' AlternateHGridColor='CCCCCC' caption='Percentage of Engagement' subcaption='' >"
'Generate <set name='..' value='..'/>
strXML = strXML & " <categories font='Arial' fontSize='12' fontColor='000000'> <category name='" & date_1 & "' hoverText=''/> <category name='" & date_2 & "' /> <category name='" & date_3 & "' /> <category name='" & date_4 & "' /> </categories>"
strXML = strXML & "<dataset seriesname='Actively Disengaged' color='CD8517' showValues='0' alpha='100'> <set value='" & Cint(disen1*100) & "' /> <set value='" & Cint(disen2*100) & "' /> <set value='" & Cint(disen3*100) & "' /> <set value='" & Cint(disen4*100) & "' /> </dataset>"
strXML = strXML & "<dataset seriesname='Not Engaged' color='FEEEBB' showValues='0' alpha='100'> <set value='" & Cint(noten1*100) & "' /> <set value='" & Cint(noten2*100) & "' /> <set value='" & Cint(noten3*100) & "' /> <set value='" & Cint(noten4*100) & "' /> </dataset>"
strXML = strXML & "<dataset seriesname='Engaged' color='F9B240' showValues='0' alpha='100'> <set value='" & Cint(engaged1*100) & "' /> <set value='" & Cint(engaged2*100) & "' /> <set value='" & Cint(engaged3*100) & "' /> <set value='" & Cint(engaged4*100) & "' /> </dataset>"
'Finally, close <chart> element
strXML = strXML & "</graph>"
%>
Then from ASP page load the chart as below:
<script type="text/javascript">
var myChart = new FusionCharts("../../../FusionCharts/FCF_StackedColumn2D.swf", "myChartId", 450, 450);
myChart.setDataXML("<%=strXML%>");
myChart.render("chartdiv");
</script>
Can I still use this method to create a chart using current version??? Can't find much help on how to format new FusionCharts
