Create Performance Review Custom Report
Custom Performance Review Reports allow you to report on performance review tasks, steps, sections, questions, and sign-off data. The Create Custom Performance Review Report page in Online Help provides detailed instructions and use cases for creating this report.

To begin, here are the basic steps for creating any custom report in the Report Designer:
- Go to .
- Select the report type from the New drop-down.
- Name the report. The report cannot be saved until you name it.
- Select a folder in which to store the report. This is optional.
- Select the fields to include in the report.
- Click to see a preview of the report output.
- Define the filters and the sort/summary options.
- Configure the sharing options.
- Schedule the report and configure the delivery options.
- Add/publish custom charts, if desired.
- Save the report.


A Human Resources Manager (HRM) would like to view the status of the organization's 2016 Annual Performance Review Task for each Division Organizational Unit (OU) to which the task has been assigned.
To create the report, the HRM performs the following steps in the Custom Report Builder:
- Access the Custom Performance Review Report via .
- Add the following fields:
- Filter the report by the Task Name field and set the filter to Contains "2016." By adding this filter, the report will only show data for the 2016 Annual Performance Review Task.
- Summarize the report by the Task Status field. Then, summarize the report by the Division field. This breaks the report data into status groups. Within each status group, the data will be summarized by Division OU. These summaries helps the HRM to quickly view the task status for each user in each division.
- Click . The report preview updates to display the data.
- Click the Actions drop-down and select Print Preview or Excel Preview to open a printable version of the data.

A Human Resources Manager (HRM) would like to generate a list of employees who declined to sign their performance review. The list will help her assess the reasons that the employees choose not to sign their review. She intends to use the information in the report to create an anonymous manager review survey that will be sent to all employees who declined to sign their review.
To create the report, the HRM performs the following steps in the Custom Report Builder:
- Access the Custom Performance Review Report via .
- Add the following fields:
- User Section
- User Full Name
- User Manager Name
- User Indirect Manager Name
- Performance Review Task Section
- Task Name
- Performance Review Sign-Off Section
- Sign-off Comments
- Sign-off Declined
- User Section
- Filter the report by the Sign-off Declined field and set the filter to "True." Filtering the report by the Sign-off Declined field constrains the data to only users who declined to sign the review. Users who signed the review will not be included in the report output.
- Click . The report preview updates to display the data.
- Click the Actions drop-down and select Print Preview or Excel Preview to open a printable version of the data.
Additional Field Options
The HRM could also choose to add the User Email, User Manager Email, and User Indirect Manager Email fields so that she has quick access to each user's contact information.

PERMISSION NAME | PERMISSION DESCRIPTION | CATEGORY |
Custom Performance Review Report - View | Grants ability to view results of custom Performance Review reports created by self or shared by others. This permission can be constrained by OU, User's OU, User's Self and Subordinates, User's Direct Subordinates, and User's Subordinates. | Reports - Analytics |
Performance Review Report Fields
The following fields are specifically available for Custom Performance Review Reports. Click here for a printable version of the Custom Performance Review Report fields.

FIELD NAME | FIELD DESCRIPTION | FIELD TYPE |
Question |
This field displays the full text of the question in the performance review section for the performance review task. The value is pulled from the Question field on the Question Properties pop-up when adding questions to a performance review section. The value can be viewed from the printable performance review on the Snapshot > Reviews page in Universal Profile. |
Text |
Question Responder |
This field displays the name of the user who responded to the rating scale question in the performance review task section. The value displays as [Last Name], [First Name]. The value is pulled from the user record of the responder. The value can be viewed from the printable performance review on the Snapshot > Reviews page in Universal Profile. |
Text |
Question Response Rating Score |
This field displays the rating entered by the user when responded to the rating scale question in the performance review task section. The value is pulled from the performance review. The value can be viewed from the printable performance review on the Snapshot > Reviews page in Universal Profile. |
Text |
Question Response Rating Title |
This field displays the title of the rating, as defined on the Define Rating Scale pop-up when configuring the performance review section. |
Text |
Question Response Comment |
This field displays the response or comment entered by the user or reviewer in the comments box for the question in the performance review task section. The value is pulled from the performance review. The value can be viewed from the printable performance review on the Snapshot > Reviews page in Universal Profile. |
Text |
Question Type |
This field displays the question type, as defined in the Response Type field on the Question Properties pop-up when adding questions to a performance review section. The value can be viewed from the printable performance review on the Snapshot > Reviews page in Universal Profile. |
Text |

FIELD NAME | FIELD DESCRIPTION | FIELD TYPE |
Number of Section Questions |
This field displays the number of questions that are in a section for a step in the performance review task. The value is calculated by adding the number of questions that have been added to a section when configuring the section on the Create/Edit Section page in Performance Review Form Sections. |
Numeric |
Reviewer Section Rating | This field displays the reviewer's rating for the section in the performance review task. The value is pulled from the performance review. The value can be viewed from the printable performance review on the Snapshot > Reviews page in Universal Profile. | Numeric |
Section Type |
This field displays the section type within a step in the performance review task. The value is pulled from the Type field on the Create/Edit Section page in Performance Review Form Sections. |
Text |
Section Version |
This field displays the version of the section within a step in the performance review task. The value is pulled from the Type column on the Performance Review Form Sections page. |
Numeric |

