Letter Builder

PATH: Ad hoc Reporting > Letter Builder

The Letter Builder tool allows users to combine Ad hoc filters with Ad hoc reports to create specific letters based on filtered student data.

Letter Builder Editor

The following table describes each field and its functionality:



Saved Filters

This is a list of saved student-type filters created within the Letter Designer.

Saved Letters

This field contains all Ad hoc letters created within the Letter Designer.

Set Operation

If more than one filter is selected, this field determines how Infinite Campus combines the filters when reporting data. See the Filter Operations section below for more information.

Sort Options

Sort options are defined as follows:

  • Alpha - Data is sorted alphabetically by student last names.
  • Grade/Alpha - Data is sorted by grade level and then alphabetically by student last names.
  • Zip - Data is sorted by address zip code (used for bulk mail rates).
  • Teacher - Data is sorted by teacher.

Build Letter

Initiates generation of the letter.

Build a Letter

A calendar must be selected in the Campus toolbar in order to generate letters.

  1. Select which Saved Filter(s) to include within the letter.
  2. Select which Saved Letter to include in the letter. If the letter has a long description entered, this will display under the Saved Letters window. For more information about entering a long description, see the Letter Designer article.
  3. If more than one Saved Filter is selected, determine how the letter will filter data by selecting the Set Operation. For more information about this field, see the Filter Operations section below.
  4. Select the Sort Option.
  5. Click the Build Letters button. The letter will appear in a separate window in PDF format.

Filter Operations

When two or more Saved Filters (Ad hoc filters) are selected on the Letter Builder editor, users must determine how Infinite Campus will combine these filters when reporting data. Users must select one of two Set Operations:

Union Operation - This operation combines two or more filters by appending one to the other. An example of this would be all Baseball Team members and all 10th grade male students. The following diagram explains this union:

Union Operation

Intersection Operation - This operation is used to find data that one or more filters have in common. An example of this would be all baseball team members who are also 10th grade male students. The following diagram explains this union.

Intersection Operation