Objects on an Object Report

On this page:

You can create many types of objects to include on an object report: text objects, line objects, box objects, circle objects, transcript objects, standards objects, fee list objects, picture objects, and sequence objects. You can create multiple objects on each object report and create the objects in any order. However, it is ideal for the objects to be listed on the Object Report page in order from top to bottom and from left to right. For example, give a logo placed in the upper-left corner of the report the label of "A Logo," then give a horizontal line placed in the middle of the page the label "B line." In this example, the picture object for the logo would be listed first, followed by the line object.

To enhance the appearance of the object report, you can format many objects. Prior to adding objects to an object report, you must first create set up the object report parameters. For more information about creating a new object report or editing an existing object report, see Object Reports.

When you create an object, you define where you want it to appear on a page and on which page of the report you want it to appear. To do this, define the coordinates of each object you create in inches on an X (horizontal) and Y (vertical) axis. You can use a ruler and a piece of paper to determine the coordinates of each object you create.

Use the Print Reports option on the Group Functions page to print a custom report for the selected students. For information about creating reports, see Custom Reports. For information about printing an object report or any type of report, see Run, Print, and Save Reports.

Text Objects

Text objects are boxes that contain text. Specify if you want the box to be framed or unframed. Within a text object, you can include two types of text:

  • Constant text, such as a title (for example, Official Transcript). The same title appears for all students.
  • Variable text, such as PowerSchool field names or codes (for example, mailing_address). Different information appears for different students.

For example, you can include the constant text Name: just before variable text first_name and last_name fields.