FIELD NAME | FIELD DESCRIPTION | FIELD TYPE |
Sign-off Comments |
This field displays the comments entered in the comments box by the reviewer when signing off on the performance review task. The reviewer can be self, manager, etc. Comments are entered on the Sign-Off step. Comments are only available for performance review sections if enabled by the administrator when configuring the section in the performance review task. |
Text |
Sign-off Declined |
This field indicates whether or not the user being reviewed declined to sign the performance review. The report displays "Yes" if the user declined to sign and "No" if the reviewer did not decline to sign. On the performance review, the user can decline to sign in the Decline to Sign field on the Sign-Off step. |
Yes/No |
Sign-off Signature |
This field displays the name of the user or reviewer who signed off on the performance review task on the Sign-Off step. The value displays in the report as [First Name] [Last Name]. |
Text |
Sign-off Timestamp |
This field displays the date and time of when the user or reviewer signed off on the performance review task on the Sign-Off step. |
Date |
Sign-off Type | This field displays the type of sign-off for the performance review task on the Sign-Off step. The sign-off type is set in the Signature Method field when configuring the Sign Off performance review section. Values may be Electronic, Authenticated, or Manual. | Text |

FIELD NAME | FIELD DESCRIPTION | FIELD TYPE |
User ID |
This field displays the user ID of the co-planner. The value is pulled from the user record of the co-planner for the succession task. |
Text |
User Full Name |
This field displays the name of the co-planner. The value displays as [Last Name], [First Name]. The value is pulled from the user record of the co-planner for the succession task. |
Text |
Number of Step Sections |
This field displays the number of step sections configured for the step in the performance review task. The value is pulled from the Sections field on the Review Workflow page of the task. |
Text |
Overall Step Rating |
This field displays the user's rating for the step in the performance review task. The value is pulled from the performance review. The value can be viewed from the printable performance review on the Snapshot > Reviews page in Universal Profile. |
Numeric |
Step Assigned To |
This field displays the user type to whom the step was assigned. The value is pulled from the Assigned To field when configuring the step for the task. |
Text |
Step Due Date |
This field displays the due date of the step. The value is pulled from the Due Date field for the step on the Review Workflow page of the task. For steps that are configured to have a relative due date from the date on which the task is assigned, the report output converts the number of days in the Due Date field to a calendar date. The Step Due Date field on the report will not display a number of days; it will only display an exact calendar date. |
Date |
Step Optional | This field indicates whether or not the step is optional. The report displays "Yes" if the step is optional and "No" if the step is not optional. The value is pulled from the This step is optional field when configuring the step for the task. | Yes/No |
Step Reviewer ID |
This field displays the user ID of the reviewer. The value is pulled from the user record of the reviewer for the performance review task step. The reviewer is the user to whom the step is assigned. |
Text |
Step Reviewer Name |
This field displays the name of the reviewer. The value is pulled from the user record of the reviewer for the performance review task step. The reviewer is the user to whom the step is assigned. |
Text |
Step Sequence |
This field displays the due date of the step. The value is pulled from the Sequence field for the step on the Review Workflow page of the task. |
Numeric |
Step Status |
This field displays the status of the step. The value is pulled from the Review Details for [Step Assignee Name] pop-up. The value can be viewed by clicking the View Details icon |
Date |
Step Submission Date | This field displays the date on which the performance review step was completed. | Date |
Step Title |
This field displays the step title. The value is pulled from the Step Title field when configuring the step for the task. |
Yes/No |
Step Weight |
This field displays the weight of the step. The value is pulled from the Step Weight field for the step on the Review Workflow page of the task. |
Numeric |

FIELD NAME | FIELD DESCRIPTION | FIELD TYPE |
Completion Date |
This field displays the date on which the performance review task was completed. The value can be viewed in the Completion Date field on the Snapshot > Reviews page in Universal Profile. |
Date |
Expiration Date | This field displays the due date or expiration date for the off-cycle performance review task. The expiration date is set in the When is the entire review due? field when configuring the Off-cycle Performance Review Task. This value can be viewed on the Task Details page for an off-cycle review task. | Date |
Is Not Removed From Task | Yes/No |
Off-cycle task recurrence number |
Off-cycle performance review tasks may be assigned to a user multiple times. This field displays the recurrence number that corresponds with the off-cycle task assignment. This enables administrators to view review data for a specific instance of an off-cycle task assignment. |
Numeric |
Performance Review Due Date |
This field displays the date on which the entire review is due. The value is pulled from the When is the entire review due field on the General tab of the performance review task. |
Date |
Review Period Start Date |
This field displays the date on which the review period starts. The value is pulled from the From field in the Review Period section on the General tab of the performance review task. |
Date |
Start Date | Date |
Task Final Rating | This field displays the user's performance review rating. The value is pulled from the performance review. The value can be viewed from the Snapshot > Reviews page in Universal Profile. Ratings are configured by the administrator in the Overall Rating Scale section on the General tab of the performance review task. | Numeric |
Task Final Rating Text | This field displays the text rating for the user's performance review. The value is pulled from the performance review. The value can be viewed from the printable performance review from the Snapshot > Reviews page in Universal Profile. Text ratings are configured by the administrator in the Overall Rating Scale section on the General tab of the performance review task. | Numeric |
Task Name | This field displays the date on which the review period starts. The value is pulled from the Task Name field on the General tab of the performance review task. | Text |
Task Raw Rating | This field displays the user's raw numeric performance review rating prior to any calibrations that may have been made to the user's rating. | Numeric |
Task Raw Rating Text | This field displays the user's raw performance review text rating prior to any calibrations that may have been made to the user's rating. | Text |
Task Status | This field displays the user's status for the performance review task. The value is pulled from the Snapshot > Reviews page in Universal Profile. | Text |
Task User Title | Text |

