Some sqlCharts changes

Here's a quick fix for those who are using sqlReports 5.3.1 and having an issue with sqlCharts Lite when Flash is enabled.  Thanks to Dustin L for bringing it to my attention and for testing out a fix.  This does not affect the full version of sqlCharts that's part of the site subscription, because I actually had the fix on that page but didn't think to include it on the Lite one.

Look for this in the coding on the sqlReports5/params.html page in both the admin and teacher versions: (it'll be toward the bottom of the page):

      if  ( FusionCharts( "myChartId" ) )  FusionCharts( "myChartId" ).dispose();

and add FusionCharts.setCurrentRenderer('javascript'); in between so it looks like this instead:

      if  ( FusionCharts( "myChartId" ) )  FusionCharts( "myChartId" ).dispose();

Without that line, the charts won't show if you have Flash enabled.  Dustin also pointed out that the charts weren't showing decimal places, so you can remove this piece of code a little bit further down the page:


Once you remove it, then decimal places will start showing on the charts.  If you want to round to a certain number of decimal places, you'll need to do that within the sql itself.

Given all that, I've decided to release sqlReports 5.4 this week and put the full version of sqlCharts in the free version as well.  I'll make one of the mulit-series charts on the site available for free as well so people can see the power of the full version.  I've decided to make it part of the free version to make one less difference in coding to have to worry about, plus allow everyone to take full advantage of the charting possibilities with sqlReports.