sqlCharts Overview

sqlCharts builds on the power and flexibility of sqlReports by letting you view your report results as charts.  Below are some benefits to using sqlCharts:

bullet blue alt sqlCharts runs within PowerSchool - no need to transfer your data to another server or give access to your data to third party vendors.
bullet blue alt You do not need to know how to code charts in PowerSchool - sqlCharts takes care of all of the chart coding for you.  You just build your query in sqlReports and check a box to use the results in a chart.
bullet blue alt The charts are based on sqlReports reports, so your sql can use parameters and system variables.   It's based on a data table, so you can use column filtering, column reordering, and show/hide columns to change the table and click the Submit button to create a new chart.
bullet blue alt You can use the Run Access part of sqlReports to allows only certain groups to have access to the chart.  You can also give teachers access to charts.
bullet blue alt You can create charts for a wide variety of things - grades, attendance, standards, etc.  Anything you have in your PowerSchool database can be charted and you control how many charts, how they look, and what they cover.

With sqlCharts, you create a sqlReport to create something like this:

gender table screenshot

and sqlCharts allows you to turn it into this:

gender graph screenshotBelow is a screenshot of the main window for sqlCharts.  There are over 25 chart types available, including pie, chart, bar, line, and stacked charts.  You can create single series charts, which only graph one thing, such as the population of each grade level, or multi-series charts, like the one above that graphs multiple items per grade level.  You can also change chart titles, labels, size, and background information:

chart parameters

There's a version available for users of the teacher version of sqlReports, so you can create charts that your teachers can view in the PowerTeacher portal.


Back to sqlReports Overview