FIELD NAME | FIELD DESCRIPTION | FIELD TYPE |
Address Line 1 |
This field displays the user's Address Line 1. The value is pulled from the Address Line 1 field on the user record. |
Text |
Allow Reconciliation |
This field indicates whether or not the user's user record should remain active or be deactivated if the user does not appear in the most recent data feed. The value is pulled from the Allow Reconciliation field on the user record. If reconciliation is allowed, the user's record will be deactivated if it no longer appears in the feed. The report results display "Yes" in these instances. If reconciliation is NOT allowed, then the user's record will be not be deactivated if it no longer appears in the feed. The report results display "No" in these instances. |
Yes/No |
City |
This field displays the user's city. The value is pulled from the City field on the user record. |
Text |
Cost Center Approver Ref |
This field displays the user ID of the user's cost center approver. The value is pulled from the User ID field on the user record. |
Text |
Cost Center Approver |
This field displays the name of the user's cost center approver. The value displays as [Last Name], [First Name]. The value is pulled from the Approver field on the Define OU page when configuring OUs. |
Text |
Cost Center ID |
This field displays the ID of the organizational unit (OU). The value for this field is pulled from the ID field on the OU configuration page in Manage Organizational Unit Hierarchy. |
Text |
Cost Center Owner |
This field displays the owner of the user's assigned Cost Center Organizational Unit (OU). The value is pulled from the Owner field on the Define OU page when configuring the OU. |
Text |
Cost Center Parent |
This field displays the parent of the user's assigned Cost Center Organizational Unit (OU). The value is pulled from the Parent field on the Define OU page when configuring OUs. |
Text |
Cost Center Ref |
This field displays the ID of the user's assigned Cost Center Organizational Unit (OU). The value is pulled from the ID field on the Define Cost Center page when configuring cost centers. |
Text |
Cost Center |
This field displays the name of the user's assigned Cost Center Organizational Unit (OU), as shown on the user record page. If the Cost Center OU has been renamed for the portal, this value in the report will reflect the updated name. |
Text |
Display Language | This field displays the language in which the user's portal displays when they are logged in, as shown on the User Record, when available. The value is pulled from the Display Language field on the user record. If Display Language is not populated on the User Record, the default language for the OU will be displayed. Unless otherwise changed, the default language setting is English. | Text |
Division ID |
This field displays the ID of the organizational unit (OU). The value for this field is pulled from the ID field on the OU configuration page in Manage Organizational Unit Hierarchy. |
Text |
Division Owner |
This field displays the owner of the user's assigned Division Organizational Unit (OU). The value is pulled from the Owner field on the Define OU page when configuring the OU. |
Text |
Division Parent Ref |
This field displays the ID of the parent of the user's assigned Division Organizational Unit (OU). The value is pulled from the ID field on the Define OU page of the parent Division OU when configuring OUs. |
Text |
Division Parent |
This field displays the parent of the user's assigned Division Organizational Unit (OU). The value is pulled from the Parent field on the Define OU page when configuring OUs. |
Text |
Division Ref |
This field displays the ID of the user's assigned Division Organizational Unit (OU). The value is pulled from the ID field on the Define OU page when configuring OUs. |
Text |
Division |
This field displays the name of the user's assigned Division Organizational Unit (OU). The value is pulled from the Division field on the user record. If the Division OU has been renamed for the portal, the value in the report will reflect the updated name. |
Text |
Grade ID |
This field displays the ID of the organizational unit (OU). The value for this field is pulled from the ID field on the OU configuration page in Manage Organizational Unit Hierarchy. |
Text |
Grade Owner |
This field displays the owner of the Grade Organizational Unit (OU). The value is pulled from the Owner field on the Define OU page when configuring the OU. |
Text |
Grade Parent |
This field displays the parent of the user's assigned Grade Organizational Unit (OU). The value is pulled from the Parent field on the Define OU page when configuring OUs. |
Text |
Grade Ref |
This field displays the ID of the user's assigned Grade Organizational Unit (OU). The value is pulled from the ID field on the Define OU page when configuring OUs. |
Text |
Grade |
This field displays the name of the user's assigned Grade Organizational Unit (OU). The value is pulled from the Grade field on the user record. |
Text |
Local System ID | The value that displays in the report output for this field is the identifier from a local system. In the system, the field is typically used when Cornerstone is generating User IDs for users and the organization wants to store the identifier from their local Human Resources (HR) or Payroll system in the Cornerstone system. | Text |
Location ID |
This field displays the ID of the organizational unit (OU). The value for this field is pulled from the ID field on the OU configuration page in Manage Organizational Unit Hierarchy. |
Text |
Location Owner |
This field displays the owner of the user's assigned Location Organizational Unit (OU). The value is pulled from the Location field on the Define OU page when configuring the OU. |
Text |
Location Parent |
This field displays the parent of the user's assigned Location Organizational Unit (OU). The value is pulled from the Parent field on the Define OU page when configuring OUs. |
Text |
Location Ref |
This field displays the ID of the user's assigned Location Organizational Unit (OU). The value is pulled from the ID field on the Define OU page when configuring OUs. |
Text |
Mailstop |
This field displays the user's mailstop, as defined on the user record. |
Text |
Months of Service |
This field displays the numeric value provided through data feed only. |
Numeric |
Photo Exists |
This field indicates whether or not a photo has been uploaded on the user's user record. The report displays "Yes" if a photo has been uploaded and displays "No" if a photo has not been uploaded. |
Text |
Position ID |
This field displays the ID of the organizational unit (OU). The value for this field is pulled from the ID field on the OU configuration page in Manage Organizational Unit Hierarchy. |
Text |
Position Owner |
This field displays the owner of the user's assigned Position Organizational Unit (OU). The value is pulled from the Owner field on the Define OU page when configuring the OU. |
Text |
Position Parent |
This field displays the parent of the user's assigned Position Organizational Unit (OU). The value is pulled from the Parent field on the Define OU page when configuring OUs. |
Text |
Position Ref |
This field displays the ID of the user's assigned Position Organizational Unit (OU). The value is pulled from the ID field on the Define OU page when configuring OUs. |
Text |
Position |
This field displays the name of the user's assigned Position Organizational Unit (OU). The value is pulled from the Position field on the user record. If the Position OU has been renamed for the portal, the value in the report will reflect the updated name. |
Text |
Postal Code |
This field displays the user's ZIP or Postal Code. The value is pulled from the Zip field on the user record. |
Text |
Required Approvals |
This field displays the number of people (e.g., managers, approvers) from which the user must get approval before being able to register for training. The value is pulled from the Required Training Approvals field on the user record. |
Text |
State/Province |
This field displays the user's state or province. The value is pulled from the State field on the user record. |
Text |
User Absent |
This field displays the user's absent status. The report displays "Yes" if the user is marked absent and displays "No" if the user is not absent. The value is pulled from the Absent field on the user record. |
Yes/No |
User Address 2 |
This field displays the user's Address Line 2. The value is pulled from the Address Line 2 field on the user record. |
Text |
User Approver ID |
This field displays the user ID of the user's approver. The value is pulled from the User ID field on the user record. |
Text |
User Approver Name |
This field displays the name of the user's approver. The value displays as [Last Name], [First Name]. The value is pulled from the First Name/Last Name fields on the user record. |
Text |
User Country |
This field displays the user's country. The value is pulled from the Country field on the user record. |
Text |
User Email |
This field displays the user's email address. The value is pulled from the Email Address field on the user record. |
Text |
User Fax Number |
This field displays the user's fax number. The value is pulled from the Fax Number field on the user record. |
Text |
User First Name |
This field displays the user's first name. The value is pulled from the First Name field on the user record. |
Text |
User Full Name |
This field displays the name of the user's full name. The value displays as [Last Name], [First Name]. The value is pulled from the First Name/Last Name fields on the user record. |
Text |
User ID |
This field displays the user's user ID, which is the unique identifier for the user. The value is pulled from the User ID field on the user record. |
Text |
User Indirect Manager Email |
This field displays the email address of the user's indirect manager. The value is pulled from the Email Address field on the user record of the user's indirect manager. |
Text |
User Indirect Manager First Name |
This field displays the first name of the user's indirect manager. The value is pulled from the First Name field on the user record of the user's indirect manager. |
Text |
User Indirect Manager Id |
This field displays the user ID of the user's indirect manager. The value is pulled from the User ID field on the user record of the user's indirect manager. |
Text |
User Indirect Manager Last Name |
This field displays the last name of the user's indirect manager. The value is pulled from the Last Name field on the user record of the user's indirect manager. |
Text |
User Indirect Manager Name |
This field displays the full name of the user's indirect manager. The value displays as [Last Name], [First Name]. The value is pulled from the First Name/Last Name fields on the user record of the user's indirect manager. |
Text |
User Last Access |
This field displays thedate and time of the user's most recent, successful login prior to the analytics data refresh. Date criterion is always implemented using UTC (Coordinated Universal Time). |
Date |
User Last Hire Date |
This field displays the date on which the user was most recently hired. The value is pulled from the Last Hire Date field on the user record. |
Date |
User Last Name |
This field displays the user's last name. The value is pulled from the Last Name field on the user record. |
Text |
User Manager Email |
This field displays the email address of the user's manager. The value is pulled from the Email Address field on the user record of the user's manager. |
Text |
User Manager ID |
This field displays the user ID of the user's manager. The value is pulled from the User ID field on the user record of the user's manager. |
Text |
User Manager Name |
This field displays the full name of the user's manager. The value displays as [Last Name], [First Name]. The value is pulled from the First Name/Last Name fields on the user record of the user's manager. |
Text |
User Middle Name |
This field displays the user's middle name. The value is pulled from the Middle Name field on the user record. |
Text |
User Mobile Number |
This field displays the user's mobile phone number. The value is pulled from the Mobile Phone field on the user record. |
Text |
User Name |
This field displays the user's user name, which is used to log in to the portal. The value is pulled from the User Name field on the user record. |
Text |
User Name Prefix |
This field displays the user's name prefix. Examples of name prefixes include Mr., Mrs., Ms., Miss, Dr. The value is pulled from the Prefix field on the user record. |
Text |
User Name suffix |
This field displays the user's name suffix. Examples of name prefixes include II, III, Jr., Sr. The value is pulled from the Suffix field on the user record. |
Text |
User Orig. Hire Date |
This field displays the date on which the user was most originally hired. The value is pulled from the Original Hire Date field on the user record. |
Date |
User Phone Number |
This field displays the user's phone number. The value is pulled from the Phone field on the user record. |
Text |
User Status |
This field displays the user's status. The value in the report output is Active, Inactive, Pending Approval, or N/A. Users with an inactive status are unable to log in to the portal. Pending approval status applies to users who have submitted self-registration requests that are pending approval by the self-registration group approver. Users pending approval cannot log in to the portal until their records are approved. N/A status applies to external user's added to peer groups in Performance, and External Candidate for external successors added during Succession Planning tasks. The value for the User Status field in the report is pulled from the User Status field on the user record. |
Text |
Create a Custom Performance Review Report

