Rules for Adding Linked Columns to a Report

Rules for "How to Display" (Part 2 of the Defined Linked Column Screen)

1. If the new table has only one record that can be linked in, then use the "If more than 1 row; Error out" option.   When this is appropriate: 
   • Linking the StudentContact2Summary table when Student is the Base table.
2. If the new table has multiple records for each row of the existing report, then use "Join" option.  When this is appropriate: 
   • Linking in the StudentScheduleCourse table when Student is the Base table.
   • Linking in the StudentGradeHistory table when Student is the Base table.
   • Linking in the Contact2 table when Student is the Base table.

Rules for Filters (Part 3 of the Defined Linked Column Screen)

1. If both the new table and existing list of Columns have a "School Year", you must add a filter "SchoolYear" =  "SchoolYear"
2. If both the new table and the existing list of Columns has a "SchoolCode", you must add a filter "SchoolCode" = "SchoolCode"
3. If both the new table and existing list of Columns have a "StudentID" column (or any variation of that spelling: studentid, StudentID, StudentId, etc.), you must add a "Student ID" = "Student ID" filter.
4. If both the new table and the existing list of Columns have a "Course Code" field, you probably need a "CourseCode" = "CourseCode" filter.
5. If both the new table and the existing list of Columns have a "Course Section" field, you probably need a "CourseSection" = "CourseSection" filter.