The following reports are for sqlFormLetters only - do not import them into sqlReports (sqlFormLetters has it's own import page) and do not use with sqlFormLetters Lite.

Some letters will require you to narrow the selection of students or staff before running.  For example, to avoid blank pages for students when running the Low Grades one, find students with low grades first by either using a sqlReport report that creates a current selection, or use the Search By Grades built-in function to create a current selection. 

The screenshots below are based on fictional data.  They are in color, but your letters will probably print in black and white.  When testing out the letters, run them for just a small selection of students or staff.  Use the print preview feature of your browser to view the output before sending the output to a printer.  Letters can look different in different browsers, so be sure to view them in the browser you or other admins will be using when printing the letter. 

sqlFormLetters

Attendance Uploaded
Student Attendance - Daily -Choose a student and enter a date range and see daily attendance information for that student, including attendance comments.  (screenshot) 12/27/2019
Student Attendance - Meeting - Choose a student and enter a date range and see meeting attendance information for that student, including attendance comments.  (screenshot) 12/27/2019
Student Attendance Totals Chart - Meeting - Meeting Attendance code totals for a student based on a date range.  (screenshot) 12/27/2019
Grades  
Current Grades - Creates a letter with just the courses with current grades based on letter grade criteria entered by the user.  Grades come from the teacher's gradebook.  (screenshot) 12/27/2019
Low Current Grades - Creates a letter with just the courses with low current grades based on grade percentage criteria entered by the user.  Grades come from the teacher's gradebook.  (screenshot) 12/27/2019
Low Stored Grades - Creates a letter with just the courses with low current grades based on criteria entered by the user.  Grades come from historical grades.  (screenshot) 12/27/2019
Health  
Health Office Visits - Report showing health office visits for a student based on the date range entered by the user.  (screenshot) 12/27/2019
Student Immunization History - Report showing immunzations for a student.  Shows six doses by default but that can be changed in the SQL.  (screenshot) 12/27/2019
Incident Management  
Incident Management Information - Report showing incidents for a student based on the date range entered by the user.  (screenshot) 12/27/2019
Log Entries  
Discipline Log Entries - Report showing log entries for a student based on the date range entered by the user.  (screenshot) 12/27/2019
Student Schedules  
Student Schedule - Basic information for a student schedule.  The SQL could be modified to pull information for specific terms.  (screenshot) 1/28/2020
Student Schedule Matrix - An example of a custom letter.  The output is similar to the student schedule matrix group function, but with additional information.  (screenshot) 1/28/2020

 

 

 

© 2008 - present, All Rights Reserved - Matt Freund and Freund Resources