Welcome to FreundResources.net, 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 resemblance 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 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 charts to...
sqlReports Lists
sqlReports Lists is built into sqlReports and allows admins to run reports similar 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. Similar to sqlReports, the output can have buttons and column filtering. ...
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 scheduled to run at a certain date and time. ...
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.
Please visit the Subscription Pricing page for detailed pricing, or the Request a Quote page to request a quote. Both pages can be found under the Subscriptions menu at the top of the page.
Free Plugins
The following are free plugins 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 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 information on troubleshooting...
FormLetters+
FormLetters+ (also known as sqlFormLetters 6) is a free plugin that allows one to create form letters, plus individual student and staff reports. The output is an HTML page containing all of the letters, but when printed, page breaks will create individual letters and reports. The...
SIS 23.5 EUI Compatible Files
Plugins for sqlReports, FormLetters+, and sqlFormLetters are available that add left menu items for the Enhanced User Interface (EUI) on SIS 23.5 (and higher). Below is an example of the menu item for sqlReports: The plugin will work with versions of sqlReports 13 or 14, and...
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.