1,309
edits
Changes
→sqlReports Examples
* [[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 for1(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]]
