~[if.~[gpv:School] = ~(curschoolid)]
Student Name |
~[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]
~(count;-) |
~(Students.LastFirst)
|
[/tlist_sql]
[else]
Student Name |
~[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]
~(count;-) |
~(Students.LastFirst)
|
[/tlist_sql]
[/if]