FusionCharts Forum / FusionCharts v3 / Using FusionCharts / FusionCharts and ASP

using hyperlink variable passing

OzPac — Sun, 03 Aug 2008 21:22:48 GMT

Hi, what i am trying to archive is a from in which people select their preferences to be charted from drop down menus, these choices are then sent via hyperlink (i.e. CreateData.asp?Cgame=1&Ctype=2) to, in this case a page called createdata.asp which is the asp page which renders the xml page for my graph. When accessing the xml page with the desired variables passed the xml loads correctly, however the graph is not produced siting an error "error in loading data". have i got a error in my code or is this just not possible? if ur confused then ive put my code for the 2 pages below:

The code at the graph Page:
[code]
Dim strDataURL
strDataURL = "Data/CreateData.asp?Cgame="& Request("Game") &"&Ctype="& Request("Type") &""
Call renderChart("FCF_Line.swf", strDataURL, "", "ChartID1", 600, 350)
[/code]

Code in the createdata.asp xml rendering page:
[code]
If Request("Cgame") <> "none" then createstr = createstr + "WHERE game='" + Request("Cgame") + "'"
If Request("Cgame") <> "none" then qrycount = 1
If Request("CType") <> "none" AND qrycount = 1 Then createstr = createstr + " AND type='" + Request("Ctype") + "'"
If Request("CType") <> "none" AND qrycount = 0 Then createstr = createstr + " WHERE type='" + Request("Ctype") + "'"
If Request("Ctype") <> "none" then qrycount = 1

strQuery = "select * from Poker "& createstr &" ORDER BY Date, ID asc"

[/code]
thanks, Oz

scatter chart -- x-axis

arif_qaisar — Tue, 15 Jul 2008 02:54:00 GMT

Hi,

I am using Xml and vbscript to create a scatter chart. I have got the chart working with correct y axis but i want to design the x axis which is displayed as below:

strXML = "<chart subcaption='MSCI Europe index' numDivLines='5' rotateNames='1' showLegend='1' showNames='1' decimals='1' useRoundEdges='1' bgcolor='ffffff'>"

There are loads of figures for both x and y axis. I do not want to display all the figures.

I have worked it out for the y axis as shown above which I assume is numDivLine='5' in the above code.

Can i simplify the figures on the x-axis so that it shows me a few 'readable' figures?

Regards,

Arif Qaisar

HELP!

rafa_asilva — Wed, 16 Jul 2008 10:27:56 GMT

:w00t:

HI !

I use the free version and I am trying to adjust the series (bar and line) of the graph Col3DLineDY on the same scale.

Is it possible???

rafa

Combination Chart Column 3D Line (Single Y)

espressoitalia — Fri, 04 Jul 2008 03:10:16 GMT

Hi guys, I post my code to do a charth combination 3d line:

Dim arrData(1,5), arrDataQuantity(1,4)
arrData(0,1) = MonthName(MeseAttuale)
arrData(0,2) = TotalRevenueOpen
arrData(0,3) = TotalRevenueWon
arrData(0,4) = TotalRevenueLost
arrData(0,5) = TotalRevenueAbandon

arrDataQuantity(0,1) = TotalRevenueOpenQuantity
arrDataQuantity(0,2) = TotalRevenueWonQuantity
arrDataQuantity(0,3) = TotalRevenueLostQuantity
arrDataQuantity(0,4) = TotalRevenueAbandonQuantity

Dim strXML, strCategories, strTargetOpen, strOpen, strTagetWon, strWon, strLost, strAbandon, strOpenQuantity, strWonQuantity, strLostQuantity, strAbandonQuantity, i

strXML = "<chart caption='Sales by Month' xAxisName='"&strCategories&"' showLegend ='0' formatNumberScale='6' rotateValues='1' placeValuesInside='1' decimals='0' showValues='0' numberPrefix='$' imageSave='1' imageSaveURL='/NewSite/FusionWidgets/ImageSaving/FusionChartsSave.aspx' labeldisplay='STAGGER' seriesNameInToolTip='0' plotSpacePercent='0'>"

