1,208
edits
Changes
→sqlReports Examples
* [[Media:Student email missing.txt.zip|Student Email Missing]] - Lists students from the grade levels specified by the user who do not have an email entered in the stock student email field.
* [[Media:StudentRequestTally.txt.zip|Student Request Tally]] - A near clone of the built-in "Student Request Tally" found in PowerScheduler, but with filters and the ability to make the filtered results the current student selection. For example, filter to students with 0 requests and make them the current selection.
* [[Media:AllCourseRequestWithEmail.txt.zip|All Course Requests with Email]] - Shared by Larry Steinke. Lists all course requests for the specified yearid along with the student email. Helpful to answer the question "How can I send an email to all the kids who are going to take ___ next year?"
* [[Media:SqlReport mastersched gradecount.txt.zip|Master Schedule with Grade Counts]] - Reports master schedule data for the current term(s), with class size, but also broken down by grade level. Useful for finding teachers who have just seniors, or juniors, etc. If you set a grade level to "No", it will NOT include any sections that have any students in that grade level.
**For example, to find sections with ONLY seniors, set 9th, 10th and 11th to "No" and Seniors to "Yes".
