Custom Reports

Custom Reports

Report Exporting

List Students

    1. Select a list of selected students. On the start page, search for and select a group of students. A list of students appears in the Current Student Selection section. For more information, see Select a Group of Students.Screen Shot 2016-08-16 at 1.41.16 PM
    2. Click the [Select Function] arrow. The Group Functions pop­up menu appears. Under Export, choose List Students. The List Students page appears.
      Note: Alternatively, if you have a current selection of students, you can choose Special
    3. Functions under Functions in the main menu and then click Groups Functions.Screen Shot 2016-08-16 at 1.41.19 PMReport Title: Enter a title for the report.
      Col.: Numerical representation of the number of items that will appear on the list.
      Field Name: Enter the name of the field.To insert a PowerSchool field into this field:
    4. Click Fields to view a list of PowerSchool fields. The Fields pop­up appears.
    5. ­ To narrow the list of fields, enter one of more search terms in the Filter field. Otherwise, leave blank.
    6. ­ Click the field you want to add. The Fields pop­up closes and the selected field appears.
    7. Column Title: Enter the column title. This may or may not be the same as the field name. For example, to display birthdays on the printed list, title the column as Birthday even though the field name is DOB.
    8. Select the Export Option to export it as text file that you can take to excel.
    9. List Students ­ offers you max 10 fields to take, which you can take by selecting the fields from the field tab and giving it a column name. Can export in Excel

Screen Shot 2016-08-16 at 1.41.26 PM

Quick Export

  1. Login to the PowerSchool /admin portal
  2. From the Start Page, select the desired students
  3. Select Quick Export from Functions, or Navigate to Start Page > Special Functions > Importing & Exporting > Quick Export
  4. Enter the fields you’d like to export, and how you’d like the records to be delimited. See an example below. More fields can be selected by clicking on the “Fields” tab below.Screen Shot 2016-08-16 at 1.41.31 PM
  5. Click Submit. It will save a text file which you can open in Excel.

DDE: Direct Database Export


  • List View: Provides an organized list of the current records in selection
  • Table View: Provides an organized table of the current records in selection
  • Table View Setup: Preferences for the view in table view

Screen Shot 2016-08-16 at 1.41.36 PM

Exporting Records

  1. From your start page click System under SetupScreen Shot 2016-08-16 at 1.41.41 PM
  2. Click Direct Database Export (DDE) under Data ManagementScreen Shot 2016-08-16 at 1.41.43 PM
  3. Select the table for which you would like to search for recordsScreen Shot 2016-08-16 at 1.41.46 PM
  4. Use the Search boxes to filter your records. Eg:Screen Shot 2016-08-16 at 1.41.51 PM
    Note: School IDs ­100 (ES); 200 (MS); 300 (HS) – Term ID ­ 2600( Full year); 2601 (Semester1); 2602 (Semester 2)Tables (used majorly): Students -­ for all student demographic information/ entry/exit. Attendance -­ Student attendance data.
  5. Use either the table or list view to verify that your selection of records is correct
  6. Click the link to Export Records
  7. Use the drop down to select fields from the table you are currently in
  8. In the box use the [Table name or Number] Field Name method to pull fields (this is when you are cross-referencing tables to pull fields)Screen Shot 2016-08-16 at 1.41.56 PM
  9. Fill out all other desired options for export on the Export Records page such as Field and Record Delimiter
  10. Click Submit to begin the export

AES Custom Reports

Generated by Main tech office. Incase of access to these, please raise a ticket and Anshu/Kshitij will assign appropriate access in reporting server.Screen Shot 2016-08-16 at 1.42.01 PM

System Reports

Inbuilt System reports in Power School about Attendance, Schedules. You can always click on the help link above to get more information about the reports.Screen Shot 2016-08-16 at 1.42.08 PM


Recent Posts
Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap.

Not readable? Change text. captcha txt

Start typing and press Enter to search

Screen Shot 2016-08-16 at 1.34.43 PM7
Copyright © 2021 AES All Rights Reserved