Published on May 11, 2020
New versions of sqlReports and other plugins and products on this site are available and compatible with SIS 20.x, however, please read the following to help decide when to upgrade to SIS 20.x.
1 - The new versions of sqlReports are known as sqlReports Premium v. 11, and sqlReports Classic v. 11. Once you upgrade to SIS 20.x, those are the only versions of sqlReports that will work on SIS 20.x.
Currently supported versions of sqlReports (sqlReports 6.x, sqlReports Classic v. 7, sqlReports Premium v 10.x), as well as older versions (sqlReports 4.x and 5.x), will no longer work once you move to SIS 20.x. Due to stricter cross-site scripting rules in SIS 20.x, those versions of sqlReports will give a cross-site scripting error when creating a report, editing a report, running a report, or importing a report.
sqlReports v. 11 is only available to account holders on this site, so please plan ahead to have an account prior to upgrading. You can apply for a free account by filling out the account application form under the login menu, and accounts are typically created soon after an application is reviewed, but sometimes there are delays.
2 - Unless you're using sqlReports Premium v. 11, you won't be able to use sqlCharts or use sqlReports on the teacher portal once you upgrade to SIS 20.x.
sqlReports Classic, the free version of sqlReports, was introduced on January 1, 2020, and does not include sqlCharts or the teacher portal version of sqlReports. If you do not have an active sqlReports subscription, you'll have to download and start using sqlReports Classic v. 11 once you upgrade to SIS 20.x. That means you'll lose use of sqlCharts and the teacher portal version of sqlReports when you upgrade.
If you don't have an active sqlReports subscription but wish to continue using charts and/or the teacher version of sqlReports, you will need to purchase (or renew) a sqlReports subscription in order to have access to sqlReports Premium v. 11. Otherwise, please plan ahead to convert the charts and teacher portal reports to custom pages.
3 - Letters in sqlFormLetters 3.x or 4.x will only work with SIS 20.x if you're running them as custom letters. The new version, sqlFormLetters 5, is the only version that's fully functional with SIS 20.x.
If you have an active sqlReports subscription, you'll just need to upgrade to sqlFormLetters 5. If you no longer have an active site subscription and still use sqlFormLetters, please plan ahead to either renew your subscription or make all the letters you use with it custom letters only. In other words, you won't be able to use the SQL tab but will instead need to code the sql part onto a custom letter.
4 - Older versions of sqlExports will continue to run reports as is unless the reports are edited, which will change the column heading structure and cause an issue with sqlExports.
If you have an active sqlExports subscription, you'll just need to upgrade to sqlReports v. 11 and sqlExports 11 once you upgrade to SIS 20.x. If you no longer have an active sqlExports subscription, please plan ahead to either renew your subscription or have other methods in place to transfer data.
If you have any questions, please contact me.