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 - click on the category name to view the letters

Attendance Uploaded
Student Attendance - Daily - daily attendance information for students, including attendance comments.  (screenshot) 12/27/2019
Student Attendance - Meeting - meeting attendance information for students, 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  
Low Current Grades - Percent Search - courses with current grades based on grade percent criteria entered by the user.  Grades come from the teacher's gradebook.  (screenshot) 12/27/2019
Low Current Grades Grade Search - courses with low current grades based on letter grade criteria entered by the user.  Grades come from the teacher's gradebook.  (screenshot) 12/27/2019
Low Stored Grades - 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 - health office visits for a student based on the date range entered by the user.  (screenshot) 12/27/2019
Student Immunization History - 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 - incidents for a student based on the date range entered by the user.  (screenshot) 12/27/2019
Log Entries  
Discipline Log Entries - 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