strCategories = "<categories>"

strOpen = "<dataset seriesName='Tot' renderAs='COLUMN' parentYAxis='P' drawAnchors='1'>"
strWon = "<dataset seriesName='Tot' renderAs='COLUMN' parentYAxis='P' drawAnchors='1'>"
strLost = "<dataset seriesName='Tot' renderAs='COLUMN' parentYAxis='P' drawAnchors='1'>"
strAbandon = "<dataset seriesName='Tot' renderAs='COLUMN' parentYAxis='P' drawAnchors='1'>"

strOpenQuantity = "<dataset seriesName='Qty' renderAs='Line' parentYAxis='S' drawAnchors='1'>"
strWonQuantity = "<dataset seriesName='Qty' renderAs='Line' parentYAxis='S' drawAnchors='1'>"
strLostQuantity = "<dataset seriesName='Qty' renderAs='Line' parentYAxis='S' drawAnchors='1'>"
strAbandonQuantity = "<dataset seriesName='Qty' renderAs='Line' parentYAxis='S' drawAnchors='1'>"

For i=0 to UBound(arrData)-1
strCategories = strCategories & "<category name='" & arrData(i,1) & "' />"
strOpen = strOpen & "<set toolText='Total Proposal' showValue='1' value='" & arrData(i,2) & "' />"

strWon = strWon & "<set toolText='Won' showValue='1' value='" & arrData(i,3) & "' />"

strLost = strLost & "<set toolText='Lost' showValue='1' value='" & arrData(i,4) & "' />"

strAbandon = strAbandon & "<set toolText='Abandon' showValue='1' value='" & arrData(i,5) & "' />"

strOpenQuantity = strOpenQuantity & "<set toolText='Total Proposal' showValue='1' value='" & arrDataQuantity(i,1) & "' />"
strWonQuantity = strWonQuantity & "<set toolText='Won' showValue='1' value='" & arrDataQuantity(i,2) & "' />"
strLostQuantity = strLostQuantity & "<set toolText='Lost' showValue='1' value='" & arrDataQuantity(i,3) & "' />"
strAbandonQuantity = strAbandonQuantity & "<set toolText='Abandon' showValue='1' value='" & arrDataQuantity(i,4) & "'/>"

strCategories = strCategories & "</categories>"

strOpen = strOpen & "</dataset>"
strWon = strWon & "</dataset>"
strLost = strLost & "</dataset>"
strAbandon = strAbandon & "</dataset>"

strOpenQuantity = strOpenQuantity & "</dataset>"
strWonQuantity = strWonQuantity & "</dataset>"
strLostQuantity = strLostQuantity & "</dataset>"
strAbandonQuantity = strAbandonQuantity & "</dataset>"

strTagetWon = "<trendlines>"
strTagetWon =strTagetWon & "<line startValue='" & SalesWonValue & "' color='FF0000' displayValue='Sales Target $" & SalesWonValue & "' showOnTop='0' thickness='1' isTrendZone='0' valueOnRight='1' />"
strTagetWon = strTagetWon & "</trendlines>"

strXML = strXML &"<styles>"

strXML = strXML & "<definition>"
strXML = strXML & "<style name='CanvasAnim' type='animation' param='_xScale' start='0' duration='1' />"
strXML = strXML &"</definition>"

strXML = strXML & "<application>"
strXML = strXML & "<apply toObject='Canvas' styles='CanvasAnim' />"
strXML = strXML & "</application>"

strXML = strXML &"</styles>"
strXML = strXML & strCategories & strOpen & strTagetWon & strWon & strLost & strAbandon& strOpenQuantity & strWonQuantity & strLostQuantity & strAbandonQuantity &"</chart>"

Call renderChart("/NewSite/FusionCharts/MSColumn3DLineDY.swf", "", strXML, "productSales", 400, 300, false, false)

My problem is join the same color.... The Columns area ok but the line dosen't work, I can see in the graph only the value but non in the right position, how can I anchor togheter two dataset?

Have a good day!

Save graph as image using ASP?

