~[text:nicktech.busnotes.admin.reports.Todays_Bus_Notes] - ~[short.date]

~[tlist_sql; SELECT s.last_name AS last_name, s.first_name AS first_name, s.home_room AS home_room, '~[if#rp.pref.busnotes_report_perm~(curschoolid)=1]normalTD[else#rp]hidden[/if#rp]' AS permClass, ~[if#rp.pref.busnotes_report_perm~(curschoolid)=1]u_bus.Perm_Note[else#rp]NULL[/if#rp] AS perm_note, LISTAGG( CASE WHEN bn.id IS NOT NULL THEN chr(60) || 'div class=' || chr(34) || 'busNoteLine' || chr(34) || chr(62) || bn.note || CASE WHEN bn.end_date > bn.start_date THEN ' ' || chr(60) || 'span class=' || chr(34) || 'busNoteRange' || chr(34) || chr(62) || '(' || to_char(bn.start_date,'fmMM/DD/YY') || ' - ' || to_char(bn.end_date,'fmMM/DD/YY') || ')' || chr(60) || '/span' || chr(62) ELSE '' END || ' ' || chr(60) || 'span class=' || chr(34) || 'busNoteInfo' || chr(34) || ' data-toggle=' || chr(34) || 'tooltip' || chr(34) || ' data-placement=' || chr(34) || 'auto top' || chr(34) || ' data-original-title=' || chr(34) || REPLACE(REPLACE(REPLACE('~[text:nicktech.busnotes.admin.reports.js.note_info]', '{0}', REPLACE(bn.user_entered, chr(34), chr(39))), '{1}', to_char(bn.whencreated,'MM/DD/YYYY HH12' || chr(58) || 'MI AM')), '{2}', to_char(bn.no_days)) || chr(34) || chr(62) || chr(60) || '/span' || chr(62) || chr(60) || '/div' || chr(62) END , '' ON OVERFLOW TRUNCATE WITHOUT COUNT) WITHIN GROUP (ORDER BY bn.start_date) AS notes FROM students s LEFT OUTER JOIN u_bus_notes bn ON bn.studentsdcid = s.dcid AND trunc(sysdate) BETWEEN bn.start_date AND bn.end_date LEFT OUTER JOIN u_bus ON u_bus.studentsdcid = s.dcid WHERE s.schoolid = ~(curschoolid) AND s.enroll_status = 0 AND (bn.id IS NOT NULL~[if#rp.pref.busnotes_report_perm~(curschoolid)=1] OR TRIM(u_bus.Perm_Note) IS NOT NULL[/if#rp]) GROUP BY s.dcid, s.last_name, s.first_name, s.home_room, u_bus.Perm_Note ORDER BY s.last_name, s.first_name ;nonemessage=] [/tlist_sql]

~[text:nicktech.busnotes.admin.reports.Last_Name]	~[text:nicktech.busnotes.admin.reports.First_Name]	~[text:nicktech.busnotes.admin.reports.Home_Room]	~[text:nicktech.busnotes.admin.reports.Permanent_Notes]	~[text:nicktech.busnotes.admin.reports.Todays_Notes]
~[text:nicktech.busnotes.admin.reports.No_Bus_Notes]
~(last_name)	~(first_name)	~(home_room)	~(perm_note;ReplaceCRLFWithBR)	~(notes;ReplaceCRLFWithBR)