Welcome to the web site of sqlReports, the popular SQL reporting system for the PowerSchool SIS. Scroll down to find more information on sqlReports, the other products on this site (free and subscription based), and the sqlReports Subscription which provides support and resources for products from this site.
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 List Students group...
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 buttons and column filtering. ...
sqlCharts
sqlCharts is built into sqlReports Premium 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. There are 27 different...
sqlReports Lists
sqlReports Lists is built into sqlReports Premium 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 features, such as buttons...
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 staff. Below is an example...
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! Below is an example of how...
sqlExports
sqlExports is a reporting engine report that allows one to export the output of a sqlReport to a tab or comma delimited file that is saved to the report queue. It will prompt you to enter any report parameters, the file type, and if you want to run the report right away or be scheduled to run at a certain date and...
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.
Free Downloads
The following are free downloads available on this site.
sqlReports Demo
sqlReports Demo is a free version of sqlReports and is available to anyone with an account on this site. The table below shows the main differences between sqlReports Demo and the full version of sqlReports: sqlReports Demo sqlReports Pricing Free Part of the sqlReports...
sqlReports SQL Query Checker
The sqlReports SQL Query Checker is a free add-on that works with any version of sqlReports (Premium, Classic, Demo, etc.). It can help report writers troubleshoot column counts and invalid character issues. The checker highlights relevant coding and provides...
sqlFormLetters - Admin Portal
Coming Soon! The sqlReports Subscription includes a plugin known as sqlFormLetters, which can be used to create web-based form letters, report cards, etc., for both the admin and teacher portal. More information about the plugin can be found here. The admin portal version will be...
Latest Blog Posts
The full list of Blog Posts can be found under the Company menu.
sqlReports 14 is Now Available
Published on February 21, 2023 - sqlReports v. 14.0.0 is now available for download for those with an active sqlReports Subscription. The word Premium has been dropped from the version because it's the only version available other than the free sqlReports Demo version, which has also been...
sqlReports SQL Query Checker is Now Available
Published on February 21, 2023 - A free plugin to help users check their queries in sqlReports is now availble. The plugin is called the SQL Query Checker and should work with any version of sqlReports. Anyone with an account on the site can download the plugin - look for it in the...
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...
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.