You can name the report at any point during the report creation process; however, reports cannot be saved until they have been given a name. You can also select a folder in which to store the report.

Naming the report in the Report Designer is required in order to save the report. The
button is not enabled until a report title is entered. The report name should be descriptive and meaningful.
To name the report:
- Enter a title in the Report Title field in the upper-left corner of the page. The field accepts alphanumeric characters and the following special characters:
- -
- _
- (
- )
- "
- '
- .
- ,
- [
- ]
- Once a report title is entered, the button is enabled.
- Click to save the report title. The also saves the report. The report title will display at the top of the page and can be entered or edited at any time during the report configuration process.

Selecting a storage folder is optional. The report folder drop-down displays the custom reports folder hierarchy and enables you to move reports into a designated folder. By default, the Custom Reports folder displays in the drop-down.
To select a folder:
- Click the report folder drop-down. This opens a list of available folders.
- Click the folder name. This adds the report to the folder.

The Fields panel displays all of the fields that are available for the report. The fields that you add to the report represent the information that you want to report on. For example, if you add the User Full Name and User Address fields, then the report will show the physical address for all of the users in the report.
The fields are organized into sections and can be sorted by field type using the Show drop-down. You can also search for fields in the Search bar by entering a full or partial search term.
When adding fields, it is recommended that you start by adding biographical fields, such as User ID. Then, add the fields on the topic that you are reporting on, such as Training Title or Transcript Status.

