|
|
|
Forum Newbie
Group: Forum Members
Last Login: Yesterday @ 11:31:15 AM
Posts: 8,
Visits: 18
|
|
| 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.
|
|
|
|
|
FusionCharts Team
Group: Administrators
Last Login: 10/3/2008 2:42:18 AM
Posts: 2,117,
Visits: 498
|
|
You can use any sources and combine them in your ASP script - FusionCharts just needs a single XML data stream.
Thanks,
Pallav Nadhani
FusionCharts Team
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: Yesterday @ 11:31:15 AM
Posts: 8,
Visits: 18
|
|
| 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.
|
|
|
|
|
FusionCharts Team
Group: Administrators
Last Login: 10/3/2008 2:42:18 AM
Posts: 2,117,
Visits: 498
|
|
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).
Thanks,
Pallav Nadhani
FusionCharts Team
|
|
|
|