The teacher portal version of sqlReports is part of sqlReports Premium, which means it's only available as part of the sqlReports Subscription. It was added to sqlReports by Matt Freund and allows you to make your sqlReports reports available to teachers in the PowerTeacher Portal. Teachers cannot edit any reports, but they can run reports you give them access to in much the same manner as an admin runs sqlReports reports. The data is the screenshots below is fictional.
When a teacher logs into the PowerTeacher Portal, there's a new 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.
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.