The Show drop-down enables you to select the types of fields that you would like to display in the Fields panel. You can filter by standard and custom fields, as well as by Text, Numeric, Date, or Yes/No data types.
To filter by type, click the Show drop-down and select one or more of the following options:
- Standard Fields - Checking this box displays all applicable standard fields for the report type.
- Custom Fields - Checking this box displays all applicable custom fields for the report type.
- Text - Checking this box filters the standard and custom fields that display in each field type section to display only text fields.
- Numeric - Checking this box filters the standard and custom fields that display in each field type section to display only numeric fields.
- Date - Checking this box filters the standard and custom fields that display in each field type section to display only date fields.
- Yes/No - Checking this box filters the standard and custom fields that display in each field type section to display only Yes/No fields.
As filters are selected, the fields in each field type section update to display only the fields that meet the filter criteria.
Tip: Clicking the Field type section name selects all filters in the Field Type section. Clicking the Data type section name selects all filters in the Data Type section.

The search bar allows you to filter the Fields panel to only display fields that match your search criteria.
To search for fields, enter a full or partial search term in the Search bar. Each section in the Fields panel updates when you stop typing to display the fields that match the search criteria. The number of matching fields in a section displays in parentheses to the right of the section name.

There are multiple ways to add fields to the report. Do one of the following to add a field:
- Click the field name in the Fields panel. The field only needs to be clicked once to add it to the report.
- Drag and drop the field from the Fields panel to the report preview panel.
- Type a full or partial field name in the Type or drag a field here box in the report preview panel. When text is entered, the drop-down in the Type or drag a field here box filters to display the matching field names. Select the desired field from the drop-down to add the field to the report.
- Click in the Type or drag a field here box in the report preview panel and select the desired field from the list.
In addition, there are two areas to which fields can be added:
- Report preview panel
- Field Filters tab - Note: Fields can only be added to this tab by dragging and dropping the field name from the Fields panel or by selecting the field from the field selection drop-down on the Field Filters tab.
When you click a field name, the field is automatically added to the report preview section as a separate column. Any report data associated with the field displays in the preview section.

Each field type section displays the fields associated with the field type. Each field is identified within the section as text , numeric
, date
, or True/False
.

Add Calculated Field
The option to add a calculated field displays in the Calculated Fields field type section. Clicking the plus icon opens the Calculated Field Wizard. Once the field is created, the field is added to the list of fields in the Calculated Fields field type section and adds the field to the report preview.
Note: Calculated fields can only be used in summarized reports.
Edit/Copy/Remove Calculated Field
The options to edit, copy, or delete a calculated field still appear in a drop-down but are now available by hovering over the right arrow icon at the end of the field row. This enables the following options to appear:
- Edit - Click Edit to open the Edit/Copy Calculated Field Wizard. When editing a calculated field, the report preview does not automatically update to show the changes to the report results. You must click to update the report preview.
- Copy - Click Copy to open the Edit/Copy Calculated Field Wizard. When copying a calculated field, the field is added to the list of fields in the Calculated Fields field type section and adds the field to the report preview. You must click to update the report preview.
- Remove - Click Remove to delete the calculated field from the field type section.

The report preview panel allows you to view the report results as you build the report. The preview helps you decide which fields to include in the report to ensure that you ascertain the desired report data.
Up to 50 rows of report data display in the preview. If a field's value is longer than 20 characters, hover over the value to display a pop-up of the full value.

You can update the results in the preview pane by clicking the
button. When the report data is out of date, an Exclamation icon displays in the button to indicate that the report data needs to be refreshed.When filters in the Field Filters panel are added or modified, the report results must be manually refreshed in order to view the updated data.

Enter the maximum number of records that should be returned in the report. The default value is 75,000. The maximum value that can be entered in the field is 999,999. Enter a value of zero to not have a limit.
An Excel output accommodates 65,000 rows. The HTML Printable Version is only recommended when viewing less than 20,000 rows.
As with existing functionality, the value in the Maximum number of records field must be a positive whole number.

