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.1 only uses HTML5 buttons on the results page, whereas 5.4.2 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

sqlReports 5.4.2 -

Files:
sqlReports 5.4.2 (1/20/2018) Size: File Size 2.9 MB Downloads: Download 4 Download


sqlReports 5.5.1
-

sqlReports 5.5.1 (1/20/2018) NEW Size: File Size 3.73 MB Downloads: Download 3 Download


FAQ

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

Yes -  due to a new security fix in versions of PowerSchool released on 1/19/2018, the import feature of earlier versions of sqlReports becomes unusable.  The import files in 5.4.2 and 5.5.1 were updated to make the import work again.  You can read more about the change, plus how you can manually apply the fix to earlier versions of sqlReports if you do not wish to upgrade, in this blog post.

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.   If you have been using sqlReports 4 or 5.4.1 and upgrade to 5.5, be sure to clear your browser cache as new css files and scripts (both which get cached by browsers) are used in 5.5.x.  Also, if you're using the Saved Params add-on, be sure to load the files for 5.5.x for it.

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.

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

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.