sqlReports Download

There are currently two versions of sqlReports available for download.  The functionality is the same for both of them, so you only need to download one of them.  The difference between the two is sqlReports 5.5.2.x only uses HTML5 buttons on the results page, whereas 5.4.3.x defaults to Flash buttons and has the option to use HTML5 buttons on a report-by-report basis.   The downloads below are free to use - if you have a valid full site subscription, log into the site and then go to the site subscriber downloads area to download the site subscriber versions instead.

Once you download a zip file below, it's very important that you unzip it and follow the directions in the Installation Guide.  The download contains plugin files, which is the recommended installation approach to use.  If you're not familiar with plugins, please read the Using Plugins article on this site first.

Documentation - Installation Guide / User Guide / Release Notes / Version History

sqlReports 5.4.3.1 -

Files:
sqlReports 5.4.3.1 (2/16/2018) Size: File Size 4.29 MB Downloads: Download 720 Download


sqlReports 5.5.2.1
-

sqlReports 5.5.2.1 (2/15/2018) Size: File Size 3.73 MB Downloads: Download 557 Download




FAQ

I'm running an earlier version, should I upgrade?

Yes - more information can be found on the new releases at this blog post (5.5.2.1 and 5.4.3.1 fix an issue with &'s in column filters and an issue with row grouping counts, both when using HTML5 buttons - see this blog post for more information).  You can upgrade to the new releases regardless of the version you're currently on.  If you're using the Saved Params add-on, the param files in it have been updated and should be loaded (no need to reload the virtual table if you're just doing an update).

I get a Cross-Site Scripting Error with sqlReports - why?

Anyone who has upgraded to PS 11.0.4.1 and is on a version of sqlReports prior to the current ones will get the error when importing a new sqlReport.  Also, one can get the error on any version of sqlReports if one is using HTML in a sql query and trying to run the report or edit the report.  Please see this article for more information, or the updated Using HTML Coding in sqlReports for coding to use with 11.0.4.1.

What's the difference between 5.4.x and 5.5.x and which should I use?

The main difference is the buttons as noted above, but more detailed information can be found in this blog post.   Anytime you install a new version, be sure to clear your browser cache as new css files and scripts (both which get cached by browsers) are used.

I'm new to sqlReports - does installing the plugin add any reports?

No - the install only adds the customization itself.  The reports themselves are stored in the Gen table and there's no way to install them with a plugin.  You will need to add reports using the import feature of sqlReports and there are 30+ free reports at this site that you could install.

After I upgrade, will I have to rebuild reports I made in earlier versions?

No - every version of sqlReports saves the report setup in the same table in the database.  Any report you created in an earlier version, including the Custom SQL Reports version, will show up automatically in sqlReports.

Is there a way to stay currrent on new developments?

Yes - the latest news is posted on this site's home page, and if you're on Facebook, new items are posted on the site's Facebook page.  You can also join the sqlReports user group and receive email related to new developments.

Does sqlReports work with PS 12?

Yes - sqlReports and it's add-ons have been tested with PS 12 and work fine with it.

Do I need to be on a specific version of PowerSchool?

Yes - you need to be on PowerSchool 10 or higher.

Can I use sqlReports even if I'm hosted?

Yes - it's like any other customization and will work on hosted or self-hosted environments

How is sqlReports different than Custom SQL Reports?

Custom SQL Reports is a much older version of sqlReports - it's basically a modified version of sqlReports 2.  It's missing a lot of the features that are standard with sqlReports 4 and 5, such as restricting which groups can run reports, drop-down column filtering, row grouping, field level security, drop-down menus on the parameters part, and much more.  Plus it cannot run the reports at this site and does not work with sqlExports.  Reports built in Custom SQL Reports though will work in sqlReports, so you can upgrade and get all the new features while still keeping your original sql and columns.

Can I create my own drop-down menus?

Yes - previous downloads had a pdf on how to do it, but that pdf has been replaced with an online article that can be found here.

Will PowerQueries run in sqlReports?

No - PowerQueries themselves will not work with sqlReports because the structure of the two does not lend itself to interoperability.  However, one could simply create a sqlReports report based on the SQL from the PowerQuery and add user parameters and built-in parameters, and create a sqlReports report or chart for admins and/or teachers based on the SQL.

I'm not familiar with SQL - is there a place to learn the basics?

Yes - check out the articles on SQL written by Matt in the Resources section of this site.