The following options are available in the
button drop-down. The options are only available if the report is summarized and only apply to the printable and Excel versions of the report, as well as when the report is run.- Show/count unique rows only - Select this option to filter the summarized report results not to repeat report rows that display identical summarized information. For example, if a Transcript report only contains the field User Full Name, and the report results include 50 different users with the name Sample User, then checking the Show/count unique rows only will only display one row of name Sample User in the report.
- Show record counts in report - Select this option to create a report that displays the record count for each combination of fields selected. For example, to determine the total number of active versus inactive training types in the catalog, check the Record Count box, then include the Training Active and Training Type fields in the report. The report displays a total count of inactive and active training types, listed by type.
- Show report headers in report - Select this option to show the name of the fields in the header row of the report output.

The following actions are available in the
button drop-down:- Print - Click the Print icon to create a printable version of the report. This option only appears for users with permission to preview custom reports. This option does not display when the report output exceeds 30,000 rows.
- Export to Excel - Click the Export to Excel icon to export the report results to Excel. This option only appears for users with permission to preview custom reports.
- Remove All Columns - Click Remove All Columns to remove all of the fields that you have selected for the report. This opens a confirmation pop-up. Click to remove all fields in the report. This clears the report preview panel and all selections in the tabs above the preview. Or, click to cancel the removal action.
When viewing a printable or Excel version of a report with more than 5000 records, only the first 5000 records display. If your report contains more than 5000 records, be sure to save the report in order to view all of the records. When custom reports are saved, they are subject to 30,000 records for printable version or 65,000 records for Excel.

You can sort columns in ascending and descending order. You can also view the sort order selection.
Ascending/Descending
The columns in the report preview panel can be sorted in ascending and descending order by clicking the arrow to the right of the column name. Clicking the down arrow resorts the column in descending order. Clicking the up arrow resorts the column in ascending order. Note: This option is disabled when the maximum number of sorted fields has been reached on the Sort tab.
View Sort Order
To view the sort order for the column, hover the mouse over the column name. This opens a tooltip that displays "<Field Name> is sorted <Ascending/Descending> and is the <Sort Order Number> sort level."

Options are available in a drop-down for each field that displays in the report preview section.
The following options are available, depending on the field type:
- Filter - This option is available for all field types. Click this option to add the field to the Field Filters panel.
- Sum - This option is available for numeric fields only. This is current functionality that displays the sum of all values for the field.
- Average - This option is available for numeric fields only. This is current functionality that displays the average of all values for the field.
- Minimum - This option is available for numeric fields only. This is current functionality that displays the minimum value for the field.
- Maximum - This option is available for numeric fields only. This is current functionality that displays the maximum value for the field.
- Sort - Click this option to add the field to the Sort tab. Fields display in the tab in the order in which they are added. See Create Custom Report - Sort Tab.
- Summarize - Click this option to add the field to the Summary tab. Fields display in the tab in the order in which they are added. See Create Custom Report - Summary Tab.
- Remove - This option is available for all field types. Click Remove in the drop-down to remove the field from the report. Note: This does not remove the field from the Field Filters, Sort, or Summary tab.
Note: For numeric fields that are already aggregated, the associated aggregate option is disabled. For example, if viewing the Sum Training Hours field, the Sum option is disabled in the drop-down.

The Filter and Sort tabs allow you to narrow down the report data and define the sort order for the fields. The Summary tab allows you to group the data by select fields.

The Field Filters tab enables you to filter the report fields in order to narrow down the report results. Once the filters are defined, you can refresh the report preview panel to update the report results.

You can add fields as filters by dragging and dropping fields, as well as by manually entering a name in the field text box. You can also add fields by clicking the drop-down to the right of the field text box and selecting the desired field.

Fields can be added by dragging the field from the Fields panel and dropping it into a blank field box on the Field Filters tab. An operator drop-down and value field automatically populate to the right of the field name. Select an operator, and then enter a value.

Enter a full or partial field name in the blank box in the Field Filters tab. When text is entered, the box filters to display the matching field names. Select the desired field from the drop-down to add the field to the Field Filters tab.

You can change the field that is selected in an individual field box on the Field Filters tab in the following ways:
- Clicking the drop-down in the field and select a different field. All fields available for the report display in the drop-down.
- Enter a different field name in the field box.
Changing the field selection clears any operator or value entered for the previous field.

For fields that have multi-select options for the field value, the options display in a drop-down. One or more values can be selected by clicking the box to the left of the value. Click the Check all option to select all values for the field. Click Uncheck all to deselect all values for the field.

Once the filters are defined, click the
button to update the report results. The report preview panel updates to display all report results that match the filter criteria.

You can delete a filter by clicking the Remove icon to the right of value field.

The Sort tab enables you to define the sort order of the fields you selected for the report. By sorting the report fields, you can define which column displays first, and so forth, in the report output.
The report can only be sorted into a maximum number of four fields. Once the maximum number is reached, the report cannot be sorted into additional fields.

To sort fields on the report, the fields must be added to the Sort tab. Fields are added by dragging and dropping fields from the Fields panel to the blank sort boxes on the Sort tab.
You can also add fields by clicking the name of the field in the Report Preview panel, which automatically places the field in the next available sort box, up to the maximum of four fields. Once you have reached the maximum number of sorted fields, an additional field cannot be added until at least one field is removed from the Sort tab.
Each sort row in the tab can only contain one field.

If multiple fields are added to the Sort tab, you can define the sort order by dragging and dropping the fields into the desired order on the tab.

