The download on this page will only appear once you're logged into the site.  If you don't have an account, you can apply for a free account to access the download by filling out the account application.


Below is the download for the free version of sqlReports (v. 6.10.2).  Download the file to your computer and then unzip it - the file itself is not a plugin - and follow the directions in the sqlReports Installation Guide pdf.  The user guide is available within sqlReports once you have it installed.   If you're not familiar with plugins, please read the Using Plugins article on this site first before attempting to install sqlReports.

By downloading the file below you agree to this site's Terms of Use.
 

Files:

You must login to download this file.

This is only a simple document without a file.
Information
Created Date 05-20-2019
Updated Date 07-23-2019


More information about sqlReports:  Release Notes - Version History - Acknowledgements

 



sqlReports FAQ

What's included in the free download of sqlReports?

The download includes the free version of sqlReports for the admin and teacher portals, an installation guide, a handful of free reports, and sqlExports Lite.  The sqlReports user guide can be found within the admin version of sqlReports itself once it's installed.  Any changes to the download can be found on the Site Updates page.

What's included in the premium version of sqlReports?

sqlReports Premium includes all the features of the free version of sqlReports, plus additional features, such as assigning more than one group to be preferred admins, up to 8 parameters per report, a Header and Footer area, and much more.

After an upgrade, do 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.

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 some free reports in the download that you can install.

Does sqlReports work with PS 12 or PS 19 and higher?

Yes - sqlReports 6.x and sqlReports Premium have been tested with PS 12 and 19 and work fine with both.

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.

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

Anyone who is on PS 11.0.4.1 or later and is on a version prior to sqlReports 5.4.x will get the error when importing a sqlReport.  You can also get the error on any version of sqlReports if one is using improper HTML in a sql query and trying to run the report or edit the report.   Consult the online documentation in sqlReports 6.10.2 for more information regarding the improper HTML coding, or if you have an active site subscription, view this Knowledgebase article for more information.

Which versions of sqlReports are supported?

Only the following are supported - sqlReports Premium and sqlReports 6.x (support for sqlReports 5.x will end on August 1, 2019).  If you have an issue and you're on an unsupported version, you will need to update to a supported version to receive any support.

I have a plugin with the name Power_Pack_EWS_sqlReports5 - is it supported?

No - that is an unauthorized, and outdated, version of sqlReports and should be removed from your server and replaced with a version from this site.  If you were told by the company that you should not uninstall it, you were misled because the reports for it will work fine with versions of sqlReports from this site.

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 the current version of sqlReports, 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.   You will not be able to use reports from this site with Custom SQL Reports, however, any reports built with it will work in sqlReports, so you can upgrade and get all the new features while still keeping your original sql and columns.

Do PowerQueries or APEX reports run in sqlReports?

No - neither works with sqlReports because the structure of the two does not lend itself to interoperability.  However, they all use SQL, so one could create a sqlReports report or chart based on the SQL used in them.