~[tlist_sql;SELECT bs.id, bs.Name
FROM Calendar_Day cd
INNER JOIN Bell_Schedule bs ON cd.Bell_Schedule_ID = bs.ID
WHERE cd.date_value = to_date('~[date]','MM/DD/YYYY')
AND cd.SchoolID =~(curschoolid);nonemessage=
~[tlist_sql;
SELECT grade_level,
count(student_number) as glcount
FROM students
WHERE enroll_status=0
~[if.district.office][else]
AND schoolid = ~(curschoolid)
[/if.district.office]
GROUP BY grade_level
ORDER BY grade_level]
[/tlist_sql]
~[tlist_sql;
SELECT count(student_number) as totcount
FROM students
WHERE enroll_status=0
~[if.district.office][else]
AND schoolid = ~(curschoolid)[/if.district.office]]
~[tlist_sql; select Name, NOfRecs, CASE WHEN UserID=-1 THEN ' - P' ELSE '' END P from selections where schoolid=~(curschoolid) and (userid=~[x:userid] or userid=-1) order by Name asc;nonemessage=