The Show All Items drop-down displays to the right of each sort box. Clicking the drop-down shows all fields that are available for sorting, as well as the "None" option. You can select one of the fields from the drop-down to add the field to the sort. Or, select "None" to not sort the report by additional fields.

The data in the sorted fields can be sorted in ascending or descending order by clicking the Ascending or Descending icon to the right of the field.

You can delete fields from the Sort tab by clicking the Delete icon to the right of the field name. This deletes the field from the Sort tab but does not delete the field from the report.

To update the report preview panel with the new sort order, click
. This updates the sort order number of the column in the report preview.
The Summary tab enables you to summarize the data in the report based on certain fields.

To summarize fields for the report, the fields must be added to the Summary tab. Fields are added by dragging and dropping fields from the Fields panel to the blank summary boxes on the Summary tab. Up to four fields can be summarized. Once you have reached the maximum number of summarized fields, an additional field cannot be added until at least one field is removed from the Summary tab.
Each summary row in the tab can only contain one field.
The following options are available for each field:
- Ascending/Descending - Click the Ascending/Descending icon to the right of the field to put into ascending or descending order.
- Delete - Click the Trash Can icon to delete the field from the Summary tab. This does not delete the field from the report.
- View as Hierarchy - If an OU criterion is selected from the Summarize by drop-down list, then a View as hierarchy option is available to the right of the field. If this option is selected, the report data is automatically displayed in a hierarchical manner. The Then by drop-down option is automatically set to User Full Name and cannot be modified. If the View as hierarchy option is not selected, the Then by drop-down is active.
- Include Percentage summary column - Check the box to display the percentage in the report. The percentages only display in the report output. The percentages in the report output display based on the value in the Maximum number of records field.
- Overall Percentage - Select this option to display percentages relative to the total record count of the report.
- Hierarchical Percentage - Select this option to display percentages relative to the parent level in the hierarchy or summary. These percentages are a flexible percentage that is configurable at different levels of the report. For example, if Division A has a Transcript status of Completed, the percentages are calculated based on the total number at the Division level. If Division A has 500 people and Completed has 50 people, the hierarchical percentages are calculated out of 500 people (10%).
- Include grand summaries at bottom - Select this option to include a grand summary row at the bottom of the report for all summarized fields. Note: This option is only available if the data is summarized.

If multiple fields are added to the Summary tab, you can define the sort order by dragging and dropping the fields into the desired order on the tab.

To update the report preview panel with the new summary order, click
. The report preview panel is updated to display the summary view of the report results.In the summary view of the report preview panel, a drop-down displays for each summarized field. The drop-down includes the following options:
- Summarize - Click this option to open the Summary tab. This option does not display for fields configured to display percentages.
- Remove <Name of Summarized Field> <Number of Summary Field> - This option displays as a separate option in the drop-down for each summarized field. Clicking the option removes the associated summarized field. Note: If the Hierarchical Percentage view is checked on the Summary tab, then the Remove option displays for the top level summarized field.
- Remove All Summarization - Click this option to remove all summary configurations from the Summary tab.

The Sharing tab enables you to define the users with whom to share the report. The selected users cannot modify or edit the report. The selected users must have the appropriate permissions to view the custom report.

To share the report:
- Click the Select Criteria drop-down. This displays the OUs from which you can select to view the report.
- Select an OU. This enables the Select icon to appear to the right of the Select Criteria drop-down.
- Click the Select icon
. This opens the Select [OU Name] pop-up. Note: If "User" is selected in the Select Criteria drop-down, then the Select User pop-up opens.
- Click the Add icon to the left of the OU name. Note: If "User" is selected in the Select Criteria drop-down, then select the individual users with whom to share the report.
- Click . This closes the pop-up and adds the selections to the Sharing tab.
For shared reports, the data is refreshed once per day, which is the same rate as the refresh rate for the report that the report creator sees.

The Schedule and Delivery tabs enable you to schedule the report and configure the delivery options.

The Schedule tab enables you to create a schedule for the report. Reports can be scheduled to run once, daily, weekly, or monthly. By default, reports are not scheduled to run and must be run manually by the user. In order to schedule a report at a specific time or on a daily, weekly, or monthly basis, you must configure the scheduling options on the Schedule tab.

Click the Once option in the Schedule drop-down. This enables the options to display below the drop-down for creating a one-time report. Complete the following fields:
- Schedule - Select "Once" from the drop-down.
- Time - From the drop-down, select the time at which to run the report. The default setting is one hour from the current time.
- Time Zone - From the drop-down, select the time zone in which to run the report. The default setting is the time zone of the user configuring the report.
- Start Date - By default, the start date is the current date. You can modify the start date by entering a different date in the field. This is a required field.
The report runs at the specified date and time.

Click the Daily option in the Schedule drop-down. This enables the options to display below the drop-down for creating a report that runs daily. Complete the following fields:
- Schedule - Select "Weekly" from the drop-down.
- Repeat Every - This field enables you to determine the report interval. For example, if "3" is the value in the field, then the report runs every three days. Enter the number of days in the Repeat Every field. The default value is "1." This is a required field.
- Time - From the drop-down, select the time at which to run the report. The default setting is one hour from the current time.
- Time Zone - From the drop-down, select the time zone in which to run the report. The default setting is the 's time zone of the user configuring the report.
- Start Date - By default, the date on which the report starts running is the current date. You can modify the start date by entering a different date in the field. This is a required field.
- End Date - Enter the date on which to stop running the report. This is a required field.

