sqlReports Download

The current version of sqlReports is 5.3.0, and is similar to 4.7.0 except it allows report writers to choose to use non-Flash buttons on individual reports.  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.3.0 - Installation Guide / User Guide

Files:
sqlReports 5.3.0 (6/24/2017) Size: File Size 2.08 MB Downloads: Download 1,546 Download

 


FAQ

What's new in sqlReports 5.3.0?

sqlReports 5.3 builds on 5.1.1 and includes newer versions of the DataTables and Buttons software than previous releases of 5.x.  The new files fix issues with the copy button and the interaction between some browsers and buttons as mentioned in recent blog posts.  Please read this blog post for more details, as well as visit the Documentation page for links to release notes and version history.

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.

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 10?

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

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

Yes - you need to be on PowerSchool 9 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 higher, 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.