Work with a List Report
On this page:
Create a List Report
- Select Reporting > Standard Reports.
- Click New List Report.
- In the Report Name field, enter a unique name.
- If you are creating a new public report, use the Optional Category field as follows:
- To add the report to an existing category, select the category.
- To create a new category, select (new category), and then enter the category name.
- To display the report in the category for the information you are reporting, select None.
- In the Type of Information field, select the information to include in the report. By default, Students is selected. You can change this to focus on staff, locations, etc.
- In the Selection Criteria field, define the formula for selecting the records to appear in the report.
- To select fields based on where they display in PowerSchool Special Programs, click the Quick Formula link. When your formula is completed, click Update and Accept Formula.
- To build a complex formula that contains nested logic, use the Formula Editor.
- If additional fields display below the Selection Criteria text box, select the options as needed.
- Click Accept. The report appears with a default set of columns sorted by the report name.
- Review the report results. If the results are not what you expected, edit the selection formula.
- Make additional changes as needed.
- When you have finished setting up the report, click Finish Editing Report.
Insert/Delete Columns
- When you are editing a report, click the Insert (plus) icon at the position where you want to insert columns.
- On the List Report Column Properties menu, click Select Field.
- On the Select Field menu, select the field to add.
The Select Fields menu allows you to find a field based on your familiarity with profile forms. In the Filter by Section field, select the form that contains the field, and then click the field's link. Alternatively, you can click Use List… in the toolbar to access a search feature that allows you to search for a field by name, data type, and other characteristics of the field. - On the List Report Column Properties screen, click in the Column Title field. If you do not want to use the column value as the title, enter the title to use for the column.
- To define alignment and other formatting options, click More Options… to access advanced options for the column.
- Click Accept to add the column and return to the report, or click Accept and Add Another to insert additional columns.
- When you are editing a report, click the Delete (X) at the top of the column to remove it.
Sort Report Rows
By default, the report rows are sorted by name.
- To specify additional sort values, click the Edit (pencil) icon next to the Sort Value(s) field. Note that the name of this field indicates the type of information in the report. For example, it appears as Student Sort Value(s) for a student report.
- On the Sort Values screen, click Select Field to select a sort field. You can specify up to three sort fields. Sorting by name is implicit; therefore do not specify Name as a sort field.
- To specify a page break so that each sort value appears on a new page, select Page Break. When you include a page break based on a sort value, a sub-total is included for each section of the report.
- To sort values in descending order, select Descending Sort.
- Click Accept.
Edit Report Header
By default, the report page header is the same as the name of the report. You can change the header text, and if you specified a sort with a page break, you can modify the header to show the sort values.
- Click the Edit (pencil) icon next to the header.
- Change the text of the report header as needed.
- If the report has a sort with a page break and you want to include the sort value, click Insert Sort Level to insert a placeholder for the sort value into the report header. The placeholder takes the form of "{S1}", "{S2}" or "{S3}".
- Click Accept.
Add Report Security
When a public report is ready for end-users, enable one or more security groups to access the report.
- While editing a report, click Security.
- Select the security groups that should be able to access the report.
- Click Accept.
List Report Calendar View
List reports with a date or date/time columns to allow the list report to be viewed in a calendar format.
- In edit mode, click Report Properties.
- To enable the calendar view, select Allow Display Report as Calendar.
- Click Accept.
- Exit editing mode. Each row of the list report becomes an item on the calendar. You can select any month for the items that display on the calendar menu.
Add Color to Rows
You can colorize rows in your list report by adding a special color column that computes the desired color for each row.
- In edit mode, on the More… menu, select Add Row Colorization Column.
- In the Column Value field, modify the formula to specify the colors.
For example, if the report lists students of various grades and you wish to show first graders in orange, second graders in yellow, and any other grades in blue, the formula would be SELECTCASE( Grade=01:'orange', Grade=-2:'yellow':'blue'). - Click Accept to save the colors. In edit mode, the @COLOR column data will be visible, but when you leave edit mode, the color column will be hidden.
Display Report on Users Home Page
- In edit mode, click Report Properties.
- Select the Allow Users to Render Report Directly On Their Home Page checkbox.
- Click Accept.