sqlReports 5.5.2 and 5.4.3 Are Now Available

A couple weeks ago I redid the params page of sqlReports to fix an issue with the Open In New Window feature.  An issue was found today by a user (Thanks Peter N!) relating to that fix.  Anyone on a version of 5.4.x or 5.5.x, or who manually applied the change mentioned in this blog post, should upgrade to either 5.4.3 or 5.5.2 right away.  Both versions work fine with as they build upon 5.4.2 and 5.5.1.  I had to add quite a few new lines to the params.html page, so one should upgrade because there is no quick and easy workaround.   If you're using the Saved Params add-on, be sure to load the new params files from it's update.  Anyone on a version prior to 5.4 should be aware of the Open In New Window issue and upgrade at some point.

To be more specific about the issue discovered today, I found it was related to the translation of system variables, such as curschoolid or curyearid.  In reports where there were derived tables via withs or joins, system variables weren't translating properly before being used in the main select.  For example, if curyearid was used in a with, the with was ending up with more than just the current year's worth of data, which could impact the outcome of the report.  The change in the new versions fixes that issue and still allows the Open in New Window feature to work correctly.

I also made the following changes - they're not related to the issue above, but deal with a couple things people have asked about recently.  One should clear the browser cache or force a page reload on the output page of a report by holding down the shift key in order to see the changes:

  • The HTML5 buttons in 5.4.3 now work like the ones in 5.5.x.  One does not have to select results first before copying, exporting, or printing results like in 5.4.2.  Instead, one can use the buttons similar to the Flash buttons. 
  • The HTML5 results page had a light gray color to odd number rows and it was hard to see any striping and offset to the rows.  I made the color a light blue instead for both 5.4.3 and 5.5.2. 

I'm sorry for releasing several updates in January.  I was mainly just planning on 5.5 being new, but the update due to the PS scripting error was unexpected, and anytime an issue comes up that affects the reliability of the output, such as the Open in New Window issue reported earlier this month or the issue reported on Monday, I try to get an update out asap.  If anyone runs across any problems, please let me know.