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.
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.
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.