Report Structure

On this page:

Knowing how a report is structured will help you understand how to set up a report. All parts of a report are not used in every report, but you should know what each part does. In most cases, you decide which parts to include on the final report.

Report Listings

PowerSchool pulls this report data according to your specifications. Report listings are also known as schedule listings.

Title

This title appears at the top of the final report. It should be descriptive but brief.

Header

This information appears above the report listings. It can be an opening to a letter or a description of the data to follow.

This information appears below the report listings. It can be a closure to the report or instructions on how to proceed.

Body/Statement

This text appears on the report. It can be placed above or below the report listings.

Database Extensions

Any database extensions created in PowerSchool are available to use on reports. For more information, see Database Extensions.

HTML Tags

HTML stands for hypertext mark-up language, which is most often used to create Web pages. Because PowerSchool is a Web-based system, some HTML is also used to format PowerSchool reports. HTML tags give special characteristics to text in your reports. You can employ HTML tags in a PowerSchool report to center, bold, or italicize text. The following are a few examples of commonly used HTML tags:

  • <b> = bold text
  • <br> = inserts a line break
  • <p> = paragraph break; inserts a space between reports

PowerSchool Data Codes

PowerSchool data codes insert data into reports through a merge process similar to that used in word processing applications. You use the data codes to tell PowerSchool what fields you want in the report. PowerSchool pulls the data from those fields for the selected student or group and inserts that data into the report. While HTML tags are programming codes, PowerSchool data codes are specific to PowerSchool and are used to merge data from the PowerSchool database. The following are some common PowerSchool data codes:

  • ^(*credit_hours) = number of cumulative credit hours the student has earned
  • ^(*gpa;Q3) = student's GPA for third quarter
  • ^(grade_level) = student's grade level
  • ^(He/She) = correct pronoun for each student based on the Gender field
  • ^(he/she) = correct pronoun for each student based on the Gender field
  • ^(him/her) = correct pronoun for each student based on the Gender field
  • ^(His/Her) = correct pronoun for each student based on the Gender field
  • ^(his/her) = correct pronoun for each student based on the Gender field
  • ^(lastfirst) = student's last name, first name
  • ^(schoolname) = name of the school
  • ^(son/daughter) = correct pronoun for each student based on the Gender field
  • ^(yearname) = school year
  • ^[time] = prints the current time

Note: The asterisk (*) is used to indicate that data must be calculated.

For more information about data codes, see PowerSource.