1,158
edits
Changes
→sqlReports Examples
* [[Media:CheckForIncompleteSchedules.txt.zip|Check for Incomplete Schedules]] - Lists students with incomplete schedules in PowerScheduler. Posted by Mantas.
* [[Media:Current Grades D-F No comments.txt.zip|Current Grades - D/F's with No Comments]] - Searches students who have a D or F with no teacher comment. Posted by Trish
* [[File:Current Grades NU's No comments.txt.zip|Current Grades - N/U Citizenship with No Comments]] - Searches Students who have a citizenship of N or U with no teacher comment. Posted by Trish
* [[Media:SqlReport RoomUtilization.txt.zip|Room Utilization from Valley]] - Matrix view with rooms on left side and a column view for each period with totals per period. Unused rooms show a blank.
**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.
