sqlReports Download

The current version of sqlReports is 5.4.0, and is similar to 4.7.0 except it allows report writers to choose to use non-Flash buttons on individual reports.  Plus, as of 5.4.0, the full version of sqlCharts is now part of the free version of sqlReports.  The download below is 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 version instead.

Once you download the 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.

sqlReports 5.4.0 - Installation Guide / User Guide

sqlReports 5.4.0 (11/1/2017) Size: File Size 2.91 MB Downloads: Download 2,035 Download



What's new in sqlReports 5.4.0?

sqlReports 5.4.0 builds on 5.3.1 and the main change is the addition of the full version of sqlCharts to the free version.  More information can be found in this blog post, and details on 5.3.1 can be found iin this blog post

I'm using 4.7.0 - do I need to upgrade to 5.x?

No, it's not a required upgrade.  The 5.x version allows the use of non-Flash buttons, so if you have reports with buttons that won't work on Chromebooks or iPads or computers without Flash, moving to the 5.x version will allow you to add buttons that will work on those machines.   More information can be found at this blog post.

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.

What happened to the download for 4.7.0?

The 4.7.0 version was removed on February 1, 2017.  However, users with a full site subscription can still access it if needed in the archives section of the premium downloads area.  The final download count for 4.7 was 1,504.

Does sqlReports work with PS 11?

Yes - sqlReports and it's add-ons have been tested with PS 11 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

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.

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 paramaters 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.