Misc - Students Reports

The following is a list of reports that can be imported into sqlReports, version 4.3 or higher.  Clicking on the report name will take you to the page with the coding to import.  The screenshots were created from fictional data in a sample database provided by PowerSchool.  Reports with uploaded dates prior to 9/1/16 were originally uploaded to sqlreports4.com.

Admin Portal Reports

Report Name / Description Created By Uploaded

 free
Alerts List
Shows students with built-in alerts (discipline, guardian, medical, other). Hovering over the icon shows the alert text. Can be run for the entire student body or just the current selection. (screenshot)
  Matt Freund 8/23/14

 
Birthday Search
Shows birthdays for the student body.  Admin can search by month and/or grade level, or search by month after the report is run. (screenshot)
  Matt Freund 11/10/14

 
Contact Search
An admin enters a name and any active student with the name in one of the core contact fields is listed.  Fields with the sequence are highlighted. (screenshot)
  Matt Freund 2/8/16

 
Current Age of Students
Shows the current age of the student body or the current selection of students.  Report can be filtered by age and/or grade level. (screenshot)
  Matt Freund 11/10/14

 
Family Members
A report that shows active students at the current school who have other students in the district linked to them via the Family student screen.  (screenshot)
  Matt Freund 11/7/15

 
Honor Roll Report
Choose a term and view those students who have made the honor roll.  Runs for the current school based on the current year.  (screenshot)
  Matt Freund 12/1/14

 
Older Than a Specific Age
Enter an age, for example, 17, and the report shows those students older than that age.  (screenshot)
  Matt Freund 8/23/14

 free
Phone Number Search
An admin enters a number sequence and any active student with the sequence in the home_phone, motherdayphone, or fatherdayphone field is listed.  Phone numbers with the sequence are highlighted. (screenshot)
  Matt Freund 1/29/16

 
Phone Number Search (migrated fields)
An admin enters a number sequence and any active student with the sequence in the home_phone, motherdayphone, or fatherdayphone field is listed. Only works if custom core fields have been migrated.  (screenshot)
  Matt Freund 1/29/16

 
Same Mailing Street and Zip
Report that shows students grouped together that have the same mailing street and zip.  Handy for making a current selection of one person per mailing address.  (screenshot)
  Matt Freund 11/7/15

 
Student Email Addresses
Report that shows the email address information entered into the core student email address field. (screenshot)
  Matt Freund 11/8/16

 
Students Not in the Current Selection
Report will list out the students not in the current selection, regardless of how the current selection was created (searches, reports, etc.). (screenshot)
  Matt Freund 3/29/15

 
Upcoming Birthdays
An admin enters how many days in the future to search, and students in the student body with birthdays within that number of days appear on the report. (screenshot)
  Matt Freund 11/10/14

 
Who Lives on the Street Search
An admin can enter the part of a street name for up to two different streets and find out who lives on the street(s). (screenshot)
  Matt Freund 1/29/16

 free
Weekly Grid - Current Selection of Students
An admin can make a current selection of students - either in district office or at a school - and print off a roster of those students with the days of the week as column headings. (screenshot)
  Matt Freund 9/14/16

 
Weekly Grid - Current Selection - Any Week
An admin can make a current selection of students - either in district office or at a school - and print off a roster of those students with the days of the week as column headings and the actual dates underneath. (screenshot)
  Matt Freund 9/15/16

Teacher Portal Reports

Report Name / Description Created By Uploaded

 
Student Directory (PST)
Teachers can view a directory of students at the current school and see which classes the students are currently in.  Teachers can search by grade level or name before running the report, and filter the results after running the report.  (screenshot)
  Matt Freund 1/14/16