jojo — Mon, 25 Feb 2008 06:05:43 GMT

Hi
I am creating a site for a client whereby they want to display charts and save the charts to use elsewhere and FusionCharts looks to be perfect. My only issue is the saving of the graph into an image - has anyone had any success with this? I want to know this will work before committing to buy.

I have found a component that will save images through ASP - ASPimage (http://www.serverobjects.com/comp/Aspimage.htm), and this looks like it might work. If anyone else has used this and got it to work then could you post an example please? Any other suggestions would be welcome.

Many thanks

default x and y values after submit in Drag-Node chart

assaf_wr2000 — Mon, 02 Jun 2008 10:24:08 GMT

Hi all.

After submit, I found that the new nodes are getting default x and y values (0,100 in my case) instead of where the user initialized the node.

For example, after the user created new node named: '111' in the middle of the drag-node chart, I took the new xml with C# function: Request["strXML"], and I found the new relevant set, where the X and Y set to 0 and 100:

Any suggestions?

Assaf

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.

Send chart by mail

Raiden — Thu, 08 May 2008 09:53:58 GMT

Hi,

I try to send by mail a rapport with some charts in it.

I use the ImageSavin in AS.NET but i must do a right click to save the image on the server but i would try to push only on button and generate a html page with in the charts in an image. Is that possible?

ps: I'm sorry for my English, it's bad:ermm:
I don't know if it's understandable.

Javascript Method - Referencing Charts?

etm — Wed, 16 Apr 2008 13:44:41 GMT

I'm trying to use some code using your javascript method.

var chart1 = new FusionCharts(""

My question is why do you have to use relative addressing with the function call?

Steps taken:
- created virtual directory under main root web called Fusion charts. Beneath that folder I placed a folder called SWFile.

Attempted to create web reference.

I've tried creating dynamically:

http://<web root name>/FusionCharts/SWFile/<chart swf file>.swf

That did not work.

I then tried creating an application wide variable for the root web server map path and adding Fusion Charts\SWfile\

i.e.:

c:\<root web directory>\FusionCharts\SWFile\<swfile>.swf

And that did not work. Are their any hints or workarounds to using relative address "../../FusionCharts"

Charts not working when routed via ISA Server

neon — Tue, 19 Feb 2008 20:07:19 GMT

Need some help here. All the charts are working fine on our development server within the intranet but cannot work when deployed on our production server A (via internet & https).

The following is show in debug mode:
INFO: Chart registered with external script. DOM Id of chart is SvcLvlT1
INFO: XML Data provided using dataURL method.
dataURL provided:
Reporting/Process.WebForm.asp?INIT_SERVICE_LEVEL_T1_CHART=200711
dataURL invoked:
Reporting/Process.WebForm.asp?INIT_SERVICE_LEVEL_T1_CHART=200711
ERROR: An error occurred while loading data. Please check your dataURL, by
clicking on the "dataURL invoked" link above, to see if it's returing valid XML data.
Common causes for error are:
- No URL Encoding provided for querystrings in dataURL. If your dataURL contains querystrings as parameters, you'll need to URL Encode the same. e.g., Data.asp?id=101&subId=242 should be Data%2Easp%3Fid%3D101%26subId%3D242
- Different sub-domain of chart .swf and dataURL. Both need to be same owing to sandbox security.
- Network error

I verified, by clicking the above link, that the xml data is downloaded and properly formed.

I did additional troubleshooting by adding our production website url as trusted site on my IE browser and modified the security settings to low for maximum access rights. Still doesn't work. I have tested https access locally for server A and the charts works fine so I reckon secure access is not the cause.

Lastly, I deployed it on another production server B (internet & http) and it worked. [b]The Only difference noted here is that https requests for server A is locally routed via Microsoft ISA Server, http request for server B is routed via a hardware firewall[/b].

Please advise. Thanks a million!!!

Using javascript in an ASP page

garnold — Wed, 19 Mar 2008 16:10:24 GMT

My question is how I would use javascript and these charts in an ASP page? Though I'm writing ASP pages the language that I'm using is JavaScript rather then VBScript. I would have no problem using VBScript but the program that I'm integrating with uses JavaScript for everything including their include files. Mixing the two would really not be fun so is there a FusionChart.asp page that is writen with JavaScript rather then VBScript?

copy and paste fusion charts

Fred — Wed, 13 Jun 2007 10:37:20 GMT

Hello folks,
I am using fusioncharts in my ASP page. The chart displays beautifully on my webpage. But now, i need to find a way to copy the chart directly from the webpage and paste it on power point or any other software. I tried to export the webpage to an image document, but it didnt work. i know i could printScreen the page and paste it, but its too much of a hastle. Any suggestions?
Thank you

count columns of data in access database

UHCARON — Mon, 25 Feb 2008 09:53:29 GMT

Hi,

Oops, I meant counting rows of data. I've got an access database that has 7 columns and over 45,000 rows of data. I'm trying to figure out how to use fusion charts to work like a pivot chart in excel. I think I'd use the data url method.... becuase I want the xml generated from the countif query. I want to count the number of values that meet a particular filter/query. For instance, I want to count the number of sytems that transferred files per month. Then I want to drill down per system for a particular month. Then I want to see the type of file per system transferred per day. Lastly, I would want to see historical monthly views of my systems so I can see trends. My data base has all the necessary columns of data to function as a pivot chart, but now I want to present this on the web. My access database also has all the tables i.e. months, days, systems, types. The guides for this application don't present this kind of info.

Real time chart update

jamonakes — Sat, 22 Dec 2007 09:02:15 GMT

I am trying to do a real time chart update using AJAX+ASP. I havent seen an example where it does what I require, but there is an example found at [url=http://www.fusioncharts.com/LiveDemos.asp?gMenuItemId=4]http://www.fusioncharts.com/LiveDemos.asp?gMenuItemId=4[/url] , FusionCharts + JavaScript (AJAX) Integration which is the closest to what I require. In the example, when "Animate chart while changing data?" is unchecked, everytime any of the product options are unchecked the graph instantly re-renders reflecting the new choices.

My question is, is it possible now, instead of an onUncheck event to trigger the re-rendering of the graph, a real time 'onDataChange' event triggering the re-rendering? For example, if the client is doing some smart polling, or if I am able to present the data to the client-side through other ways, how can I make the chart to re-render everytime it is provided with new data chunks without human intervention? I hope my questions is clear. We bought FusionCharts and Gadgets yesterday so we are pretty new and require it for use before Wednesday. Thank you

how tell FusionChart-XML to read from a txt data source on server

88mph — Mon, 11 Feb 2008 19:29:34 GMT

Hi all,

I am a beginner in using FusionCharts and I would like to have some informations about a problem in uploading data to be plotted on charts.

The situation is this:

1) I' have a web page and in this page there is a form that is used client-side to collect some data.
2) The collected data are stored on a .txt file

The question is:

How can i instruct the FusionCharts XML file to read from this array of data and display them on a real-time chart?

I'll extremely happy if someone tell me how do, or suggest me some JS or something else to do this.

Thanks in advance

subdivide process list

arphanet89 — Thu, 07 Feb 2008 19:30:41 GMT

I have read <processes> tag is intended to group a list of processes elements, each one identified by the <process> tag. I would like to know if is it possible to subdivide one or more <process> element and how to do it.

For example, lets say I have 3 principal processes: Design, Programming an Test, but each of one is divided as follows:

Design has two subprocesses, UML diagram and Entity-Relationship diagram.

Programming has two subprocesses either: Built graphical interfaces and Code the Use-cases

Test has no division.

Thank you in advance,

Any help will be appreciated

P.D: I also know <tasks> tag is intended to link a list of activities, each one identified by <task> tag, to a specific process

Using an array how do I add a trendline.

DaGeezah — Fri, 25 Jan 2008 04:51:40 GMT

Sorry, but I can only seem to find information on how to add a trendline using an XML document, how do I add one to a SingleSeries basic array graph.

Many Thanks

Chart Legend Error When IE7 is Zoomed to a Different %

Smokey — Tue, 08 Jan 2008 14:10:31 GMT

Issue: When IE7 browser is "zoomed" to a different size, either lesser or greater %, several of incremented zooms drop the last item in the legend. See the attached jpeg for an example of the problem... three specific screen captures (grouped together in Attach1) are provided for your reference... one at 100%, another at 125%, and finally one at 200%. Attach2 shows a view of the entire URL.

Thanks, Smokey

----------------------------------------------------------------------------

Attach1 – Three Screen Captures Combined (CaptureCombo.jpeg)

Attach2 - View of entire URL (URL.jpeg)

Conditions:

- Browser: IE7

- Chart in use: MSCombi2D.swf

- Resized Movie (SWF file) to 750 x 230 to eliminate distortion based on screen resolution differences or zoom sizing. Best appearance is when Flash's "ShowAll" rather than "ExactFit" is used.

URL Coding:

…

[code]

var fschart1 = new FusionCharts("Charts/MSCombi2d.swf","fschart1","750","230", "false", "false","FFFFFF","ShowAll");

var JAVAStr1fs = "<%=varChart1 %>"

fschart1.setDataXML(JAVAStr1fs);

fschart1.render("FSChart1");

</script>

[/code]

Fusioncharts and Codecharge

terencef — Thu, 23 Aug 2007 06:56:32 GMT

Hi; thanks to someone's post on this subject, I was able to get the dataXML working with CodeCharge, but the dataURL does not seem to work... my code is listed below

My Chart.html

[code]

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta name="GENERATOR" content="CodeCharge Studio 3.2.0.2">
<meta http-equiv="content-type" content="text/html; charset=windows-1252">
<title>eDashboard</title>
<link rel="stylesheet" type="text/css" href="Styles/ACSezOrder/Style_doctype.css">

<script language="Javascript" src="FusionCharts.js"></script>
</head>
<body>
</body>
</html>

Chart.asp code
============

...
...
'Fusion Chart Code
'Variable to contain dataURL
Dim strDataURL

'Set DataURL with animation property to 1
'NOTE: It's necessary to encode the dataURL if you've added parameters to it
'strDataURL = encodeDataURL("ChartsData.asp?animate=1")
strDataURL = "ChartData.asp"

'Create the chart - Pie 3D Chart with dataURL as strDataURL

Call renderChart("Column3D.swf", strDataURL, "", "stats", 600, 400, false, false)

[/code]

and my ChartData.asp
==================

[code]

<%
dim statsdim rs
dim sqldim cn
dim field1 'Hold data returned
dim field2 'Hold name
dim strXML 'strXML will be used to store the entire XML document generated

'Default.asp has passed us a property animate. We request that.
Dim animateChart

animateChart = Request.QueryString("animate")
'Set default value of 1
if animateChart="" then
animateChart = "1"
end if

'Make db conx
cn = "dns..."
set rs = server.createobject("adodb.recordset")

'Create your SQL here, this was mine
sql = "SELECT NBR_OPEN_INCIDENTS FROM DASHBOARD_VIEW"

'Start XML data
strXML = "<chart caption=' Current OMS Status' subCaption='Dashboard' pieSliceDepth='30' showBorder='0' formatNumberScale='0' numberSuffix=' Tickets' animation='0'>"

'Open db and grab records
rs.open sql, cn
do while not rs.eof
'Write the data line str
XML = strXML & "<set label='Open Incidents' value='20'/>"
'Go to next record
rs.movenext
loop

'Finally, close <chart> element
strXML = strXML & "</chart>"

'Close loop and conx
rs.closeSet
rs = nothing

'Set Proper output content-type
Response.ContentType = "text/xml"

'Just write out the XML data
'NOTE THAT THIS PAGE DOESN'T CONTAIN ANY HTML TAG, WHATSOEVER

Response.Write(strXML)
%>

[/code]

the result can be seen at
http://open.acsatlanta.com/OMS/chart.asp

there is no data showing..

Would appreicate a fresh set of eyes...

Thanks

Gantt chart - works locally but not on web server

superwebs — Thu, 29 Nov 2007 09:44:07 GMT

I am trying to generate a Gantt chart. Everything works on my development server but when I upload I get an error.

Both servers are Windows 2003. I have several other charts (bar, pie etc) working perfectly on the web server.

I'm not sure what I can be doing wrong - any help much appreciated.

My javascript:

[code]
<script language="JavaScript">
var chart1 = new FusionCharts("../Charts/Gantt.swf", "chart1Id", "1000", "600", "1", "1");
chart1.setDataURL("bookings%5Fgantt%2Easp%3Fyear%3D2008%26limit%3D1");
chart1.render("chart1div");
</script>
[/code]

My XML:

[code]
<chart dateFormat='dd/mm/yyyy' ganttPaneDuration='1' ganttPaneDurationUnit='m' palette='2' showShadow='0'><categories><category start="01/01/2008" end="31/12/2008" name="Bookings grid view" /> </categories><categories><category start="01/01/2008" end="31/01/2008" name="Jan" /><category start="01/02/2008" end="29/02/2008" name="Feb" /><category start="01/03/2008" end="31/03/2008" name="Mar" /><category start="01/04/2008" end="30/04/2008" name="Apr" /><category start="01/05/2008" end="31/05/2008" name="May" /><category start="01/06/2008" end="30/06/2008" name="Jun" /><category start="01/07/2008" end="31/07/2008" name="Jul" /><category start="01/08/2008" end="31/08/2008" name="Aug" /><category start="01/09/2008" end="30/09/2008" name="Sep" /><category start="01/10/2008" end="31/10/2008" name="Oct" /><category start="01/11/2008" end="30/11/2008" name="Nov" /><category start="01/12/2008" end="31/12/2008" name="Dec" />

</categories><processes align="left"><process Name="97 - Orroland Lodge" id="97" /></processes><tasks><task name="Christine Prunty" processId="97" start="04/01/2008" end="07/01/2008" taskId="B" borderColor="D85958" color="D85958" link="bookings_detail.asp?bookingID=17220" /><task name="Sharon Ward Giles" processId="97" start="05/01/2008" end="19/01/2008" taskId="B" borderColor="303B7D" color="303B7D" link="bookings_detail.asp?bookingID=16809" /><task name="Building and maintenance" processId="97" start="07/01/2008" end="26/01/2008" taskId="B" borderColor="367D5F" color="367D5F" link="bookings_detail.asp?bookingID=20723" /></tasks></chart>
[/code]

The debug information:

INFO: Chart registered with external script. DOM Id of chart is chart1Id
INFO: XML Data provided using dataURL method.
dataURL provided: bookings_gantt.asp?year=2008&limit=1
dataURL invoked: bookings_gantt.asp?year=2008&limit=1
ERROR: An error occurred while loading data. Please check your dataURL, by clicking on the "dataURL invoked" link above, to see if it's returing valid XML data. Common causes for error are: 
No URL Encoding provided for querystrings in dataURL. If your dataURL contains querystrings as parameters, you'll need to URL Encode the same. e.g., Data.asp?id=101&subId=242 should be Data%2Easp%3Fid%3D101%26subId%3D242
Different sub-domain of chart .swf and dataURL. Both need to be same owing to sandbox security.
Network error

JS Example + DB connection??

Clee — Tue, 13 Nov 2007 02:06:09 GMT

Hi,

Does someone know how to get the following example working with an Access database connection?

http://www.fusioncharts.com/Demos/JS/Index.html

Thanks in advance,

Clee

X-AxisLabels Values

efrenga79 — Thu, 02 Aug 2007 14:34:31 GMT

Hi to all,

how may I rotate the XAxislabels values? in version FusionCharts Presentation Suite

Client Customized, Data-Driven Chart

valerie.harris — Tue, 09 Oct 2007 14:59:57 GMT

The website includes a Javascript-Ajax chart the enables customization on the client level, called "FusionCharts + Javascript (AJAX) Integration". Are reports a database driven. I wanted to know if there was someway to combine the functionality of the aforementioned chart with a chart based on info from a database and selections from a HTML FORM?

Basic question about y axis scale

Clay Canvas — Tue, 18 Sep 2007 22:08:34 GMT

I've been trying your free version to get a taste today ... I really like how easy it is to use .asp. I plan on downloading the V3 trial version. I was wondering how to go about adjusting the scale on the y axis. Sometimes data labels end up too close to the top line of the chart and begin to be difficult to read. I was wondering how adjustments to increase the max number on the scale is made...

Thanks in advance!:)

