~[if.~[gpv:School] = ~(curschoolid)]
Student Name |
~[tlist_sql;
SELECT Students.DCID, Students.LastFirst
FROM Students
WHERE ( Students.Enroll_Status = 0 OR Students.EntryDate > '~[eaodate]' ) AND Students.Sched_NextYearGrade = ~[gpv:Sched_NextYearGrade] AND Students.Next_School = ~[gpv:Next_School] AND Students.Sched_Scheduled = 1
ORDER BY Students.LastFirst;alternatecolor]
~(count;-) |
~(Students.LastFirst)
|
[/tlist_sql]
[else]
Student Name |
~[tlist_sql;
SELECT Students.LastFirst
FROM Students
WHERE ( Students.Enroll_Status = 0 OR Students.EntryDate > TO_DATE('~[eaodate]','MM-DD-YY') ) AND Students.Sched_NextYearGrade = ~[gpv:Sched_NextYearGrade] AND Students.Next_School = ~[gpv:Next_School] AND Students.Sched_Scheduled = 1
ORDER BY Students.LastFirst;alternatecolor]
~(count;-) |
~(Students.LastFirst)
|
[/tlist_sql]
[/if]