~[wc:commonscripts] ~[wc:admin_header_css]~[text:psx.html.admin_studentlist.studentlist1.start_page] > ~[text:psx.htmlc.admin.cr_auto_loader.reportmanage.Manage_Class_Roster_Sets]~[wc:admin_navigation_css]

~[text:psx.htmlc.admin.cr_auto_loader.reportmanage.Manage_Class_Roster_PDF_Sets]

~[if#changes.~(gpv.changesrecorded)=yes]
~[text:psx.htmlc.admin.cr_auto_loader.reportmanage.Roster_Set_Deleted]
[/if#changes]
~[text:psx.htmlc.admin.cr_auto_loader.reportmanage.security_group_warning]
~[text:psx.htmlc.admin.cr_auto_loader.reportmanage.redirect_warning]
Report Criteria
~[tlist_sql; SELECT U_CR_AUTOLOAD.id, CASE WHEN U_CR_AUTOLOAD.roster_personal <> ~[x:users_dcid] THEN 'removeLink' ELSE 'normal' END schoolClass, U_CR_AUTOLOAD.roster_name, CASE WHEN U_CR_AUTOLOAD.roster_personal is not null THEN 'Personal' ELSE U_CR_AUTOLOAD.roster_schools_abv END, to_char(coalesce(U_CR_AUTOLOAD.WHENMODIFIED,U_CR_AUTOLOAD.WHENCREATED), 'MM/DD/YYYY'), coalesce(U_CR_AUTOLOAD.WHOMODIFIED,U_CR_AUTOLOAD.WHOCREATED) FROM U_CR_AUTOLOAD ~[if#type.~(gpv.lsType)=] WHERE U_CR_AUTOLOAD.roster_personal is null [/if#type] ~[if#type.~(gpv.lsType)=mypersonal] WHERE U_CR_AUTOLOAD.roster_personal = ~[x:users_dcid] [/if#type] ~[if#type.~(gpv.lsType)=allpersonal] WHERE U_CR_AUTOLOAD.roster_personal is not null [/if#type] ORDER BY U_CR_AUTOLOAD.roster_name ;nonemessage=] [/tlist_sql]
~[text:psx.htmlc.admin.cr_auto_loader.reportmanage.Roster_Set_Name] ~[text:psx.htmlc.admin.cr_auto_loader.reportmanage.Schools] ~[text:psx.htmlc.admin.cr_auto_loader.reportmanage.Last_Modified] ~[text:psx.htmlc.admin.cr_auto_loader.reportmanage.Modified_By]  
~[text:psx.htmlc.admin.cr_auto_loader.reportmanage.No_Roster_Sets_Found]
~(roster_name) ~(school) ~(when) ~(who) ~[text:psx.htmlc.admin.cr_auto_loader.reportmanage.Delete]
~[wc:admin_footer_css]