Welcome to the web site of sqlReports, the popular SQL reporting system for the PowerSchool SIS. Use the menu system at the top or click on the 'Read more' buttons in the sections below to learn more about sqlReports, the various add-ons, and the sqlReports Subscription that provides support and resources.
Product Information
Screenshots below and throughout this site contain fictional data of schools and individuals. Any resemblence to real schools or individuals is purely coincidental.
sqlReports
Since 2009, sqlReports has allowed admins to easily create custom reports that use SQL to get the data for the report, hence the name sqlReports. Reports can run in either the admin or teacher portal, with the output being in various formats, such as columns, charts, or lists like the...
sqlReports - Teacher Portal
The teacher portal version of sqlReports is an add-on that allows teachers to use sqlReports in the PowerTeacher Portal. Teachers can run reports in the same manner as an admin runs sqlReports, with the report output in columns or charts and having some of the same functionality, such as...
sqlCharts
sqlCharts is built into sqlReports and allows one to turn a sqlReport into a variety of charts without having to do any chart coding. Charts can be single series, such as a pie chart, or multi-series, which compares multiple items, such as a column chart with different grade levels. ...
sqlReports Lists
sqlReports Lists is built into sqlReports and allows admins to run reports similiar to the List Students or List Staff group functions. Instead of SQL, the report can be based on fields and DAT's and saved so that it can be run by any user. Plus, the output can have sqlReports output...
sqlFormLetters
sqlFormLetters is a plugin that allows one to use SQL to help create the content of a form letter. For example, you could create a letter that uses SQL to only list courses with low grades. Form letters can run in either the admin or teacher portal, and be for either students or...
sqlLabels
sqlLabels is a reporting engine report that can take a sqlReport and create an output of Avery 5160 mailing labels based on the sqlReport. Using the SQL from the sqlReport makes everything very powerful and very flexible, and best of all, no cumbersome contacts DAT's to try to figure out!...
sqlReports Subscription Information
The sqlReports Subscription is an annual subscription that includes support for the products mentioned above, plus:
- Access to 300+ reports for use with sqlReports.
- Access to how-to articles and knowledgebase articles.
Latest Blog Posts
The full list of Blog Posts can be found under the Company menu.
FreundResources.net Site Changes
Published on January 14, 2023 - The following changes have been made to the FreundResources.net web site: Blog posts - the Latest News area has been renamed Blog Posts. The list can be found under the Company menu, and if one isn't logged into the site, only the blog posts marked public...
sqlReports Demo is Now Available
Published on January 2, 2023 - sqlReports Demo, which was mentioned on this site back in October, is available as a free download from this site. It's a modified version of sqlReports Premium and here is a comparison of the two: sqlReports Demo sqlReports Premium...
What to Expect with the Site after December 31, 2022
Published on October 20, 2022 - Updated on November 30, 2022 (added FAQ section) Back in May, 2021, I posted about the end-of-life for sqlReports Classic on December 31, 2022. The date is now just a couple months away and this post will provide updated information on what to expect on...
Some areas on the site may require one to have an account to access the information. If you don't have an account you can apply for one via the Account Application page under the login menu.