A - Click on the "Tables" on the tab control.

B - In the top part of the "Tables" tab, add the tables needed by the report.  For this report we need "CC" (Student Schedules), "Courses", "Teachers" and "Terms". You can add a table by selecting the table in the "PowerSchool Tables" list box and then clicking the "Add Table" command button or you can "double click" on the table name.

C - Click the "Show Relations" button for the "CC" table.

    1 - The first relation for each table must be how that table is related or linked to another table.
          One field in this table must be linked (related) to the corresponding field in another table.
          In the "Select Field" drop down list select the field "StudentID".
          The "Data Type" textbox is automatically populated.
          In the "Relationship" drop down list, pick "Equal".
          The "Field from table" radio button is already selected.
          In the "Table, Default, or Constant" drop down list select the "Students" table.
          The "Field" drop down should be automatically populated.
          If its not, select the field from the list.

    2 - In the "Select Field" drop down list, pick the field "Expression".
          The "Data Type" textbox is automatically populated.
          The conjunction drop down will automatically change to "AND".
          You can select "OR" if that's what your report requires. We need "AND" here.
          In the "Relationship" drop down list, pick "Equal".
          Click the "User Supplies At Runtime" radio button.
          Enter "1@" as the default value. This is equivalent to "Begins with 1".
          Type in "Enter Period to Print:" as the "Prompt" to appear at runtime.

          Note: Because of PowerSchool limitations, if there is more than one record that matches
                   the period for any student, you will only get the first record.

    3 - In the "Select Field" drop down list, pick the field "TermID".
          The "Data Type" textbox is automatically populated.
          The conjunction drop down will automatically change to "AND".
          You can select "OR" if that's what your report requires. We need "AND" here.
          In the "Relationship" drop down list, pick "Equal".
          Click the "User Supplies At Runtime" radio button.
          Enter "1201" as the default value.
          Type in "Enter Term to Print:" as the "Prompt" to appear at runtime.

          Note: Because of PowerSchool limitations, if there is more than one record that matches
                   the TermID for any student, you will only get the first record.
 
 

D - Click the "Show Relations" button for the "Courses" table.

    1 - The first relation for each table must be how that table is related or linked to another table.
          One field in this table must be linked (related) to the corresponding field in another table.
          In the "Select Field" drop down list select the field "Course_Number".
          The "Data Type" textbox is automatically populated.
          In the "Relationship" drop down list, pick "Equal".
          The "Field from table" radio button is already selected.
          In the "Table, Default, or Constant" drop down list select the "CC" table.
          The "Field" drop down should be automatically populated.
          If its not, select the field from the list.

E - Click the "Show Relations" button for the "Teachers" table.

    1 - The first relation for each table must be how that table is related or linked to another table.
          One field in this table must be linked (related) to the corresponding field in another table.
          In the "Select Field" drop down list select the field "ID".
          The "Data Type" textbox is automatically populated.
          In the "Relationship" drop down list, pick "Equal".
          The "Field from table" radio button is already selected.
          In the "Table, Default, or Constant" drop down list select the "CC" table.
          The "Field" drop down should be automatically populated.
          If its not, select the field from the list.
 
 

F - Click the "Show Relations" button for the "Terms" table.

    1 - The first relation for each table must be how that table is related or linked to another table.
          One field in this table must be linked (related) to the corresponding field in another table.
          In the "Select Field" drop down list select the field "ID".
          The "Data Type" textbox is automatically populated.
          In the "Relationship" drop down list, pick "Equal".
          The "Field from table" radio button is already selected.
          In the "Table, Default, or Constant" drop down list select the "CC" table.
          The "Field" drop down should be automatically populated.
          If its not, select the field from the list.