tstreeter

Members
  • Content count

    8
  • Joined

  • Last visited

Everything posted by tstreeter

  1. Chart Scaling - Pie2d

    Ran into an issue when dsiplaying 2 Pie2d side by side. Even though the chart size is exactly the same. When the chart is drawn, it's taking the label names/values as precedent and makes the chart larger or smaller depending on the labels and values. The result is 2 charts with the same labels but differenet values is dsiplayed in 2 sizes. If I turn the values off. The charts are the same size. Is there any way to force the code to set the space required for labels/values to taker a lower precedent and have the chart be sized first and than have the labels/values use the remaining space? Please see screenshot for example Here is the code. <% 'In this example, we show how to connect FusionCharts to a database. 'For the sake of ease, we've used an Access database which is present in '../DB/FactoryDB.mdb. It just contains two tables, which are linked to each 'other. 'Database Objects - Initialization Dim oRs, oRs2, strQuery 'strXML will be used to store the entire XML document generated Dim strXML 'Create the recordset to retrieve data Set oRs = Server.CreateObject("ADODB.Recordset") 'Generate the chart element strXML = "<chart caption='Count of Open Records by Queue Type HFD' subcaption='Previous Day (Click on Chart for Detail)' showlabels='1' showvalues='1' showBorder='0' formatNumberScale='0' slantLabels='0' useRoundEdges='1' skipOverlapLabels='0' clickurl='f-main-http://cskdev03/ccx/FusionCharts/FusionCharts_Evaluation/Code/ASP/DBExample/eBins_HFD_QN_Open.asp'>" 'Iterate strQuery = "select * from QT_Open_HFD_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(countofactivityid) as TotOutput from QT_Open_HFD_Output where Graph_ID=" & ors("Graph_ID") Set oRs2 = oConn.Execute(strQuery) 'Generate <set label='..' value='..' /> strXML = strXML & "<set label='" & ors("QueueType") & "' value='" & ors2("TotOutput") & "' />" 'Close recordset Set oRs2 = Nothing oRs.MoveNext Wend 'Finally, close <chart> element strXML = strXML & "</chart>" Set oRs = nothing 'Create the chart - Pie 3D Chart with data from strXML Call renderChart("../../FusionCharts/pie2d.swf", "", strXML, "Chart_1", 400, 330, false, false) %></td> <td><% 'Create the recordset to retrieve data Set oRs = Server.CreateObject("ADODB.Recordset") strXML = "<chart caption='Count of Closed Records by Queue Type HFD' subcaption='Previous Day (Click on Chart for Detail)' showlabels='1' showvalues='1' showBorder='0' formatNumberScale='0' slantLabels='0' useRoundEdges='1' skipOverlapLabels='0' clickurl='f-main-http://cskdev03/ccx/FusionCharts/FusionCharts_Evaluation/Code/ASP/DBExample/eBins_HFD_QN_Closed.asp'>" 'Iterate through each factory strQuery = "select * from QT_Closed_HFD_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(countofqueue_name) as TotOutput from QT_Closed_HFD_Output where Graph_ID=" & ors("Graph_ID") Set oRs2 = oConn.Execute(strQuery) 'Generate <set label='..' value='..' /> strXML = strXML & "<set label='" & ors("QueueType") & "' value='" & ors2("TotOutput") & "' />" 'Close recordset Set oRs2 = Nothing oRs.MoveNext Wend 'Finally, close <chart> element strXML = strXML & "</chart>" Set oRs = nothing Call renderChart("../../FusionCharts/pie2d.swf", "", strXML, "Chart_2", 400, 330, false, false)
  2. Chart Scaling - Pie2d

    Worked perfectly...thanks for the quick response. Another question...Is there a reference for all the switches to the charts in the documentation? I looked at the reference for the Chart Elements and did not see this one listed. I'm using the full version. Thanks
  3. 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.
  4. 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.
  5. License

    Would like to first say Great Product. Have been using the free version to pull data from an access database and the process could not have been easier. Question regarding the licensing. We would mainly deploying fusion charts on our internal intranet page. How would the licesne be register. Would it be registered to our domain name of which we have two. Gentiva.com and CareCentrix.com And if the license is regsitered to either domain name, what impact would this have on the usability on the intranet page on a local server. Thanks Tom