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.  The add-on is part of the sqlReports Subscription and the plugin is in the same download file as the sqlReports admin portal plugin.

When a teacher logs into the PowerTeacher Portal, there's a link for sqlReports in the left side navigation menu (one can change the link text to something other than sqlReports if needed):



Once a teacher clicks on the link, a menu of reports that have been made available to the teacher appears.  Reports will appear in report groups, and if the output of the report is a chart, the C icon appears to the right of the report title. 

Once a teacher clicks on a report, the parameters page will appear.  Any parameters will appear and the teacher clicks submit to run the report:


The teacher has the option to copy, export, or print the data, or the results can be narrowed down by a search or by using column filtering.  Clicking on any of the buttons will use what's currently on the screen, so if one filtered the results and then clicked on the Print button, only those students showing on the screen would be included:

PT Sample Output


Advantages to Using sqlReports in the Teacher Portal

  • No Need to Create Custom Pages and Links - just like with the admin portal, there's no need to create a lot of custom pages and the links to go with them.  The menu system allows teachers to find the reports easily.
  • Control Who Sees the Reports - only reports that have been assigned to the group the teacher is in show in the menu.  You can create several groups and make reports even more specific.  For example, you could assign a report to just high school teachers, or assign a report to all teacher groups.
  • Create Reports or Charts Teachers Can Use - create reports covering a wide range of data - class rosters, student test scores, gradebook data, etc., plus create charts that they can use to help analyze data and trends.