Pzr

Hello, Would someone please explain to me how to apply this to an DB fed column2d ? Im enabling the user to search for data between dates for a drill down chart, and when greater daterange is picked, the column2d gets too much data and get all cloddy (hard to pick out an bar). I would love to add the use of an scroll function after the y-axis. Can anyone please explain a bit further how to achieve this? Thanks / Emanuel *EDIT* Needed to think some, it's working now... .-)

Question. Is it possible to just update from V.3.11 to V.3.2 if you've been using FusionCharts.php?

Hello, Guess i'm better off showing you some of the code: This is now the result I get into the chart: Info: Chart loaded and initialized. Initial Width: 899 Initial Height: 300 Scale Mode: noScale Debug Mode: Yes Application Message Language: EN Version: 3.1.1 Chart Type: Multi Series 2D Line Chart Chart Objects: BACKGROUND CANVAS CAPTION SUBCAPTION YAXISNAME XAXISNAME DIVLINES VDIVLINES YAXISVALUES HGRID VGRID DATALABELS DATAVALUES TRENDLINES TRENDVALUES DATAPLOT ANCHORS TOOLTIP VLINES LEGEND VLINELABELS INFO: Chart registered with external script. DOM Id of chart is DATADetailed INFO: XML Data provided using dataXML method. XML Data: <chart /> No Data to Display: No data was found in the XML data document provided. Possible cases can be: There isn't any data generated by your system. If your system generates data based on parameters passed to it using dataURL, please make sure dataURL is URL Encoded. You might be using a Single Series Chart .swf file instead of Multi-series .swf file and providing multi-series data or vice-versa. INFO: setDataURL method invoked from external script. INFO: XML Data provided using dataURL method. dataURL provided: new_deal5_test.php%3Fustype%3DDT%20THORAX%26labid%3DSUASRTGCT%25%26labname%3Dalla%26datefrom%3D20100106%26dateto%3D20100806%26startage%3D0%26endage%3D100%26starage%3D2010%25%26enage%3D1910%25%26sex%3Dalla%26QUERY%3Dlike dataURL invoked: new_deal5_test.php?ustype=DT THORAX&labid=SUASRTGCT%&labname=alla&datefrom=20100106&dateto=20100806&startage=0&endage=100&starage=2010%&enage=1910%&sex=alla&QUERY=like&FCTime=10575 XML Data: <chart outCnvBaseFont="Trebuchet MS" labelDisplay="Rotate" labelStep="4" slantLabels="1" anchorAlpha="0" caption="CT-lab:alla Us-typ:DT THORAX K

Hello, I have an MSLine chart that shows three results at the same time. I would now try to add the functionality to have the user choose witch one to show (or all). I have earlier had the user to choose a separate "product" or "all products" but would now like to integrate this to the last chart. I'm using PHP and mySQL for the dataretrieval. I've looked into your fusioncharts and javascript example but cant manage to get it to work. (The one where you have put your data in an array for 4 products.) Would you mind try explain a little further how I might be able to proceed? *EDIT* I have two files: 1. user.php Contains 2 charts and javascript First chart is an 3Dpie that the user clicks a slice to retrieve data for the second chart. This data get's URLencoded and then sent to retrieve.php. It also contains dropdown list for all or one of the products. 2.retrieve.php Contains PHP and sql-query with variables sent with URLencode, earlier I just echoed out the $strXML, but now I want to store it in the client somehow and depending on checkboxes the user choose to use, show only chosen data. Regards Emanuel

hello, would like to know what I should use if I want to show 3 (or more) charts in the same window? As for now i'm using dataURL method and have followed the example in the manual. Now I would like to add another chart based upon what the user clicks in the second chart. Is this possible? Is there any example of this somewhere? I've tried to set another DOM id and another var strURL. ex: function updateChart(factoryIndex){ var strURL = "FactoryData.php?"+ factoryIndex; strURL = escape(strURL); var chartObj = getChartFromId("FactoryDetailed"); chartObj.setDataURL(strURL); } function updateChart(factoryIndex2){ var strURL = "FactoryData2.php?"+ factoryIndex2; strURL = escape(strURL); var chartObj = getChartFromId("FactoryDetailed2"); chartObj.setDataURL(strURL); } But with no sucsess. Any help appreciated Regards /E

Problem solved, was sloppy in copying code from other page. Missed out an variable $query should have been $strQuery :w00t: works like a charm now!

Hello, I already have the licensed version. (V3) This is how my setup looks like; headpage.php containing: 1'st chart db query and xml. URLencode to 2'nd chart process page 2nd.php via updateChart It also contains 3 renderchartHTML() (1'st chart, 2'nd chart DOM id 'Detailed' (updateChart), 3'rd chart DOM id 'MoreDetailed' (updateChart2). 2nd.php containing : 2'nd chart db query and xml. URLencode to 3'rd chart process page 3rd.php Updates data to 3'rdchart via updateChart2. 3rd.php containing 3'rd chart db query and xml. Can above be correct? Everything works fin until pressing 2'nd chart, then I get this Error : 3rd.phpSOP=1.3.12.2.1107.5.1.4.60301.30000009110206455401500000022&totdlp=127&FCTime=726705 XML Data: Query was empty No Data to Display: No data was found in the XML data document provided. Possible cases can be: There isn't any data generated by your system. If your system generates data based on parameters passed to it using dataURL, please make sure dataURL is URL Encoded. You might be using a Single Series Chart .swf file instead of Multi-series .swf file and providing multi-series data or vice-versa. I've checked that the variables passed using URLencode are properly recieved at the 3rd.php (I did an test insert ino the db with the SQL-query later used for the xml) and there everything looks fine. What could be the problem here? I've tred to check if i've made any error in the "value" and "label" field.. But to no succsess. It should work... /Emanuel

Hi folks, I've been looking at the examples fpr PHP and "Combining FusionCharts, PHP & Javascript (dataURL/dataXML) method's" but don't seem to make it work. The problem is I have more than 1 (one) variable I want to pass to the detailed.php that makes the second query. Would anyone please give me an example with more than one variable!? :-) (Eg. $labid, $startdate, $enddate and $type) /Emanuel

Update: I've managed to get thru a dataURL, but dont understand why It stops here. Is there a urlencode error with my variables? /E UPDATE! problem solved. did too much changes at same time! :-)

done some progress (i think), I've come so far that I get this in the second chart: But then nothing. The change made to make this work this far, was when putting ' around the variables to be urlencoded: Might there be something wrong with the urlencoded data anyway?

Hello again, When putting in " at both ends of the variable dataURL I get an error... And with " at both ends as in there is an XML-error generated.Do you have any other suggestions for me? :-) Much appreciated! /Emanuel

