1,309
edits
Changes
→sqlReports Examples
**WARNING! This report uses pivot, in SQL pivots need to have the columns "hard-coded". This report is code for 1(A), 2(A), 3(A), 4(A), 5(A), 6(A) and 7(A) as expressions. You will need to modify for your own use.
* [[Media:Attendance Reconciliation sqlReports4 PSUGSE2016.txt.zip|Attendance Reconciliation from PSUG SE 2016 - Putting all Together]] - Lists students and their daily attendance with time in/time out compared to meeting attendance for a user-selected date.
* [[Media:Student email missing.txt.zip|Student Email Missing]] - Lists students from the grade levels specified by the user who do not have an email entered in the stock student email field.
* [[Media:StudentRequestTally.txt.zip|Student Request Tally]] - A near clone of the built-in "Student Request Tally" found in PowerScheduler, but with filters and the ability to make the filtered results the current student selection. For example, filter to students with 0 requests and make them the current selection.
* [[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".
[[Category: Contents]]
