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:

Turn on printing of backgrounds. Shading and colorations in this reports are all "backgrounds", and not printing backgrounds will generally lead to illegible printouts.
Turn off printing of "header" information in your browser settings. If this is not off, each page printed will include (depending on browser) the URL of this page, a page number, and a time stamp. These are generally not desired for this report.
It is advised that you use your browser's "Print Preview" feature to confirm that the output is correct prior to sending to the printer. You may adjust text size using the text font size controls of your browser. You may also control landscape/portrait printing via your browser settings. Doing so may fix cases where table cells end up spanning page breaks or where the report appears too small in the final output

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.

~([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]