Hello, Added the unescapeLinks '0', and now there seem to some action atleast. :-) Here's the debuginfo from second chart: Any idea, it seems my URLencoded data is not interpred correct. /Emanuel

ok, tried to urlencode the variables: $dataURL = urlencode("ustype=$ustype&labid=$labid&labname=$labname&datefrom=$datefrom&dateto=$dateto"); $strXML .= "<set label='$ustype' value='$antal' link='javaScript:updateChart(". $dataURL .")'/>"; (correct?) And then in the java: function updateChart($dataURL){ //DataURL for the chart var strURL = "Detailed_data.php?"+$dataURL; It's a no-no. /Emanuel

Hello, function updateChart($ustype,$labid,$labname,$datefrom,$dateto){ //DataURL for the chart var strURL = "Detailed_data.php?ustype=" + $ustype + "&labid=" + $labid + "&labname" + $labname + "&datefrom" + $datefrom + "&dateto" + $dateto; And then: $strXML .= "<set label='$ustype' value='$antal' link='javaScript:updateChart('+$ustype+','+$labid+','+$labname+','+$datefrom+','+$dateto+')'/>"; Is there much wrong in my code??? :-) When leaving out the 'link=...' everything works fine with the first of my charts. But when having 'link=...' in the $strXML I get an "Invalid XML data". With debug: Info: Chart loaded and initialized. Initial Width: 500 Initial Height: 300 Scale Mode: noScale Debug Mode: Yes Application Message Language: EN Version: 3.1.1 Chart Type: 2D Doughnut Chart Chart Objects: BACKGROUND CANVAS CAPTION SUBCAPTION DATALABELS DATAPLOT TOOLTIP INFO: Chart registered with external script. However, the DOM Id of chart has not been defined. You need to define it if you want to interact with the chart using external scripting. INFO: XML Data provided using dataXML method. ERROR: Invalid XML encountered. An XML element is malformed. Click the above "dataURL Invoked" link to see the XML in browser Or check the XML data provided. /Emanuel

Hello Rahul, I've dropped the phpclass-trail... :-) I've made an new question in this forum instead regarding URL and XML methods of transfering variables and data to a second chart in same page. Have trouble understanding how to make more than one variable (as in your example) go to Detailed.php /Emanuel

Hello folks. After installed demo of V3 and being able to see performance of FusionCharts I finally got me a licenced version. The strange thing is with the 'rotation' function in Pie3D, Doughnut3D, Doughnut2D. When I changed out the demofiles to the licensed downloaded ones, I suddenly had an performanceissue with just the 'rotation' function. I've made 2 exactly the same webstructures, one with demo V3 and the other with licensed. The licensed is not smooth in the animation (rotate) , but the demo V3 works like a charm. I hope anyone can help me with this one, since I want to show of all neat features. /Regards Emanuel

Hello, Iv'e already been adviced by You via mail. (THANKS!!) There was a prblem using the renderChart() so I now use renderChartHTML() /Emanuel

*BUMP!* I just want to know if i'm doing something wrong with the install? Or if i've found a bug? Regards Emanuel

Hello, Ofcourse I have marked the "rotation" option, both in my "demo" and in my "licenced" The thing is the licenced webpage is very slow in the animation. (And that is an exact copy of the "demo" one witch works fine.) I have made 2 clean webfolders, my PHP-coded webpages inside and then only licensed resp demo in each. (The same code inside, only difference is FusionChartsV3.swf/FusionCharts.php/FusionCharts.js demo in one and FusionChartsV3.swf/FusionCharts.php/FusionCharts.js licenced in the other.) Why the performance issue? Have I done something wrong? I have the two pages up beside one and other, the one with "demo" V3 works fine (smooth movement in rotation), and the "licenced" one does not have a smooth movement in animation on rotation. Slicing and going from 3D to 2D and back works the same in the two. Please advice. /Emanuel

Hello Charles (And everybody else) I have set up a chart (Doughnut3D) to show as in Charle's example. And have a few questions... 1.) I dont seem to be able to show the different slices names? (Tried to set showNames=1 but to no use.) And to make it more complicated... 2.) I want to be able to press one of the slices (dataURL) and load a second chart from what I pressed (New SQL query with new variables). Is this possible with PHP Class? (I have the above set up now on two separate *.php pages, and let the variables I create pass to the second page with urlencode. But it would be sooo neat to have it all in same page...) :-) 3.) Does anyone know if there's a way to pass variables to mySQL other than like inserts into for e.g a temptable? (Maby completely wrong forum, but I think the knowledge is here.) regards Emanuel