Data Drill

Felton — Sat, 08 Sep 2007 06:47:53 GMT

Is it possible to drill down to see live data? For example, with a pie chart (or any chart for that matter) of sales statistics for various regions, I would like to drill down to see a list names and products, or any data I choose, that make up the region.

Thanks

help me please

thos123 — Sat, 01 Sep 2007 03:13:56 GMT

how to display seriesName '%'

I try to do this <dataset seriesName='%' color='AFD8F8' showValues='0'>"

it can not display

please help me thank you

Chart question

Marcus Weidenfeller — Wed, 15 Aug 2007 05:04:43 GMT

Hi - I'm using currently the trial version of your fusionchart v3. I have problems to create a line-chart with fixed y-axis values. The y-axis should display the possible answers of a poll. The x-axis should display the dates, the user have vote for this poll. So, on the chart I can see, how the User changed his opinion in the course of time.

Here an example:
(y-axis)
answer 1 x x
answer 2 x
answer 3 x
answer 4
(x-axis) 8/10/07 8/11/07 8/12/07 8/13/07

The x shown as line-chart
Since I have more polls, the line-chart values of the x- and y-axis will create dynamically by my programm.

Obviously, I can't create this kind of chart only with the declaration of the "<set label='12.08.2007' value='answer 1' />". Can you give me some hints, how it is possible to solve my chart-problem?

