logo

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 data from the output of the Current Grades Report - No Minimum sqlReport:

pvtsampletable


The pivot table above was created by clicking on the Copy button of the following report output:

curgrdrpt


Then pasting the data into the Online Pivot Tables page and dragging and dropping column headings into different areas to create various pivot tables or charts.  

pvtcopywithouttitle

You can also upload a CSV file, which you can create from other reports and exports in the SIS, and build pivot tables based on the data from the file.

The plugin is free to anyone with an account on this site and is based on the free pivottable.js software.