~[wc:commonscripts] ~[wc:admin_header_css]~[text:psx.html.admin_reports.runreports.start_page] > ~[text:psx.html.admin_reports.runreports.reports] > Enrollment Summary Reports > Current Enrollment Summary~[wc:admin_navigation_css]

Current Enrollment Summary

~[tlist_sql; SELECT Schools.Name AS School, Schools.School_Number AS School_Number, SUM ( CASE WHEN Students.Grade_Level = -3 THEN 1 ELSE NULL END ) AS Minus_Three, SUM ( CASE WHEN Students.Grade_Level = -2 THEN 1 ELSE NULL END ) AS Minus_Two, SUM ( CASE WHEN Students.Grade_Level = -1 THEN 1 ELSE NULL END ) AS Minus_One, SUM ( CASE WHEN Students.Grade_Level = 0 THEN 1 ELSE NULL END ) AS K, SUM ( CASE WHEN Students.Grade_Level = 1 THEN 1 ELSE NULL END ) AS One, SUM ( CASE WHEN Students.Grade_Level = 2 THEN 1 ELSE NULL END ) AS Two, SUM ( CASE WHEN Students.Grade_Level = 3 THEN 1 ELSE NULL END ) AS Three, SUM ( CASE WHEN Students.Grade_Level = 4 THEN 1 ELSE NULL END ) AS Four, SUM ( CASE WHEN Students.Grade_Level = 5 THEN 1 ELSE NULL END ) AS Five, SUM ( CASE WHEN Students.Grade_Level = 6 THEN 1 ELSE NULL END ) AS Six, SUM ( CASE WHEN Students.Grade_Level = 7 THEN 1 ELSE NULL END ) AS Seven, SUM ( CASE WHEN Students.Grade_Level = 8 THEN 1 ELSE NULL END ) AS Eight, SUM ( CASE WHEN Students.Grade_Level = 9 THEN 1 ELSE NULL END ) AS Nine, SUM ( CASE WHEN Students.Grade_Level = 10 THEN 1 ELSE NULL END ) AS Ten, SUM ( CASE WHEN Students.Grade_Level = 11 THEN 1 ELSE NULL END ) AS Eleven, SUM ( CASE WHEN Students.Grade_Level = 12 THEN 1 ELSE NULL END ) AS Twelve, SUM ( CASE WHEN Students.Grade_Level = 13 THEN 1 ELSE NULL END ) AS Thirteen, SUM ( CASE WHEN Students.Grade_Level < 99 THEN 1 ELSE NULL END ) AS Total, Schools.SortOrder FROM Students INNER JOIN Schools ON Schools.School_Number = Students.SchoolID WHERE Students.Enroll_Status = 0 AND Students.Grade_Level < 99 GROUP BY Schools.Name, Schools.School_Number, Schools.SortOrder ORDER BY Schools.SortOrder;alternatecolor] [/tlist_sql] ~[tlist_sql; SELECT 'Total' AS School, SUM ( CASE WHEN Students.Grade_Level = -3 THEN 1 ELSE NULL END ) AS Minus_Three, SUM ( CASE WHEN Students.Grade_Level = -2 THEN 1 ELSE NULL END ) AS Minus_Two, SUM ( CASE WHEN Students.Grade_Level = -1 THEN 1 ELSE NULL END ) AS Minus_One, SUM ( CASE WHEN Students.Grade_Level = 0 THEN 1 ELSE NULL END ) AS K, SUM ( CASE WHEN Students.Grade_Level = 1 THEN 1 ELSE NULL END ) AS One, SUM ( CASE WHEN Students.Grade_Level = 2 THEN 1 ELSE NULL END ) AS Two, SUM ( CASE WHEN Students.Grade_Level = 3 THEN 1 ELSE NULL END ) AS Three, SUM ( CASE WHEN Students.Grade_Level = 4 THEN 1 ELSE NULL END ) AS Four, SUM ( CASE WHEN Students.Grade_Level = 5 THEN 1 ELSE NULL END ) AS Five, SUM ( CASE WHEN Students.Grade_Level = 6 THEN 1 ELSE NULL END ) AS Six, SUM ( CASE WHEN Students.Grade_Level = 7 THEN 1 ELSE NULL END ) AS Seven, SUM ( CASE WHEN Students.Grade_Level = 8 THEN 1 ELSE NULL END ) AS Eight, SUM ( CASE WHEN Students.Grade_Level = 9 THEN 1 ELSE NULL END ) AS Nine, SUM ( CASE WHEN Students.Grade_Level = 10 THEN 1 ELSE NULL END ) AS Ten, SUM ( CASE WHEN Students.Grade_Level = 11 THEN 1 ELSE NULL END ) AS Eleven, SUM ( CASE WHEN Students.Grade_Level = 12 THEN 1 ELSE NULL END ) AS Twelve, SUM ( CASE WHEN Students.Grade_Level = 13 THEN 1 ELSE NULL END ) AS Thirteen, SUM ( CASE WHEN Students.Grade_Level < 99 THEN 1 ELSE NULL END ) AS Total FROM Students WHERE Students.Enroll_Status = 0 AND Students.Grade_Level < 99] [/tlist_sql]
School Pre-Preschool Preschool Pre-K K 1 2 3 4 5 6 7 8 9 10 11 12 13 Total
~(School) ~(Minus_Three) ~(Minus_Two) ~(Minus_one) ~(K) ~(One) ~(Two) ~(Three) ~(Four) ~(Five) ~(Six) ~(Seven) ~(Eight) ~(Nine) ~(Ten) ~(Eleven) ~(Twelve) ~(Thirteen) ~(Total)
~(School) ~(Minus_Three) ~(Minus_Two) ~(Minus_one) ~(K) ~(One) ~(Two) ~(Three) ~(Four) ~(Five) ~(Six) ~(Seven) ~(Eight) ~(Nine) ~(Ten) ~(Eleven) ~(Twelve) ~(Thirteen) ~(Total)

~[wc:admin_footer_css]