FusionCharts Forum / FusionCharts v3 / Using FusionCharts / FusionCharts and ASP / Plotting a MSSeries chart from an Access Database / Latest Posts

RE: Plotting a MSSeries chart from an Access Database

Pallav — Fri, 23 May 2008 05:14:46 GMT

We do have a lot of examples for MS chart in our doc (Code folder) and the even more complex examples in our blueprint applications (open source; in multiple programming languages).

RE: Plotting a MSSeries chart from an Access Database

tstreeter — Mon, 19 May 2008 09:08:09 GMT

Yes I now the the goal is to combine the sources in the sytnax of the JS. However any type of coding I tried would just end with summing totals into the chart and not plot any type of MS series.

Can you give an example of what the code needs to look like to render correctly?

Considiering the use of Multiple Series types of charts. I was very surprised there is not a working example/sample of an MS series chart when pulling from an external data source.

RE: Plotting a MSSeries chart from an Access Database

Pallav — Sun, 18 May 2008 10:01:46 GMT

You can use any sources and combine them in your ASP script - FusionCharts just needs a single XML data stream.

Plotting a MSSeries chart from an Access Database

tstreeter — Tue, 13 May 2008 11:18:59 GMT

Trying to render a MSSeries chart through using DataXML method. Data is stored within a Access database. I have the tables already defined in my database and can pull them using a column2d or column3d.

What is the correct syntax / coding within the JS to pull the data from the different tables and render correctly? I tried working from the examples in the documentation but had no success.

Here is the code that I'm working from:

strXML = "<chart caption='Inventory of Activities - Previous Day' showBorder='0' formatNumberScale='0' labelDisplay='ROTATE' slantLabels='1' useRoundEdges='1'>"

'Iterate through each factory
strQuery = "select * from Actv_Master"
Set oRs = oConn.Execute(strQuery)

While Not oRs.Eof
'Now create second recordset to get details for this factory
Set oRs2 = Server.CreateObject("ADODB.Recordset")
strQuery = "select sum(Quantity) as TotOutput from Actv_HFD_Current where queueID=" & ors("queueID")
Set oRs2 = oConn.Execute(strQuery)
'Generate <set label='..' value='..' />
strXML = strXML & "<set label='" & ors("QueueName") & "' value='" & ors2("TotOutput") & "' />"
'Close recordset
Set oRs2 = Nothing
oRs.MoveNext
Wend
'Finally, close <chart> element
strXML = strXML & "</chart>"
Set oRs = nothing

Call renderChart("../../FusionCharts/mscolumn3d.swf", "", strXML, "Chart_1", 900, 275, false, false)

Any help would be greatly appreciated.