Welcome to FreundResources.net, the web site of sqlReports, the popular SQL reporting system for the PowerSchool SIS. Scroll down to find information on the various products on this site (free and subscription based), and information regarding the sqlReports Subscription, which provides support and resources for the subscription based products from this site.
Click here to view the FAQ regarding sqlReports and the Enhanced User Interface.
Free Products
The following products are available to anyone with an account on this site. If you do not have an account, you can apply for one via the Account Application page under the Login menu.
sqlReports Demo
sqlReports Demo is a free version of sqlReports and is available to anyone with an account on this site. If you don't have an account you can apply for one via the Account Application page under the Login menu. The table below shows the main differences between the free sqlReports Demo and...
sqlReports - Online Pivot Tables
The sqlReports Online Pivot Tables is a free plugin that works with any version of sqlReports (Premium, Classic, Demo, etc.). It allows one to create pivot tables in the SIS by either copying data from a sqlReport or uploading a CSV file. Below is an example of a pivot table based on...
sqlReports SQL Query Checker
The sqlReports SQL Query Checker is a free plugin 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...
FormLetters+
FormLetters+ (formerly known as sqlFormLetters) 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...
Subscription Based Products
The following products are available as part of the sqlReports Subscription.
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. Below...
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.