1,309
edits
Changes
→sqlReports Examples
* [[Media:SqlReport mastersched gradecount.txt.zip|Master Schedule with Grade Counts]] - Reports master schedule data for the current term(s), with class size, but also broken down by grade level. Useful for finding teachers who have just seniors, or juniors, etc. If you set a grade level to "No", it will NOT include any sections that have any students in that grade level.
**For example, to find sections with ONLY seniors, set 9th, 10th and 11th to "No" and Seniors to "Yes".
* [[Media:DemeritCount sqlReport.zip|Demerit Count]] - Reports active students in the current school and their demerit count based on the adoption of discipline_incidenttype field in log table as demerit field. You can modify query to suit your implementation of demerits.
[[Category: Contents]]