Thanks a lot!

Best regards,
Marcus Weidenfeller

help!!!!

hifen — Thu, 09 Aug 2007 14:44:11 GMT

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'renderChart'

/nexweb/nany3.asp, line 140

what's that mean? my code is below:

Dim cost1,cost2
cost1 = Int(Request.querystring("edemand"))
cost2 = Int(Request.querystring("eprice"))

Dim strXML

strXML = "<chart caption='Sales by Product Category' subCaption='For this week' showPercentValues='1' pieSliceDepth='30' showBorder='1'>"
strXML = strXML & "<set label='Soups' value='" & cost1 & "' />"
strXML = strXML & "<set label='Salads' value='" & cost2 & "' />"
strXML = strXML & "</chart>"

Call renderChart("../nexweb/FusionCharts/Pie3D.swf", "", strXML, "Sales", 500, 300, false, false)

AJAX help!

ei11067 — Fri, 13 Jul 2007 20:19:41 GMT

Hi, sorry for my english :D

My question:

I'm using V3 charts and I have a page with 1 chart, all I need is refresh ONLY the chart in my page every 5 minutes, for that I know that I need ajax,

what I need to do?

help?

thanks in advance ;)

How do I Combine the grid with a chart in ASP

paul_s — Fri, 06 Jul 2007 07:14:51 GMT

