Arindam

hi, Could you please check your code that builds the XML in PHP. The code needs major debugging. The code is fetching some unnecessary data using lots of query and the XML generation is getting complicated. You might not need any other SQL query inside while loop of the primary Query. Could you please follow the code attached? Please try running it first and then modify as per your needs later. FusionCharts has no direct relation with SQL Query and records fetched. It only accepts the XML that your code generates and renders the chart. So, it test.php.txt

hi, I am afraid it is not possible as of now

hi, Please provide us your environtment i.e (asp .net etc.). also provide us your XML recordset code.

Hi, Could you please let us know the flash player version you are using?

Hi, Could You please provide us XML that you are using? if your xml is very long then you can use dataURL method.

Hi, Could you please see this: yAxisMinValue Number This attribute helps you explicitly set the lower limit of the chart. If you don't specify this value, it is automatically calculated by FusionCharts based on the data provided by you. yAxisMaxValue Number This attribute helps you explicitly set the upper limit of the chart. If you don't specify this value, it is automatically calculated by FusionCharts based on the data provided by you.

hi, Could you please try this code. test.php.txt

try this post http://www.fusioncharts.com/forum/Topic7792-17-1.aspx

hi, could you please use this type of sql query For MsAccess Database only SELECT Quantity, format(datepro,"dd/MM/yyyy") AS mydate FROM Factory_Output; here sql query format the date to dd/mm/yyyy format. you can use custom format also, like -> dd-mm-yyyy, mm/dd, yyyy/mm/dd etc.

Hi, Could you please try with new FusionCharts.dll. Please see the attachment. FusionCharts.zip

Hi, Could you please try with encoded dataURL. Dim strDataURL ' URL encode strDataURL = Server.URLEncode("Data/CreateData.asp?Cgame=" & Request("Game") & "&Ctype=" & Request("Type")) Call renderChart("FCF_Line.swf", strDataURL, "", "ChartID1", 600, 350)

Please tell me what type of database are you using? SQL Server or MY SQL?

Hi When you retrieve data from SQL Query that time you can format the date value or when you plot in chart that time you have to manually format the date value.

Hi There is a problem on your xml. one extra ( ' ) there. Please correct it and again run it <chart caption='Sales Per Category For 2008' palette='1' animation='1' decimals='2' baseFontSize='11' isSliced='0' useSameSlantAngle='0' isHollow='0' labelDistance='10'> <set label='Total Sales' value='85139'/> <set label='PHARMACY MEDICATION' value='99' isSliced='1'/> <set label='MM ITEMS' value='973' isSliced='1'/> <set label='OPD-CONSULT' value='290' isSliced='1'/> <set label='IPD ROOM CHARGES' value='16111' isSliced='1'/> <set label='IPD-CONSULT' value='53892' isSliced='1'/> <set label='IPD NURSING CARE' value='4495' isSliced='1'/> <set label='LABORATORY TESTS' value='1444' isSliced='1'/> <set label='MISCELLANEOUS FEES' value='829' isSliced='1'/> <set label='XRAY SERVICES' value='405' isSliced='1'/> <set label='COMBO' value='6141' isSliced='1'/>' <set label='PROCEDURE SERVICES ' value='460' isSliced='1'/> <styles><definition><style type='font' name='CaptionFont' color='666666' size='15' /> <style type='font' name='SubCaptionFont' bold='0' /></definition><application> <apply toObject='caption' styles='CaptionFont' /><apply toObject='SubCaption' styles='SubCaptionFont' /></application></styles></chart>

Please use %26apos;

Could you please use ';' separator. Please follow the code string link = "javascript:updateChart(%26apos;" + oRs.ReadData["STRAIGHT"].ToString() + "%26apos; ) ; updateStats(%26apos;" + oRs.ReadData["STRAIGHT"].ToString() + "%26apos; ) ;";

modal pop-up C# Code ModalPopUP_C#_Code.zip

hi, could you please run Year_sales_data.cfm?year=1994 in your web browser, just to ensure that your xml is properly formatted. If xml data is ok then run it with in Chart as dataURL.

hi, Could you please see my previous Post Attachments? I already modified some code over there.

Please right click on attachment and after that Save target as and save it

I thing may be your Resource path not correct. Can you add this Resource Reference in your AssemblyInfo.cs file? Like this way? [assembly: WebResource("FusionChartsGen.resources.chartsFree.FCF_Area2D.swf", "application/x-shockwave-flash")] My project directory and root is FusionChartsGen. My FC swf location is resources/chartsFree so my full path is FusionChartsGen.resources.chartsFree.FCF_Area2D.swf . so I listed all with in AssemblyInfo.cs that way. [assembly: WebResource("FusionChartsGen.resources.chartsFree.FCF_Area2D.swf", "application/x-shockwave-flash")] Calling swf file ==================== // Sets SWF(FusionCharts) Path SWFPath = Page.ClientScript.GetWebResourceUrl(GetType(), "FusionChartsGen.resources.chartsFree.FCF_Area2D.swf"); Render Charts ================= chartDisplay.Text = FusionCharts.RenderChart(SWFPath, "", ConvertDataSetIntoXML, "CFNChart", ChartWidth.ToString, ChartHeight.ToString, False, False) Please follow it.

yes this is Possible. are you Render swf file?

Hi, Need to debug your program. First of all please check whether SQL Query working or not. Please check SQL Query with in Access Data base. Will you send me table structure? Please tell me how you want to show your data with in chart? With out table structure I am unable to do debug. Also you can build your logic this way. see attachment MSAccess_php.txt

hi, Please tell me first, are you using Ajax environment? RenderChart will not work in Ajax environment so please use RenderChartHTML. If you do not use ajax environment then both RenderChart and RenderChartHTML will work. For RenderChart you should include FusionCharts.js script. <script language="javascript" type="text/javascript" src="[relative path]/FusionCharts.js" ></script>

Hi, could youe please use urlencode for dataURL $dataURL=urlencode("data.php?Year=1932&FCTime=129");