Click the Weekly option in the Schedule drop-down. This enables the options to display below the drop-down for creating a report that runs weekly. Complete the following fields:
- Schedule - Select "Weekly" from the drop-down.
- Repeat Every - This field enables you to determine the report interval. For example, if "3" is the value in the field, then the report runs every three weeks. Enter the number of weeks in the Repeat Every field. The default value is "1." This is a required field.
- On - Select the day on which the report will repeat. The default value is the current day of the week. This is a required field.
- Start Time - From the drop-down, select the time at which to run the report. The default setting is one hour from the current time.
- Time Zone - From the drop-down, select the time zone in which to run the report. The default setting is the time zone of the user configuring the report.
- Start Date - By default, the date on which the report starts running is the current date. You can modify the start date by entering a different date in the field. This is a required field.
- End Date - Enter the date on which to stop running the report. This is a required field.

Click the Monthly option in the Schedule drop-down. This enables the options to display below the drop-down for creating a report that runs monthly. Complete the following fields:
- Schedule - Select "Weekly" from the drop-down.
- Repeat Every - This field enables you to determine the report interval. For example, if "3" is the value in the field, then the report runs every three months. Enter the number of months in the Repeat Every field. The default value is "1." This is a required field.
- On - This field allows you to configure when the report will run.
- Day - Select "Day" from the drop-down to run the report on a specific day of the month. This enables a numeric text box to display to the right of the drop-down. In the text box, enter the day of the month on which the report will run.
- First - Select "First" from the drop-down to run the report on the first <Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday> of the month.
- Second - Select "Second" from the drop-down to run the report on the second <Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday> of the month.
- Third - Select "Third" from the drop-down to run the report on the third <Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday> of the month.
- Fourth - Select "Fourth" from the drop-down to run the report on the fourth <Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday> of the month.
- Last - Select "Last" from the drop-down to run the report on the last <Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday> of the month.
- Start Time - From the drop-down, select the time at which to run the report. The default setting is one hour from the current time.
- Time Zone - From the drop-down, select the time zone in which to run the report. The default setting is the time zone of the user configuring the report.
- Start Date - By default, the date on which the report starts running is the current date. You can modify the start date by entering a different date in the field. This is a required field.
- End Date - Enter the date on which to stop running the report. This is a required field.

For each report type, the Summary section displays the report schedule. For all but the one-time report, the Summary section displays the date on which the report is scheduled to run next.

Check the Schedule report for shared users also box to share the report. The checkbox only displays if the shared user criteria fulfills the requirements for scheduling.

For reports that are scheduled to process daily or weekly, If the report output has not been accessed in the last 30 days, then the system stops processing the scheduled report until the user clicks one of the report output options, such as clicking the Excel icon. Once the user clicks the output option, the report will begin processing again on schedule.


No. If you refresh the report, the refresh will process but does not restore the report schedule. The only way to restore the report schedule after 30 days is to click one of the report output options.

Yes. The report schedule is maintained because reports are processed based on the report ID, which is the same for the report generator and all shared users.
For example, you create a report and schedule it for weekly processing. You share the report with one user. You never look at the report, but the other user accesses it each week. The report schedule is maintained because the shared user accesses the report output.

Yes. If you create a report and schedule it for delivery, email, or FTP (file transfer protocol), the delivery counts as opening the report, and the report will continue to run.

The report delivery options display on the Delivery tab in the Custom Report Builder.
Note: The Report Delivery options are only available if the report is set to run on a recurring basis.

Check the FTP Delivery box to deliver a copy of the custom report to the FTP site specified in the Report Delivery Preferences. If this option is selected, you have the option to send the report in Comma Separated or Tab Delimited format. The maximum file size for this report is 25 MB.
The FTP Delivery option is only available if you have permission to schedule delivery of a report to an FTP site and if the Allow report to be sent to FTP preference is set in Report Delivery Preferences.
How the Report Name Will Appear
The following is the naming convention for reports delivered to the FTP folder:
[Report Title]_[UserID]_[UTC Time in format MM_dd_yyyy_HH_mm]
- Report Title - This is the name of the report as defined when creating the report.
- UserID - This is the UserID of the user who created the report.
- UTC Date/Time - This is the UTC date and time at which the report was created in MM_dd_yyyy_HH_mm format.

Check the Email me box to deliver a copy of the custom report to your system email address. Only the creator of the report will receive an email; users with whom the report is shared will not receive an email. If this option is selected, you have the option to send the report in Comma Separated or Tab Delimited format. This option is only available if you have permission to schedule delivery of a report to an email address. The maximum file size for this report is 3 MB. The report is always sent as a .zip file.
Note: The system email address is the address defined by the administrator in the Support Email field on the Corporate Preferences page.

For information about creating custom charts, refer to the Custom Charting section in Online Help.
For information about publishing charts to dashboards, refer to the Publish Custom Charts section in Online Help.
Save the Report
The report can be saved at any point during the report creation process by clicking the Report Title field.
button in the upper-right corner of the page. However, the button is only enabled once you have named the report in theThe report does not fully process until after you have saved and closed it. Once the report is finished processing, the report is ready for use.
Report Tips
- Trial and Error of Report Fields - In order to achieve the desired report results, it may be necessary to try various combinations of fields. Reports are expected to take a few drafts before you arrive at the exact report you need. It is recommended that you search through all of the available fields in the Fields panel to see the different data-points that are available.
- Suggestion City - If you would like a standard field added to Custom Reports, consider posting the request to Suggestion City in the Client Success Center as an enhancement request.