List Students - Use this command in a Field Name box to get the homeroom teacher name for your list or export:  *period_info;HR(A);teacher_name

Example using this command in List Students:

Report with Gridlines Result:  

Export Result:  

List Students Notes:  

• You can replace the HR in the command with any period name your school uses. (Examples:  1, 2, 3, 4, 5, 6, 7, 8, AD, DP, MW, TT).
• This data can be sorted on specified fields prior to exporting or printing.
• You can’t sort by a command, so you would not be able to sort by Teacher Name 
• The column titles are the ones you specified.

Quick Export  – Use this command to get the homeroom teacher name:  *period_info;HR(A);Teacher_name

Example in Quick Export:

Result: 

Quick Export Notes:  

• You can replace the HR in the command with any period name your school uses. (Examples:  1, 2, 3, 4, 5, 6, 7, 8, AD, DP, MW, TT)
• You can sort the data once it is in Excel, this includes the teacher name.
• The column titles are the field names that were exported.

List Builder – Click and drag the Teacher_HR / Rm to the Report Columns line, add additional fields as desired, place the fields in any order, sort the fields selected in the report columns, click Build List.  Report Preview appears lower on the page.  

Click “Export” to create an export file.  Select Open with Microsoft Excel, OK

(NOTE:  depending on the amount of data, it may take a minute or two to convert and appear in Excell.)

Export to Excel Results: