The Summary of Students report provides totals for students, sorted by a variety of demographic parameters. The report can be run at the district or school level. All reports provide overall totals as well as totals by gender. Pre-enrolled students are included in the reports that sort by Next Grade (STU.NG). At the school level, when sorted by Next School, feeder schools can be selected.


Filter Reports by "Summary of Students" or navigate to Reports > Student Data > Summary of Students.


At the district level, schools can be selected.



At the district level, the totals are provided by district for any schools that are selected from the list of schools: 


At the district level, the report can be run to print a separate page for each school selected by choosing the option to Print by School: 


At the school and district level, the report totals students using the following options:


Program and Grade - The report provides totals for active students (STU.TG is blank) based on their program (STU.SP) and grade (STU.GR). 


The same data can be queried: 


TOTAL STU GR SP SX BY GR SP SX IF TG = " "


Program and Ethnicity/Race - The report provides totals for active students (STU.TG is blank) based on their program (STU.SP), their ethnicity code (STU.ETH), and their primary race code (STU.RC1).


TOTAL STU SP ETH RC1 SX BY SP ETH RC1 SX IF TG = " "




Program and Track - The report provides totals for active students (STU.TG is blank) based on their program (STU.SP) and track (STU.TR).


TOTAL STU SP TR SX BY SP TR SX IF TG = " "




Grade - The report provides totals for active students (STU.TG is blank) based on their grade (STU.GR).


TOTAL STU GR SX BY GR SX IF TG = " "


Ethnicity/Race - The report provides totals for active students (STU.TG is blank) based on their ethnicity code (STU.ETH) and their primary race code (STU.RC1).


TOTAL STU ETH RC1 SX BY ETH RC1 SX IF TG = " "




Track - The report provides totals for active students (STU.TG is blank) based on their track (STU.TR).


TOTAL STU TR SX BY TR SX IF TG = " "




Program and Next Grade - The report provides totals for active students (STU.TG is blank) and pre-enrolled students (STU.TG = '*') based on their program (STU.SP) and next grade (STU.NG). 


TOTAL STU SP NG SX BY SP NG SX IF NG < 13 AND ( TG = " " OR TG = "*" )



Next Grade - The report provides totals for active students (STU.TG is blank) and pre-enrolled students (STU.TG = '*') based on their next grade (STU.NG). 


TOTAL STU NG SX BY NG SX IF NG < 13 AND ( TG = " " OR TG = "*" )



Prog, Next Grade, and Next School - The report provides totals for active students (STU.TG is blank) and pre-enrolled students (STU.TG = '*') based on their program (STU.SP), next grade (STU.NG), and next school (STU.NS). At the school level, feeder schools can be individually selected to appear on the report.