Hi,

can anyone tell me how to Combine the grid with a chart in classic ASP.

Thanks

Paul

having problem with hebrew

shlomist100 — Mon, 28 May 2007 04:35:30 GMT

Hi,

I Can't see Hebrew characters in the chart.

ThanX,

LABELS

cchuquillanqui — Tue, 29 May 2007 19:02:36 GMT

Please I need that they help me, my consultation is is possible in the end to be put fixed labels in the graph of linear type when dot the graph.

I wait for the quick news. :(
Carlos

Error in loading data

djjwp — Thu, 03 May 2007 21:47:00 GMT

I am using two pages to grab and display the data. The first page is launched and it then pulls the data from the second "data" page. I'm using the MSColumn3D.swf chart.

[code]dim stats
dim rs
dim sql
dim cn

dim rs1
dim sql1
dim cn1

dim field1 'Hold data returned
'dim field2 'Hold name
dim strXML 'strXML will be used to store the entire XML document generated

'Default.asp has passed us a property animate. We request that.
Dim animateChart
animateChart = Request.QueryString("animate")

'Set default value of 1
if animateChart="" then
animateChart = "1"
end if

'Make db conx
cn = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=serverip;DATABASE=netops;USER=root;PASSWORD=password;OPTION=3"
set rs = server.createobject("adodb.recordset")
sql = "SELECT Count(Ticket) as field0 FROM Tkt_tickets WHERE YEAR(ResolvedTime) = 2006 GROUP BY Year(ResolvedTime), Month(ResolvedTime)"

cn1 = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=serverip;DATABASE=netops;USER=root;PASSWORD=password;OPTION=3"
set rs1 = server.createobject("adodb.recordset")
sql1 = "SELECT Count(Ticket) as field1 FROM Tkt_tickets WHERE YEAR(ResolvedTime) = 2007 GROUP BY Year(ResolvedTime), Month(ResolvedTime)"

'Start XML data
strXML = "<chart caption='Tickets Worked Results 2006 v 2007' xAxisName='Month' yAxisName='Revenue' showValues='0' numberPrefix='$'>

strXML = strXML & "<categories>"
strXML = strXML & "<category label='Jan' />"
strXML = strXML & "<category label='Feb' />"
strXML = strXML & "<category label='Mar' />"
strXML = strXML & "<category label='Apr' />"
strXML = strXML & "<category label='May' />"
strXML = strXML & "<category label='Jun' />"
strXML = strXML & "<category label='Jul' />"
strXML = strXML & "<category label='Aug' />"
strXML = strXML & "<category label='Sep' />"
strXML = strXML & "<category label='Oct' />"
strXML = strXML & "<category label='Nov' />"
strXML = strXML & "<category label='Dec' />"
strXML = strXML & "</categories>"

'Open db and grab 2006 records
strXML = strXML & "<dataset seriesName='2006' color='FF9601'>"
rs.open sql, cn
do while not rs.eof

'Write the data line
strXML = strXML & "<set value='" & rs("field0") & "'/>"

'Go to next record
rs.movenext
loop

strXML = strXML & "</dataset>"

'Open db and grab 2007 records
strXML = strXML & "<dataset seriesName='2007' color='0000C0'>"
rs1.open sql1, cn1
do while not rs1.eof

'Write the data line
strXML = strXML & "<set value='" & rs1("field1") & "'/>"

'Go to next record
rs1.movenext
loop

strXML = strXML & "</dataset>"

strXML = strXML & "<trendlines>"
strXML = strXML & "<line startValue='26000' color='91C728' displayValue='Target' showOnTop='1'/>"
strXML = strXML & "</trendlines>"

'Finally, close <chart> element
strXML = strXML & "</chart>"

'Close loops and conx
rs.close
Set rs = nothing
rs1.close
Set rs1 = nothing

'Set Proper output content-type
Response.ContentType = "text/xml"

'Just write out the XML data
'NOTE THAT THIS PAGE DOESN'T CONTAIN ANY HTML TAG, WHATSOEVER
Response.Write(strXML)
[/code]

This is in the first page.

[code]'Variable to contain dataURL
Dim strDataURL

'Set DataURL with animation property to 1
'NOTE: It's necessary to encode the dataURL if you've added parameters to it
strDataURL = "TktByMonthData.asp"

'Create the chart - Pie 3D Chart with dataURL as strDataURL
Call renderChart("Includes/ChartsSWF/MSColumn3D.swf", strDataURL, "", "stats", 600, 400, false, false)[/code]

Any help would be appreciated.

CodeCharge Studio

djjwp — Wed, 07 Mar 2007 22:02:59 GMT

I will be purchasing Fusion Charts and will need to get it working within CCS projects. I'm looking for anyone who has done this before and can offer any type of "how to". :w00t:

Thanks

Don