sqlCharts Overview

sqlCharts is an add-on for sqlReports that 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.
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.

Below is a short overview of sqlCharts (video resides on YouTube):

 

sqlCharts FAQ

Do I need to be on a specific version of sqlReports to use it?

Yes - you must be on at least version 4.3 of sqlReports because there are some files that are replaced and they are based on the 4.3 version.

How does it differ from the sqlCharts Lite that came with the free version of sqlReports 4 - 5.3.x?

The Lite version only does single series charts, whereas the full version does single series and multi-series.  For a complete list of charts and how they look, visit this page.  Also, the full version creates the chart based on a table of data on the page.  You can rearrange columns, hide columns, or filter columns, and rebuild the chart based on the data currently in the table.

 

 

Back to sqlReports Overview