~[wc:commonscripts] ~[SetPostValue:skipDontPrintFilter=1] ~[SetPostValue:UseReportSettings=1] ~[SetPostValue:crrept_title=~[prefschool:crrept_title]]

Instructions

Selected page breaks and print options will be output when this page is printed. This instructional text will not be sent to the printer.

Note that due to browser differences, some browsers may fail to properly print this report. The fully supported browsers for this report are Internet Explorer 6.0+ on Windows and Safari 2.0+ on OS X.

Tips for printing:

Also note that this report has been opened in a new window. Once done printing, close this window to return to your previous PowerSchool session.

~[x:GetDoThisForStudents] ~[x:SortSelection;Students:~[prefschool:crrept_sort]] ~[Comment: Sorts the student selection for this page according to the field list in Pref mtrxrept_sort] ~[x:PaginationCountdownReset;~[prefschool:crrept_spp]] ~[Comment: Sets up a pagination counter based on the number of increments per page in Pref mtrxrept_spp] ~[RepeatForEach:Students] ~[x:PaginationCountdown] ~[Comment: Increments the pagination counter once per student.]


~([01]lastfirst)~[schoolname]

Current Homeroom: ~([01]home_room)
Next Grade: ~([01]SCHED_NEXTYEARGRADE)
Status: ~(decode;~(enroll_status);0;Current;-1;Pre-Registered)
Address:
~([01]street)
~([01]city), ~([01]state) ~([01]zip)


~[tlist_sql; SELECT * from (select ' ' reqout from schedulerequests sr inner join courses c on upper(sr.coursenumber) = upper(c.course_number) inner join students s on sr.studentid = s.id and s.id=~(id) where sr.yearid=~(schedule.yearidfuture) and sr.globalalternatecourse = 0 ~[if.prefschool.crrept_reqsort=1]order by upper(c.course_name),c.credit_hours desc[else]order by c.credit_hours desc,upper(c.course_name)[/if]) union all select '' reqout from dual union all select '' reqout from schedulerequests sr inner join courses c on upper(sr.coursenumber) = upper(c.course_number) inner join students s on sr.studentid = s.id and s.id=~(id) where sr.yearid=~(schedule.yearidfuture) and sr.globalalternatecourse = 0] ~(reqout;t)[/tlist_sql]
Requests~[if.~[prefschool:crrept_showalt]=1]: Regular[/if]
Course Number Course Name Credit Hours
'||c.course_number||' '||c.course_name||' '||c.credit_hours||'
~[if.~[prefschool:crrept_showalt]=1]Regular [/if]Credit Hours Requested'||chr(58)||' '||sum(c.credit_hours)||'

~[if#1.~[prefschool:crrept_showalt]=1]
~[tlist_sql; SELECT * from (select '' reqout from schedulerequests sr inner join courses c on upper(sr.coursenumber) = upper(c.course_number) inner join students s on sr.studentid = s.id and s.id=~(id) where sr.yearid=~(schedule.yearidfuture) and sr.globalalternatecourse=1 ~[if.prefschool.crrept_reqsort=1]order by upper(c.course_name),c.credit_hours desc[else]order by c.credit_hours desc,upper(c.course_name)[/if] ) union all select '' reqout from dual union all select '' reqout from schedulerequests sr inner join courses c on upper(sr.coursenumber) = upper(c.course_number) inner join students s on sr.studentid = s.id and s.id=~(id) where sr.yearid=~(schedule.yearidfuture) and sr.globalalternatecourse=1] ~(reqout;t)[/tlist_sql]
Requests: Alternate
Course Number Course Name Credit Hours
'||c.course_number||' '||c.course_name||' '||c.credit_hours||'
Alternate Credit Hours Requested'||chr(58)||' '||sum(c.credit_hours)||'

[/if#1]
~[prefschool:crrept_footer]


[between:Students] ~[if.Pagination]
~[x:PaginationCountdownReset] ~[Comment: Resets the countdown to the max number of students per page as set on the last named Reset] [else]


[/if] [/RepeatForEach:Students]