1,158
edits
Changes
→sqlReports Examples
* [[Media:DuplicateCourseRequests.txt.zip|Duplicate Course Requests]] - Reports students who have more than one request for a course number. Uses the current school and the working scheduling year. User can choose to ignore a duplicate request, where the 2nd request is an alternate and the first request is primary. Posted by Roger
* [[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
* [[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.
* [[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.
[[Category: Contents]]
