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

Student List

Student Enrollment List as of ~[gpv:Date] for ~[tlist_sql; SELECT Schools.Name FROM Schools WHERE (Schools.School_Number = ~[gpv:School])] ~(Schools.Name) [/tlist_sql] Grade ~[gpv:Grade_Level]
 


~[if.~[gpv:School] = ~(curschoolid)] ~[tlist_sql; SELECT Stud.DCID, Stud.LastFirst FROM ( SELECT DCID, LastFirst FROM Students WHERE Students.Grade_Level = ~[gpv:Grade_Level] AND Students.SchoolID = ~[gpv:School] AND Students.EntryDate <= TO_DATE ( '~[gpv:date]', 'MM/DD/YYYY' ) AND Students.ExitDate > TO_DATE ( '~[gpv:date]', 'MM/DD/YYYY' ) UNION ALL SELECT Students.DCID, Students.LastFirst FROM ReEnrollments INNER JOIN STUDENTS ON Students.ID = ReEnrollments.StudentID WHERE ReEnrollments.Grade_Level = ~[gpv:Grade_Level] AND ReEnrollments.SchoolID = ~[gpv:School] AND ReEnrollments.EntryDate <= TO_DATE ( '~[gpv:date]', 'MM/DD/YYYY' ) AND ReEnrollments.ExitDate > TO_DATE ( '~[gpv:date]', 'MM/DD/YYYY' ) ) Stud ORDER BY Stud.LastFirst;alternatecolor] [/tlist_sql]
Student Name
~(count;-) ~(Students.LastFirst)
[else] ~[tlist_sql; SELECT Stud.LastFirst FROM ( SELECT DCID, LastFirst FROM Students WHERE Students.Grade_Level = ~[gpv:Grade_Level] AND Students.SchoolID = ~[gpv:School] AND Students.EntryDate <= TO_DATE ( '~[gpv:date]', 'MM/DD/YYYY' ) AND Students.ExitDate > TO_DATE ( '~[gpv:date]', 'MM/DD/YYYY' ) UNION ALL SELECT Students.DCID, Students.LastFirst FROM ReEnrollments INNER JOIN STUDENTS ON Students.ID = ReEnrollments.StudentID WHERE ReEnrollments.Grade_Level = ~[gpv:Grade_Level] AND ReEnrollments.SchoolID = ~[gpv:School] AND ReEnrollments.EntryDate <= TO_DATE ( '~[gpv:date]', 'MM/DD/YYYY' ) AND ReEnrollments.ExitDate > TO_DATE ( '~[gpv:date]', 'MM/DD/YYYY' ) ) Stud ORDER BY Stud.LastFirst;alternatecolor] [/tlist_sql]
Student Name
~(count;-) ~(Students.LastFirst)
[/if]

~[wc:admin_footer_css]