sqlFormLetters is a customization that uses SQL to help create the content of a form letter.  Form letters can be for either students or staff.  It is only available to site subscribers as part of the Site Subscription.

You can use sqlFormLetters to create a letter to send home to parents showing attendance, discipline information, report card data, or anything that requres SQL to pull the data.  It can also be used by admins to print a page of data per student as there are page breaks by students when the output is printed.  For example, if a nurse wants to print a shot report per student, one could use sql to retrieve the information and sqlFormLetters could be used to print them. 

You can also build letters based on staff data, such as lunch transactions per staff member or information about a teacher's set of courses.  A teacher portal version is also included - teachers cannot edit any reports, but they can run reports you give them access from the admin area. 

Below are some of the benefits to using sqlFormLetters:

  • It's laid out in a similar manner as sqlReports, so if you're familiar with sqlReports, you'll be familiar with it as well.
  • You can create letters not possible in legacy reports or ReportWorks due to the fact sql is needed to get the data.
  • One can use custom letter templates and have letters with multiple sql tables, charts, or multi-series charts.
  • Letters can be based on either student data or staff data, and use a wide range of codes and parameters.
  • There's a teacher version included - teachers could run letters for all their students on just ones in a specific section.

Following are some screenshots of sqlFormLetters - they were created from fictional data.  The sqlFormLetters layout is similar to sqlReports - one can create reports, limit access, and create new letters or import letters:


An admin gives each letter basic information and chooses which security groups can run it.  Custom letter templates can also be used - a file resides on the server and it can use information from the letter setup, including run access, header and footer text, and parameters:


Header and footer text is saved with each letter, with a the ability to use field references, special commands, and some DAT codes:


The output of the letter is based on sql and can be either a data table or a chart.  PS parameters and sqlFormLetters parameters can be used in the sql:


Parameters are used much the same way as in sqlReports - they can be text entry, use calendars, or use drop-downs:


When an admin runs the letter, the parameters appear along with letter options:


When a teacher runs a letter, they also see any parameters, and have a drop-down to print for either all their students or they can choose one of their sections and print the letter for it:


sqlFormLetters FAQ

Do I need to be running sqlReports to use it?

No - it's a customization that's independent of sqlReports.


Back to the Overviews Page