sqlFormLetters Overview

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 Full Site Subscription.  There is a free "lite" version available here.

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:

bullet blue alt 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.
bullet blue alt You can create letters not possible in legacy reports or ReportWorks due to the fact sql is needed to get the data.
bullet blue alt One can use custom letter templates and have letters with multiple sql tables, charts, or multi-series charts.
bullet blue alt Letters can be based on either student data or staff data, and use a wide range of codes and parameters.
bullet blue alt 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 in a sample database provided by PowerSchool.  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 on a specific version of PowerSchool to use it?

Yes - you must be on PS 10 or higher.

Do I need to be running sqlReports to use it?

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


Back to sqlReports Subscription Overview