Create Text Objects

  1. On the start page, choose System Reports under Reports in the main menu. 
  2. Click the Setup tab. 
  3. Click Object Reports
  4. Click the name of the object report to which you want to add this object. 
  5. Click Text
  6. Use the following table to enter information in the fields:

    Field

    Description

    Object Label

    Enter a name for the object.

    Text

    Enter an unlimited amount of text to include in the text object. In addition to standard text, you can include HTML tags, PowerSchool fields and PowerSchool data codes.

    Note: Text does not automatically wrap to the next line. To insert a break, use the HTML <p> tag.

    To insert a PowerSchool field into this field:

    1. Click Fields to view a list of PowerSchool fields. The Fields pop-up appears.
    2. To narrow the list of fields, enter one of more search terms in the Filter field. Otherwise, leave blank.
    3. Click the field you want to add. The Fields pop-up closes and the selected field appears.

    For example, to include each student's name on the report and center the information, create the following text object: <center>^(first_name) ^(last_name)</center>

    To include a tab, indicate the tab type and the number of inches from the left side of the page. Tab types include:

    • <tabc> for a centered tab
    • <tabr> for a right-justified tab
    • <tabl> for a left-justified tab
    • <tabd> for a decimal-aligned tab

    Create tab leaders by using characters such as the underscore (_) for a solid line or a period (.) for a dotted line. Include tab leader characters at the end of the tab tag.

    For example, <tabd 3.5 _> aligns a list of monetary amounts by their decimal places with a solid tab leader at 3.5 inches from the left side of the page.

    To include a data code, use the following format: ^(*data code)

    For example, to include each student's cumulative GPA, enter: ^(*gpa)

    Note: If you are adding database extension fields, enter the extension field name using the format [extension name].[fieldname].

    Note: After you save this object, the system changes the carets (^) in front of the field names and data codes to tildes (~).

    Position

    Enter the number of inches from the left margin that the text object should appear horizontally (X) and vertically (Y).

    For example, enter 4.25 in the X field and 1 in the Y field to place the object horizontally centered on an 8.5-inch page and vertically one inch from the top of the page.

    Max Width

    Enter the maximum number of inches wide you want this text object to print (optional).

    To allow the text object to print the entire width of the page, enter 0.

    If you do not define a maximum width, the system defaults to the page width.

    Max Height

    Enter the maximum number of inches high you want this text object to print.

    To allow the text object to print the entire length of the page, enter 0.

    Font

    Choose the font of the text from the pop-up menu. The system setup determines the default font. Select the style of the font from the second pop-up menu.

    Style

    Select any combination of these checkboxes to determine any additional styles for the text in the Text field:

    • Bold
    • Italic
    • Underline

    Size

    Enter the font size of the text in points. One point equals 1/72 of an inch.

    Line Height

    Enter the height of the line in points. One point equals 1/72 of an inch. The line height determines the amount of space for each line of text in the object.

    For example, if you increase the line height, you create more space or padding between each line of text.

    Color

    Enter the name of the color in which you want all text in the text object to print.

    To view a list of color names, click Color. A color palette appears. Copy the name of the color you want and paste it into the Color field.

    If you want the text to be black, leave this field blank.

    Tint

    To adjust the tint of the color of the text, enter a percentage.

    Otherwise, leave this field blank.

    Rotation

    Enter the number of degrees to rotate the text object on the page of the report.

    Frame Width

    To have the report surround the text object with a line frame, enter the number of points wide you want the frame to print. One point equals 1/72 of an inch.

    If you do not want the text object to print with a frame, leave this field blank.

    Frame Padding

    If you entered a frame width, enter the amount of space in points between the text object and the frame. One point equals 1/72 of an inch.

    For example, to have the text object print in the center of the frame, you need to adjust the padding.

    Frame Radius

    If you entered a frame width, enter a number of inches to print the frame with rounded corners. The higher the number, the more rounded the frame.

    Special

    Select the Move to next record after printing this text checkbox if this text object is the last object the report prints before printing a new record. Deselect the checkbox if this is the last object on the page (the last record to be printed), such as a footer.

    Note: If the text object is a footer or any other object that should be printed last, deselect the checkbox. Also, the order of objects is determined by the object layer (lower layers are listed first) and alphabetically by object name. By either placing the footer object at a lower layer or altering its name so that it falls before other objects that may repeat (such as a list of students), the report should print correctly.

    Page

    Do one of the following:

    • Enter the page number of the report on which you want this text object to print.
    • Select the Display this object on all pages checkbox to have this text object print on all pages of the report. Note the Page field appears as All.

    Note: As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered prior to PowerSchool 11.0.4.0, that value will be honored and the text object will continue to appear on the first page of the report.

    Layer

    If you want this object to appear behind or in front of another object, choose the layer placement from the pop-up menu. Choose the highest number to place the object in front of all other layers.

  7. Click Submit to save the text object.  If the text object does not print correctly, edit it by clicking the object name on the Object Report page and repeating the procedure.
    Note: For example, assume a student does not have a Social Security number. By default, the text box prints one blank space, then prints the birth date text directly next to it (SS# BIRTH DATE: 9/2/1984). If this causes alignment concerns in your text box, you can use the <TABTO (inches)> HTML tag in your text object. Within the tag, before the text you want to print in a specific space, enter the number of inches from the left margin that you want to print the text. For example, if a student does not have a Social Security number, but you still want the birth date to print 2.25 inches from the left margin, you can enter: SS# ^(ssn)<TABTO 2.25>^BIRTH DATE: ^(dob).

Line Objects

Create line objects to include horizontal and vertical lines on your object report. Lines can separate information and make it easier to read. For each line you create, you define the location, thickness, and number of times it appears.

Define line objects as if they were printing on a graph. For each line, you define the X and Y coordinates in inches. The X coordinate is the horizontal point from the left margin at which you want the line to print. The Y coordinate is the vertical point from the top margin at which you want the line to print.

Note: If the line is horizontal, the number you enter for the starting and ending Y points are the same. If the line is vertical, the number you enter for the starting and ending X points are the same.

Create Line Objects

  1. On the start page, choose System Reports under Reports in the main menu. 
  2. Click the Setup tab. 
  3. Click Object Reports
  4. Click the name of the object report to which you want to add this object. 
  5. Click Line
  6. Use the following table to enter information in the fields:

    Field

    Description

    Object Label

    Enter a name for the line object.

    Starting point (X,Y)

    Enter the number of inches on the page to indicate the point at which you want the report to start the line horizontally (X) and vertically (Y).

    Ending point (X,Y)

    Enter the number of inches on the page to indicate the point at which you want the report to end the line horizontally (X) and vertically (Y).

    Width

    Enter the width of the line in pixels. A pixel is a single point in a graphic image.

    Color

    Enter the name of the color in which you want the line to print.

    To view a list of color names, click Color. A color palette appears. Copy the name of the color you want and paste it into the Color field.

    If you want the line to be black, leave this field blank.

    Tint

    To tint the color of the line, enter a percentage. The higher the number, the darker the tint.

    Otherwise, leave this field blank.

    Repeat

    If you want the line to print more than one time, enter information in the following fields:

    • Times to Repeat
    • Horizontal Change (enter the number of inches you want between each line horizontally)
    • Vertical Change (enter the number of inches you want between each line vertically)

    Otherwise, leave these fields blank.

    Line Style

    Select one of the options to indicate the style of the line.

    Page

    Do one of the following:

    • Enter the page number of the report on which you want this line object to print.
    • Select the Display this object on all pages checkbox to have this line object print on all pages of the report. Note the Page field appears as All.

    Note: As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered prior to PowerSchool 11.0.4.0, that value will be honored and the line object will continue to appear on the first page of the report.

    Layer

    If you want this object to appear behind or in front of another object, choose the layer placement from the pop-up menu. Choose the highest number to place the object in front of all other layers.

  7. Click Submit

Box Objects

Create box objects to include on your object report. These objects frame or shade information on the report.

Create Box Objects

  1. On the start page, choose System Reports under Reports in the main menu. 
  2. Click the Setup tab. 
  3. Click Object Reports
  4. Click the name of the object report to which you want to add this object. 
  5. Click Box
  6. Use the following table to enter information in the fields:

    Field

    Description

    Object Label

    Enter a name for the box object.

    Coordinates

    To determine where the box prints on the page, enter the number of inches from the left, top, right, and bottom margins you want the box to print.

    Line width (frame)

    To print a frame around the box, define the width of the line and the percentage the line is shaded in points. One point equals 1/72 of an inch.

    Line Color

    Enter the name of the color in which you want the line that prints around the box to print.

    To view a list of color names, click Color. A color palette appears. Copy the name of the color you want and paste it into the Color field.

    If you want the line to be black, leave this field blank.

    Line Tint

    To tint the color of the line, enter a percentage.

    Otherwise, leave this field blank.

    Corner Radius

    Enter a number to indicate how round you want the corners of the box to be in inches. The greater the number, the rounder the corners.

    Fill Color

    To shade or color inside the box, enter the name of the color. To view a list of color names, click Color. A color palette appears. Copy the name of the color you want and paste it into the Color field.

    To view a list of color names, click the field name Color.

    Fill Tint

    To tint the fill color of the box, enter a percentage.

    Otherwise, leave this field blank.

    Repeat

    If you want the box to print repeatedly, define information in the following fields:

    • Times to Repeat
    • Horizontal Change (enter the number of inches you want between each box horizontally)
    • Vertical Change (enter the number of inches you want between each box vertically)

    Rotation

    To rotate the box on the report, enter the number of degrees you want it to rotate.

    Line Style

    Select one of the options to indicate the style of the line that surrounds the box object.

    Page

    Do one of the following:

    • Enter the page number of the report on which you want this box object to print.
    • Select the Display this object on all pages checkbox to have this box object print on all pages of the report. Note the Page field appears as All.

    Note: As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered prior to PowerSchool 11.0.4.0, that value will be honored and the box object will continue to appear on the first page of the report.

    Layer

    If you want this object to appear behind or in front of another object, choose the layer placement from the pop-up menu. Choose the highest number to place the object in front of all other layers.

  7. Click Submit. T

Circle Objects

Create circle objects to include on your object report. These objects can encircle information or images on the report.

Create Circle Objects

  1. On the start page, choose System Reports under Reports in the main menu.
  2. Click the Setup tab. 
  3. Click Object Reports
  4. Click the name of the object report to which you want to add this object. 
  5. Click Circle
  6. Use the following table to enter information in the fields:

    Field

    Description

    Object Label

    Enter a name for the circle object.

    Center Point

    Enter the number of inches from the left margin you want the center point of the circle to print horizontally (X) and vertically (Y).

    Radius

    Enter the circle's radius, or the distance from the center of the circle to its edge.

    Line Width

    To print a frame around the circle, define the width of the line.

    Line Color

    Enter the name of the color in which you want the line around the circle to print. To view a list of color names, click Color.

    If you want the line to be black, leave this field blank.

    Line Tint

    To tint the line, enter a percentage.

    Otherwise, leave this field blank.

    Fill Color

    To shade or color inside the circle, enter the name of the color. To view a list of color names, click Color.

    Fill Tint

    To tint the fill color of the circle, enter a percentage.

    Otherwise, leave this field blank.

    Starburst Points

    To create a starburst circle, enter the number of points on the star. For example, you might create a starburst as a "seal" for a perfect attendance certificate.

    Starburst Radius

    If you entered starburst points, enter the radius of the starburst in inches.

    Repeat

    If you want the circle to print repeatedly, define information in the following fields:

    • Times to Repeat
    • Horizontal Change (enter the number of inches you want between each circle horizontally)
    • Vertical Change (enter the number of inches you want between each circle vertically)

    Rotation

    To rotate the circle on the report, enter the number of degrees you want it to rotate.

    Line Style

    Select one of the options to indicate the style of the line that surrounds the circle object.

    Page

    Do one of the following:

    • Enter the page number of the report on which you want this circle object to print.
    • Select the Display this object on all pages checkbox to have this circle object print on all pages of the report. Note the Page field appears as All.

    Note: As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered prior to PowerSchool 11.0.4.0, that value will be honored and the circle object will continue to appear on the first page of the report.

    Layer

    If you want this object to appear behind or in front of another object, choose the layer placement from the pop-up menu.

  7. Click Submit to save the circle object.

Transcript Objects

Create transcript objects to include a list of student historical grades and the courses in which students received the grades on your object report. By default, within a transcript object, the system lists historical grade information in chronological order and displays the most recent first.

Note: The option to create Legacy Transcript List objects is no longer available. However, existing legacy transcript list objects may be used for object reports. Use the new Transcript object for object reports going forward. To create new transcript objects, use Transcript, which is also available on the Object Reports page.

Note: If a course appears but is not desired on a report card or transcript-based object report, change the course preferences to Exclude on Report Cards/Transcripts. For more information, see New Courses.

Add a Transcript Object

  1. On the start page, choose System Reports under Reports in the main menu.
  2. Click the Setup tab. 
  3. Click Object Reports
  4. Click the name of the object report to which you want to add a transcript object. 
  5. Under New Object, click Transcript

  6. Use the following table to enter information in the fields:

    Field

    Description

    Define the box that contains the transcript course listing

    Enter the coordinates of the box in which the transcript information prints. Use inches as the unit of measurement.

    Determine how many inches from the top left of the page you want the transcript object to print. Indicate the left, top, right, and bottom coordinates of the transcript object.

    If listing overflows this object, start a new column with these margins

    If the listing requires more room on the report, enter the coordinates of the box in which the overflow transcript information prints. Use inches as the unit of measurement.

    Determine how many inches from the top left of the page you want the overflow transcript object to print. Indicate the left, top, right, and bottom coordinates of the transcript object.

    Term/school name font

    Choose the font in which the term and school information prints from the pop-up menu.

    Size, line height, style

    In the first field, enter the size of the font.

    In the second field, enter the height of each line in the object in points. One point equals 1/72 of an inch. The height determines the space between each line in the transcript. Select any combination of these checkboxes to determine any additional styles for the text:

    • Bold
    • Italic
    • Underline

    Term/school displays

    Choose from the pop-up menu whether to print the year, the school name, or both.

    Course listing font

    Choose from the pop-up menu the font in which the transcript information prints.

    Size, line height, style

    In the first field, enter the size of the font.

    In the second field, enter the height of each line in the object. One point equals 1/72 of an inch. The height determines the space between each line in the transcript. Select any combination of these checkboxes to determine any additional styles for the text:

    • Bold
    • Italic
    • Underline

    Cell padding

    Enter a number, in points, to determine the distance between the horizontal and vertical borders of the cell and its contents. One point equals 1/72 of an inch.

    Columns

    Specify the following for each column:

    In the Term field, enter the store codes (terms) you want to include in the transcript. The report prints historical grade information for only the term columns you define, such as S1 and S2.

    From the Field pop-up menu, select one of the following fields to include in the column:

    • Blank
    • Course Name
    • Course Number
    • Total Earned Credit and enter the format in which you want total earned credit to print in the Other Field/Text/Format field.
    • Letter Grade
    • Percent and enter the format in which you want percent to print in the Other Field/Text/Format field.
    • Citizenship
    • Earned Credit Hours and enter the format in which you want credit hours to print in the Other Field/Text/Format field.
    • Replaced Grade and enter the grade indicator you want to print in the Other Field/Text/Format field. To display an indicator for grades that are replaced, enter R. To display an indicator for grades that are suppressed because they were over the maximum credit hours for the course, enter M. Use a comma to separate multiple grade indicators. Do not include blank spaces between the comma and the grade indicator. For more information, see Repeated Course Grade Suppression Process.
    • Other and enter what you want to print in this column in the Other Field/Text/Format field.

    In the Other Field/Text/Format, enter any additional field or text you want to print next to each course. If you enter a PowerSchool field name, use the following format: ^(field name). For example, to include the possible credit a student could earn in each course, you can include the potential credit field.

    In the Width field, enter the width, in inches, of each term column.

    From the Align pop-up menu, select whether to align the data to the left, center, or right of the column.

    Include only historical grades from these grade levels

    To print historical grades for only certain grade levels in the transcript, enter the range of grade levels. Otherwise, leave these fields blank.

    Restrict to this credit type

    To print only courses with a specific credit type in this transcript object, enter the credit type. By default, within a transcript, the system sorts course information chronologically, displaying the most recent courses first. If you would rather sort the transcript by courses with the same credit type (courses within the same subject, such as English, Mathematics, and Science), enter the credit type here. Then, you can create a transcript object for each credit type. Otherwise, leave this field blank. When using this option to filter grades by credit type, the Transcript Object will only include historical grades that meet one of the following criteria:

    • The historical grade must have the same credit type in the [StoredGrades]Credit_Type field.
    • If an historical grade does not have a value in [StoredGrades]Credit_Type, The grade may still be included if the value in [StoredGrades]Course_Number is related to a course with the specified credit type.

    Exclude blank grades?

    Select the checkbox if you do not want to display courses for which the student did not receive a grade. For example, if your school schedules lunch as a course on student schedules, select the checkbox to not print lunch on student transcripts.

    Include current grades?

    Select the checkbox to include grades for the current term in the transcript. Otherwise, deselect the checkbox.

    Current school only?

    Select the checkbox to include grades for only the current school in the transcript. Otherwise, deselect the checkbox.

    Override "Exclude from Transcripts" Historical Grade setting?

    If the Exclude from Transcripts? setting on the Edit Stored Grades page is set to Exclude, you can use this checkbox to override that setting. Select the checkbox to include stored grades for the current term in the transcript. Otherwise, deselect the checkbox.

    Sort grades by

    Use this pop-up menu to determine the sort order of the grades in the transcript:

    • Course Name: Results descend by school year, then ascend by school name, and then ascend by course name.
    • Course Number: Results descend by school year, then ascend by school name, and then ascend by course number.
    • Credit Type: Results descend by school year, then ascend by school name, credit type, and course name.
    • Ascending by grade level, then course number: Results ascend by grade level, then school year, then school name, and then course number.

    Page

    Do one of the following:

    • Enter the page number of the report on which you want this transcript object to print.
    • Select the Display this object on all pages checkbox to have this transcript object print on all pages of the report. Note the Page field appears as All.

    Note: As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered prior to PowerSchool 11.0.4.0, that value will be honored and the transcript object will continue to appear on the first page of the report.

    Layer

    If you want this object to appear behind or in front of another object, choose the layer placement from the pop-up menu. Choose the highest number to place the object in front of all other layers.

  7. Click Submit

Edit a Transcript Object

  1. On the start page, choose System Reports under Reports in the main menu.
  2. Click the Setup tab. 
  3. Click Object Reports
  4. Click the name of the object report for which you want to edit a transcript object. 
  5. In the Object Type column, click Transcript of the transcript object you want to edit. 

  6. Edit information as needed. 
  7. Click Submit

Delete a Transcript Object

  1. On the start page, choose System Reports under Reports in the main menu.
  2. Click the Setup tab. 
  3. Click Object Reports.
  4. Click the name of the object report for which you want to delete a transcript object. 
  5. In the Object Type column, click Transcript of the transcript object you want to delete. 

  6. Click Delete.
  7. Click Confirm Delete

Fee List Objects

Include fee list objects on object reports. For example, include a fee list object to display course fee information per student.

Note: Fee search codes are designed for searches only. For more information, see Search for Students by Fees/Transactions.

Use Fee List Objects

  1. On the start page, choose System Reports under Reports in the main menu. 
  2. Click the Setup tab. 
  3. Click Object Reports
  4. Click the name of the object report to which you want to add this object. 
  5. Click Fee List
  6. Enter the name of the fee list object in the Object Label field.
  7. Use the following table to enter List Settings information:

    Field

    Description

    Only these fee categories

    Select the fee categories by which you want to limit your report parameters. Only those fee categories for your school appear.

    Only these departments

    Select the departments by which you want to limit your report parameters. Only those departments for your school appear.

    Only fees assessed for courses in these groups

    Select the groups by which you want to limit your report parameters. Only those groups for your school appear.

    Only fees assessed during

    Choose the date range by which you want to limit your query from the pop-up menu:

    • Current School Year
    • Current Term
    • Current Date
    • Date Range:

    If you select the Date Range, enter the beginning and ending dates in the fields using the format mm/dd/yyyy or mm-dd-yyyy. If you do not use this format, an alert appears. If you submit the date with an incorrect format, the date field is submitted as a blank entry.

    Only fees whose current balance is

    Select the type of balance by which you want to limit your report parameters. Choose one of the following from the pop-up menu:

    • Paid in Full
    • Partially Paid
    • Non-Zero

    Only transactions conducted during

    Choose the date range by which you want to limit your query from the pop-up menu:

    • Current School Year
    • Current Term
    • Current Date
    • Date Range:
    • Specify a Run Time

    If you select the Date Range or Specify a Run Time, enter the beginning and ending dates in the fields using the format mm/dd/yyyy or mm-dd-yyyy. If you do not use this format, an alert appears. If you submit the date with an incorrect format, the date field is submitted as a blank entry.

    Only transactions paid via

    Select the payment methods by which you want to limit your report parameters. Only those payment methods for your school appear.

    Only transactions which are

    Select the type of transaction by which you want to limit your report parameters. Choose one of the following from the pop-up menu:

    • Debits
    • Credits
  8. Use the following table to enter Table Settings information:

    Field

    Description

    Column title font

    Choose the style of font you want the column title to appear as from the pop-up menu. The system setup determines the default font.

    If selecting a font other than the default, you may also select the formatting you want to use. For example, choose Bold to bold the column title font.

    Size, line height, size

    Enter the column title font size and line height in points. One point equals 1/72 of an inch.

    Select any combination of these checkboxes to determine any additional styles for the text:

    • Bold
    • Italic
    • Underline

    Column Title Background Color, Tint

    Enter the name of the color in which you want the background of the column title to appear. To view a list of color names, click Color. A color palette appears. Copy the name of the color you want and paste it into the Color field. Otherwise, leave this field blank.

    To tint the color, enter a percentage. Otherwise, leave this field blank.

    Print column titles on

    Choose which pages you want column titles to appear from the pop-up menu:

    • All pages
    • First page of list
    • Do not print column titles

    Print subtotal row on

    Choose whether or not you want the subtotal row to appear from the pop-up menu:

    • Last page of line items
    • Do not print subtotal row

    Subtotal row label

    If you selected to print a subtotal row on the last page of line items, enter the heading you want to appear. Then, choose the row in which you want the heading to appear from the pop-up menu.

    Print grand total row on

    Choose whether or not you want the grand total row to appear from the pop-up menu:

    • Last page of this fee list
    • Do not print grand total row

    Grand total row label

    If you selected to print a grand total row on the last page of this fee list, enter the heading you want to appear. Then, choose the column in which you want the heading to appear from the pop-up menu.

    Coordinates

    To determine where the table prints on the page, enter the number of inches from the left, top, right, and bottom margins you want the table to print.

    Rule width

    Enter the thickness in points of the vertical and horizontal lines on the report, as well as the outline of the entire report. One point equals 1/72 of an inch.

    Cell padding

    Enter the width of each cell and the amount of space from all sides of the cells to the text in points. One point equals 1/72 of an inch.

  9. Use the following table to enter Line Item Settings information:

    Field

    Description

    Font

    Choose the style of font you want the column title to appear as from the pop-up menu. The system setup determines the default font.

    If selecting a font other than the default, you may also select the formatting you want to use. For example, choose Bold to bold the column title font.

    Size, line height, style

    Enter the column title font size and line height in points. One point equals 1/72 of an inch.

    Select any combination of these checkboxes to determine any additional styles for the text:

    • Bold
    • Italic
    • Underline

    Even row background color, tint

    Enter the name of the color in which you want the backgrounds of the even rows to appear. To view a list of color names, click Color. A color palette appears. Copy the name of the color you want and paste it into the Color field. Otherwise, leave this field blank.

    To tint the color, enter a percentage. Otherwise, leave this field blank.

    Odd row background color, tint

    Enter the name of the color in which you want the backgrounds of the odd rows to appear. To view a list of color names, click Color. A color palette appears. Copy the name of the color you want and paste it into the Color field. Otherwise, leave this field blank.

    To tint the color, enter a percentage. Otherwise, leave this field blank.

    Currency format

    Choose the format by which you want currency to appear from the pop-up menu.

    Group line items by

    Choose the way in which you want line items to be grouped from the pop-up menu:

    • Individual Fees
    • Individual Transactions
    • Fee Category
    • Fee Type
    • Payment Method
    • Course Number
  10. Use the following table to enter information for each column you want to include:

    Field

    Description

    Width

    Enter the width of the column in inches.

    Title

    Enter the text you want to appear as the heading for the column.

    Title alignment

    Choose the column title justification from the pop-up menu:

    • Left
    • Center
    • Right

    Data Source

    Choose from the pop-up menu the type of data you want to include in this column:

    • Fee Balance
    • Fee Amount
    • Transaction Quantity
    • Transaction Payment Amount
    • Blank
    • Static Text
    • Field value:

    If you selected a data source of Static Text or Field Value, enter the static text or field value you want to display in the next field.

    Specific fee type

    Choose the fee type from the pop-up menu. For more information about fee types, see Fee Types.

    Data alignment

    Choose the data justification from the pop-up menu:

    • Left
    • Center
    • Right

    Include in

    Select one of the checkboxes:

    • Select Subtotal to include this column in subtotal calculations.
    • Select Grand total to include this column in grand total calculations.
  11. Use the following table to enter Page Item Settings information:

    Field

    Description

    Split line items to multiple pages

    Select one of the following checkboxes to group information by page based on your selection:

    • By fee category
    • By department
    • By transaction date
    • By receipt number

    Page

    Do one of the following:

    • Enter the page number of the report on which you want this fee list object to print.
    • Select the Display this object on all pages checkbox to have this fee list object print on all pages of the report. Note the Page field appears as All.

    Note: As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered prior to PowerSchool 11.0.4.0, that value will be honored and the fee list object will continue to appear on the first page of the report.

    Layer

    If you want this object to appear behind or in front of another object, choose the layer placement from the pop-up menu. Choose the highest number to place the object in front of all other layers.

  12. Click Submit

Picture Objects

Use picture objects to include on your object report. For example, include on transcripts a picture of your school's logo. Before creating a picture object, you must add the picture to your PowerSchool system. 

Use Picture Objects

  1. On the start page, choose System Reports under Reports in the main menu. 
  2. Click the Setup tab.
  3. Click Object Reports
  4. Click the name of the object report to which you want to add this object.
  5. Click Picture
  6. Use the following table to enter information in the fields:

    Field

    Description

    Object Label

    Enter a name for the picture object.

    Picture

    Choose an available picture from the pop-up menu. To print the appropriate student or teacher photos, choose Student Photo or Teacher Photo.

    Note: If a student or teacher record does not include an uploaded photo, nothing will appear on the report where this object is positioned.

    Coordinates

    Enter the number of inches you want the picture to print from the left, top, right, and bottom margins.

    Scaling Option

    To shrink or stretch the picture to fit within the specified coordinates, choose a scale from the pop-up menu.

    Note: Scaling can distort the display of the pictures.

    Rotation

    To rotate the picture on the report, enter the number of degrees you want to rotate it.

    Repeat

    If you want the picture to print repeatedly, define information in the following fields:

    • Times to Repeat
    • Horizontal Change (enter the number of inches you want between each picture horizontally)
    • Vertical Change (enter the number of inches you want between each picture vertically)

    Page

    Do one of the following:

    • Enter the page number of the report on which you want this picture object to print.
    • Select the Display this object on all pages checkbox to have this picture object print on all pages of the report. Note the Page field appears as All.

    Note: As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered prior to PowerSchool 11.0.4.0, that value will be honored and the picture object will continue to appear on the first page of the report.

    Layer

    If you want this object to appear behind or in front of another object, choose the layer placement from the pop-up menu. Choose the highest number to place the object in front of all other layers.

  7. Click Submit

Sequence Objects

Include sequence objects to print a numbered sequence on an object report. The sequence object is designed to mimic a counter on a preprinted form. For example, use a sequence object on a scheduling form to track each form by its number in the sequence. Use only numbers for a sequence object, and use a maximum of one sequence object per object report.

Use Sequence Objects

  1. On the start page, choose System Reports under Reports in the main menu. 
  2. Click the Setup tab. 
  3. Click Object Reports
  4. Click the name of the object report to which you want to add this object. 
  5. Click Sequence
  6. Use the following table to enter information in the fields:

    Field

    Description

    Object Label

    Enter a name for the sequence object.

    Position

    Enter the position of the sequence object for the X (horizontal) and Y (vertical) axes.

    Font

    Choose a font for the sequence object from the pop-up menu.

    Style

    Select any combination of the following checkboxes to determine the style of the font:

    • Bold
    • Italic
    • Underline

    Otherwise, do not select any checkboxes.

    Size

    Enter the font size in points. One point equals 1/72 of an inch.

    Starting Number

    Enter the first number in the sequence object.

    Count Forward?

    Select the checkbox if the sequence is in ascending order, such as 1, 2, and 3. To use descending order, deselect the checkbox.

    Format String

    This is used to format the printed output of the sequence object. For example, if you enter a starting number of 10 and a format string of 00000, the first item prints as 00010.

    Color

    Enter the name of the color in which you want all text in the sequence object to print.

    To view a list of color names, click Color. A color palette appears. Copy the name of the color you want and paste it into the Color field.

    If you want the text to be black, leave this field blank.

    Tint

    Enter a percentage to determine the shade of the sequence list object.

    If you enter 100%, the object is black. If you enter 0%, the object is white. Therefore, you can enter percentages between 100 and 0 to create a darker or lighter object.

    Page

    Do one of the following:

    • Enter the page number of the report on which you want this sequence object to print.
    • Select the Display this object on all pages checkbox to have this sequence object print on all pages of the report. Note the Page field appears as All.

    Note: As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered prior to PowerSchool 11.0.4.0, that value will be honored and the sequence object will continue to appear on the first page of the report.

    Layer

    If you want this object to appear behind or in front of another object, choose the layer placement from the pop-up menu. Choose the highest number to place the object in front of all other layers.

  7. Click Submit

Standards Objects

Create standard objects to include standards grades for each course.

Add a Standard Object

  1. On the start page, choose System Reports under Reports in the main menu. 
  2. Click the Setup tab. 
  3. Click Object Reports
  4. Click the name of the object report to which you want to add a standard object. 
  5. Under New Object, click Standard.

  6. Use the following table to enter information in the fields:

    Field

    Description

    Define the box that contains the standard course listing

    Enter the coordinates of the box in which the standard information prints. Use inches as the unit of measurement.

    Determine how many inches from the top left of the page you want the standard object to print. Indicate the left, top, right, and bottom coordinates of the standard object.

    If listing overflows this object, start a new column with these margins

    If the listing requires more room on the report on the same page, enter the coordinates of the box in which the overflow standard information prints. Use inches as the unit of measurement.

    Determine how many inches from the top left of the page you want the overflow standard object to print. Indicate the left, top, right, and bottom coordinates of the standard object.

    Term/school name font

    Choose the font in which the term and school information prints from the pop-up menu.

    Note: Click on the font link to view a list of available font examples.

    Size, line height, style

    Enter the information for the term/school name display on the report.

    In the first field, enter the size of the font.

    In the second field, enter the height of each line in the object in points. One point equals 1/72 of an inch. The height determines the space between each line in the standard.

    Select any combination of these checkboxes to determine any additional styles for the text:

    • Bold
    • Italic
    • Underline

    Term/school displays

    Choose from the pop-up menu whether to print the year abbreviation, the school name, both the school name and year abbreviation or to leave this information off of the report.

    Course listing font

    Choose from the pop-up menu the font in which the standard information prints.

    Note: Click on the font link to view a list of available font examples.

    Size, line height, style

    Enter the information for the course listing on the report.

    In the first field, enter the size of the font.

    In the second field, enter the height of each line in the object. One point equals 1/72 of an inch. The height determines the space between each line in the standard.

    Select any combination of these checkboxes to determine any additional styles for the text:

    • Bold
    • Italic
    • Underline

    Cell padding

    Enter a number, in points, to determine the distance between the horizontal and vertical borders of the cell and its contents. One point equals 1/72 of an inch.

    Horizontal Separator Width

    Enter the pixel width of the separator border between rows.

    Here is an example of the conversion from pixels to point sized for the border:

    1 px = 0.75 point
    2 px = 1.5 point
    3 px = 2.25 point
    4 px = 3 point
    5 px = 3.75 point
    6 px = 4.5 point

    Horizontal Separator Color

    Enter the color you want for the separator border between rows. Leave the field blank to use a black border.

    To use a named color, click on the Horizontal Separator Color link to view a list of the colors available. You can copy a color name from the page and paste it into the Horizontal Separator Color field.

    You can also enter an HTML color code directly in the field. Be sure to include the # symbol in the HTML color code when you enter it in the field.

    Horizontal Separator Tint

    If you want the separator border to be a gradient of the color you selected, enter the percentage. The lower the number, the lighter the color will appear.

    Horizontal Separator Line Style

    Select the line style for the separator border.

    Columns

    Specify the following for each column:

    In the Term field, enter the store codes (terms) you want to include in the standard. The report prints historical grade information for only the term columns you define, such as S1 and S2.

    The first six columns are pre-populated with the most commonly used objects. It is important to first list the course name, followed by the Start a New Line field. The items after the new line will repeat within the course name. For example, it will list a single course, then all of the standards assigned to that course.

    The new line helps to differentiate the spacing of the standards and the course name itself. This allows the standards to appear all under the same course.

    To change or add new fields, from the Field pop-up menu, select one of the following fields to include in the column:

    • Blank
    • Start a New Line to insert a line break.
    • Course Name
    • Course Number
    • Standard Name
    • Standard Identifier
    • Section Number
    • Section Expression
    • Letter Grade
    • Percent and enter the format in which you want the percent to print in the Other Field/Text/Format field.

    In the Other Field/Text/Format, enter any additional field or text you want to print next to each course. If you enter a PowerSchool field name, use the following format: ^(field name). For example, to include the possible credit a student could earn in each course, you can include the potential credit field.

    In the Width field, enter the width, in inches, of each term column.

    From the Align pop-up menu, select whether to align the data to the left, center, or right of the column.

    Note: For special formatting around course names and/or standard names, you can hard-code the course names or the standard name on the report. Then, in the Standards object, do not include a row for the course name, or don't include the standard name in the object. To check the alignment of the special formatting, run the report once with the standard name included, then remove it when the alignment is verified.

    Include only standard grades from these grade levels

    To print standard grades for only certain grade levels in the standard, enter the range of grade levels. Otherwise, leave these fields blank.

    Exclude Standards with No Grades?

    Select the checkbox if you do not want to display courses for which the student did not receive a grade. For example, if your school schedules lunch as a course on student schedules, select the checkbox to not print lunch on student standards.

    Filter to Specific Standards

    Use the fields to filter the report to specific standards.

    • Only include standards starting with the following text

    Enter a word in the text box, and select Standard Name or Standard Identifier from the pop-up menu. For more information, see Standard Object Filter Examples.

    • Only include standards with these identifiers

    Enter values. Separate each value entered with a comma. For more information, see Standard Object Filter Examples.

    • Only include standards at these hierarchy levels

    Enter values in the text boxes. For example, enter 1 and 3 to view standards between levels 1 through 3.

    • Only include standards with the following subject areas

    Enter the subject areas for the standards you want to view. Separate each value entered with a comma.

    For example; enter history, math, language arts.

    Show Additional Data (Usually Excluded)

    Select the checkbox next to the filter option you want included in the report.

    Current school only?

    Select the checkbox to include grades for only the current school in the standard. Otherwise, deselect the checkbox.

    Current year only?

    Select the checkbox to include grades for only the current year in the standard. Otherwise, deselect the checkbox.

    Sort courses by

    Use this pop-up menu to determine the sort order of the courses in the standard grades listing:

    • Course Name: Results descend by school year, then ascend by school name, and then ascend by course name.
    • Course Number: Results descend by school year, then ascend by school name, and then ascend by course number.

    Sort standards by

    Use this pop-up menu to determine the sort order of the standards:

    • Standard Name: Results descend by school year, then ascend by school name, and then ascend by standard name.
    • Standard Identifier: Results descend by school year, then ascend by school name, and then ascend by standard identifier.

    Page

    Do one of the following:

    • Enter the page number of the report on which you want this standard object to print.
    • Select the Display this object on all pages checkbox to have this standard object print on all pages of the report. Note the Page field appears as All.

    Note: As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered prior to PowerSchool 11.0.4.0, that value will be honored and the standard object will continue to appear on the first page of the report.

    Layer

    If you want this object to appear behind or in front of another object, choose the layer placement from the pop-up menu. Choose the highest number to place the object in front of all other layers.

  7. Click Submit.
    Note: The Course Name and Standards name fields are not required to be printed by this object. Some customers may want to hard code those on the report to include special formatting, grid lines, and other items. This is especially useful when using multiple standards objects on the report, and using the filters to limit which standards appear in each area. In that case, you can hard code the names on the report, and remove them from this object. Be sure to test the alignment first by including the standards or course names from the object to line up the report, then remove them once you have correctly lined up the objects.

Edit a Standard Object

  1. On the start page, choose System Reports under Reports in the main menu. 
  2. Click the Setup tab. 
  3. Click Object Reports
  4. Click the name of the object report for which you want to edit a standard object. 
  5. In the Object Type column, click Standard of the standard object you want to edit. 

  6. Edit information as needed. 
  7. Click Submit. 

Delete a Standard Object

  1. On the start page, choose System Reports under Reports in the main menu. 
  2. Click the Setup tab. 
  3. Click Object Reports
  4. Click the name of the object report for which you want to delete a standard object. 
  5. In the Object Type column, click Standard of the standard object you want to delete. 

  6. Click Delete.
  7. Click Confirm Delete
  8. Click Back to return to the Object Report [Report Name] page.

Standard Object Filter Examples

Report Type

Filter Field

Data Entry

Elementary Report Card

Only include standards with these identifiers

Enter MATH1.1.1, MATH1.1.2, MATH1.1.3, MATH1.1.4, MATH1.1.5, MATH 1.1.6, MATH 1.1.7 to view these exact standards on the report.

Middle School/High School Report Card

None

To display each student's full schedule and standards for their classes, do not include filters.

Life Science Standard

Only include standards starting with the following text

Enter Life Science, and select Standard Name from the pop-up to view only that standard on the report.

Report Pictures

Include pictures on object reports to enhance their appearance. Pictures like logos and seals are useful for object reports such as transcripts. For more information about adding pictures to a report, see Objects on an Object Report.

To make pictures available to include in reports, you must first upload the picture files to your server.

View a Report Picture

  1. On the start page, choose System Reports under Reports in the main menu. 
  2. Click the Setup tab. 
  3. Click Pictures
  4. Click the name of the picture in the "Available pictures" field. 

Add a Report Picture

Add a report picture for use in object reports. All pictures must be saved as JPEG files with the filename extension .jpg.

  1. On the start page, choose System Reports under Reports in the main menu. 
  2. Click the Setup tab. 
  3. Click Pictures
  4. Either enter the file path and name of the picture in the "Upload a new picture" field, or click Browse... to search for and select the file.
  5. Click Submit

Delete a Report Picture

To save system space and minimize possible confusion, delete a report picture when it is no longer needed. For example, delete a picture when your school logo changes. Then, add the picture of the new logo. 

  1. On the start page, choose System Reports under Reports in the main menu. 
  2. Click the Setup tab. 
  3. Click Pictures
  4. Select the checkbox next to the picture you want to delete.
  5. Click Submit

Object Reports With Standards Grades

Object reports can display standards scores. Use the following list of codes to generate object reports with standards grades.

Current Standard

~(*std.[which];[identifier])

For example:

~(*std.avg;LA11.2.3)

~(*std.transhigh;M12.4.5)

~(*std.num;FL3)

Calculated Standard

~(*std.[which];[identifier];[request1]{;[request2]})

For example:

~(*std.transavg;LA11.2.3;8/1/2000;7/30/2001)

~(*std.avg;SC3.5.12;Q1,Q2)

~(*std.high;FL2.5;2,3,4;S1)

~(*std.num;FA5.12;1999)

Stored Standard

~(*std.stored.[which];[identifier];[storecode]{;[request]})

For example:

~(*std.stored.transavg;LA11.2.3;S1)

~(*std.stored.avg;SC3.5.12;Q4)

~(*std.stored.high;FL2.5;T1;1999)

~(*std.stored.num;FA5.12;S2;11)

For which the following can have 'score' suffixed (for example, averagescore):

  • transhigh (translatedhigh)
  • trans (transavg, translatedavg, translatedaverage)
  • num (number, number, numberof)
  • avg (average)
  • high
  • note (comment)

Standard Info

  • name
  • desc (description)
  • level
  • course (coursenumber, course_number)
  • subj (subject, subjectarea)
  • type
  • id (identifier)
  • alignmentid (alignidentifier, alignid)
  • listparent
  • calcparent (calculationparent)
  • conv (convscale, conversionscale)

For example:
~(*std.info.name;LA11.2.3)
~(*std.info.desc;SC3.5.12)
~(*std.info.type;FL2.5)
Standard Info codes allow the parameter modification codes (for example, ;uppercase); however, the report codes do not.

Object Reports With Test Tags

Use test tags to include student test results in outputs. An output is a PDF file (such as an object report), an export, or an HTML page. For example, use the test tag when creating an object report text object. Enter the appropriate tags and supporting text in the Text field.

Test tags typically include several parameters to limit and format what appears on the report. For example, use the following test tag on a progress report to display a student's midterm test score:

~(tests;name=midterm;score=total;which=current)

You can also use the test tag inside an IF tag, which is a tag used to evaluate a given condition. For example, use an IF tag to display the statement "This student may wish to retake the ACT" on students' Graduation Progress pages if they earn ACT composite scores of less than 25.

In addition, you can add formats to the result of the test tag. The following is an example of a test tag that includes a type value, result value, and format string:

~(tests;name=ACT;score=math;which=last;type=num;result=value;format=##0.00)

The first three parameters refine the selection, and the next three parameters determine its presentation. If a student's last math ACT score was 23.14285, the result would be 23.14.

See the following table for parameter information.

Parameter

Examples

Notes

NAME

ACT

SAT

No default.

Note: NAME and SCORE are dependent upon tests defined on your PowerSchool system.

SCORE

MATH

ENGLISH

SCIENCE

COMPOSITE

No default.

WHICH

FIRST

LAST

BEST

CURRENT term

TERMID

GRADE

The default is LAST.

TYPE

NUM

PERCENT

ALPHA

The default is NUM.

RESULT

VALUE

SUM

AVG

DATE

COUNT

MIN

MAX

The default is SUM.

FORMAT

[Format string]


Some parameters are not compatible with others. For example, you cannot have a RESULT of SUM with a TYPE of ALPHA. Various combinations are detailed in the table below.

For example, the WHICH parameter TERM.CURRENT includes multiple tests. The RESULT parameter could meaningfully be set to SUM, AVG, COUNT, MIN, and MAX. A RESULT parameter of VALUE would not be meaningful and would return nothing.

See the following table to determine parameter compatibility; X indicates valid usage.

Which/Result

SUM

AVG

COUNT

MIN

MAX

VALUE

FIRST



X

X

X

X

LAST



X

X

X

X

BEST



X

X

X

X

TERM.CURRENT

X

X

X

X

X


TERM.id

X

X

X

X

X


DATES.mmddyy.mmddyy

X

X

X

X

X


GRADE.number

X

X

X

X

X


TYPE







NUM

X

X

X

X

X

X

PERCENT

X

X

X

X

X

X

ALPHA



X



X