tcraigen

On linux with Multi Charts, no label color shows up when viewing graphs, even the working samples in the docs don't show labels color. On the mac, it shows as a Filled Box, with the color of the corresponding bar. On windows, it shows a box with Outlines of the color, rather than being a filled box.

I was also able to change the font to Arial, this is a work around till we can the updated version of the charts.

After a lot of debugging, I have found that FusionCharts needs some strings double escaped. I am not sure if this is Javascript and/or Browser bug and/or Fusion Flash implementation. As string like this: http://helpdesk/Search/Chart.html?Order=DESC&Query=+Owner+ %3D+%27Nobody%27+AND+%28+Status+%3D+%27new%27+OR+ Status+%3D+%27open%27%29+AND+Queue+%3D+%27TSE%27& Rows=20&OrderBy=Created&Format=%27%3Ca+href%3D%22%2FTicket %2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E% 2FTITLE%3A%23%27%2C+%27%3Ca+href%3D%22%2FTicket% 2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa %3E%2FTITLE%3ASubject%27%2C+QueueName%2C+ExtendedStatus %2C+CreatedRelative%2C+%27%3CA+HREF%3D%22%2FTicket% 2FDisplay.html%3FAction%3DTake%26id%3D__id__%22%3ETake% 3C%2Fa%3E%2FTITLE%3A%26nbsp%3B%27+&PrimaryGroupBy= Status&ChartStyle=bar Needs to be escaped two times in the process of passing the string to FustionCharts. function draw_chart(type,webpath,query,w,h,debug) { webpath = "http://helpdesk/Search/Chart.html?"; query="Order=DESC&Query=+Owner+%3D+%27Nobody%27+AND+%28+Status+%3D+%27new%27+OR+Status+%3D+%27open%27%29+AND+Queue+%3D+%27TSE%27&Rows=20&OrderBy=Created&Format=%27%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%2FTITLE%3A%23%27%2C+%27%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%2FTITLE%3ASubject%27%2C+QueueName%2C+ExtendedStatus%2C+CreatedRelative%2C+%27%3CA+HREF%3D%22%2FTicket%2FDisplay.html%3FAction%3DTake%26id%3D__id__%22%3ETake%3C%2Fa%3E%2FTITLE%3A%26nbsp%3B%27+&PrimaryGroupBy=Status&ChartStyle=bar "; var width = 800, height = 560; //set default if(w != undefined) { width = w; //overide } if(h != undefined) { height = h; } var chart1 = new FusionCharts(type, "RTDynamicChart", width, height, debug, "0"); chart1.setDataURL( webpath + escape(escape(query)) ); chart1.render("fusion_chart"); }

Here is what works for all of our charts: Info: Chart loaded and initialized. Initial Width: 800 Initial Height: 560 Scale Mode: noScale Debug Mode: Yes Application Message Language: EN Version: 3.0.3 Chart Type: Single Series 3D Column Chart Chart Objects: BACKGROUND CANVAS CAPTION SUBCAPTION YAXISNAME XAXISNAME DIVLINES YAXISVALUES DATALABELS DATAVALUES TRENDLINES TRENDVALUES DATAPLOT TOOLTIP VLINES INFO: XML Data provided using dataURL method. dataURL provided: /Search/ChartFusion.xml?Rows%3D50%26SecondaryGroupBy%3D%26PrimaryGroupBy%3DCreatedAnnually%26Format%3D%27%2520%2520%2520%253Cb%253E%253Ca%2520href%253D%2522%252FTicket%252FDisplay.html%253Fid%253D__id__%2522%253E__id__%253C%252Fa%253E%253C%252Fb%253E%252FTITLE%253A dataURL invoked:

Here is the debug window when I only escape once: Info: Chart loaded and initialized. Initial Width: 800 Initial Height: 560 Scale Mode: noScale Debug Mode: Yes Application Message Language: EN Version: 3.0.3 Chart Type: Multi Series 3D Column Chart Chart Objects: BACKGROUND CANVAS CAPTION SUBCAPTION YAXISNAME XAXISNAME DIVLINES YAXISVALUES DATALABELS DATAVALUES TRENDLINES TRENDVALUES DATAPLOT TOOLTIP VLINES LEGEND INFO: XML Data provided using dataURL method. dataURL provided: /Search/ChartFusion.xml?Rows=50&SecondaryGroupBy=ResolvedMonthly&PrimaryGroupBy=CreatedMonthly&Format=%20%20%20%3Cb%3E%3Ca%20href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A dataURL invoked:

Found it, its in the debug... 3.0.3 is what we are on, I will see if we can upgrade.

I will check with the sysadmins if this is installed, how do I check my current version?

Not sure why the content would make any difference, the string when passing it to the Javascript is the problem. [text] [/text] I can't get the text for the XML to printout, do we have a tag available like verbatim or code in the Forumns? Here is my Javascript: function draw_chart(type,webpath,query,w,h,debug) { var width = 800, height = 560; try { if(w != undefined) { width = w; } if(h != undefined) { height = h; } //var chart1 = new FusionCharts("/NoAuth/charts/Column3D.swf", "RTDynamicChart", width, height, debug, "0"); var chart1 = new FusionCharts(type, "RTDynamicChart", width, height, debug, "0"); chart1.setDataURL( webpath + escape(escape(query)) ); chart1.render("fusion_chart"); } catch(e) { alert("ERROR: " + e); } }

We are doing some complicated and confidential charts that get dynamically sized based on the content. Will this feature have the ability to position in future releases? As we would defiantly want the ability to at least: Center - Top/Middle/Bottom Left - Top/Middle/Bottom Right - Top/Middle/Bottom Or give an x/y position.

I have posted the solution to complected string like the example above. Escaping the string once gives invalid data error, something to point of try escaping the string.

http://hostname/Search/Chart.html?Order=DESC%7CASC%7CASC%7CASC&Query=+%27CF.%7BProduction%7D%27+LIKE+%27ADOG%27&Rows=50&OrderBy=id%7C%7C%7C&Format=%27+++%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23%27%2C%0D%0A%27%3Cb%3E%3Ca+href%3D%22%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject%27%2C%0D%0A%27__Status__%27%2C%0D%0A%27__QueueName__%27%2C%0D%0A%27__OwnerName__%27%2C%0D%0A%27__Priority__%27%2C%0D%0A%27__NEWLINE__%27%2C%0D%0A%27%27%2C%0D%0A%27%3Csmall%3E__Requestors__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E%27%2C%0D%0A%27%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E%27&PrimaryGroupBy=Status&ChartStyle=bar Here is the XML data: The long string above generates an XML output no problem, but passing it to the setDataURL function seems to not work. Other similar strings work fine. This is a custom query that works: http://coffee/Search/Chart.html?Order=DESC&Query=Queue+%3D+%27TSE%27+AND+%28Status+%3D+%27open%27+OR+Status+%3D+%27new%27+OR+Status+%3D+%27stalled%27%29&Rows=50&OrderBy=id&Format=&PrimaryGroupBy=Status&ChartStyle=bar Thanks for any help...

I found a work around, it looks to be a problem with the backend URL that is being generated for the SQL query.