Create a custom report type

To create a custom report type:

1. Go to Setup, and in Quick Find enter Report Types.

2. Select New Custom Report Type. 

   Sage People displays the New Custom Report Type screen:
   

3. Complete the fields as follows:

   Field	Description
   Primary Object	Picklist. Select the object to be the focus of this report. For example: for a report about bonuses with Team Member details, select Team Member as the primary object.
   Report Type Label	Enter a name for the custom report type. Label is displayed to users when they select a report type for a new report.
   Report Type Name	The unique name in the system, automatically completed based on the Report Type Label. Must begin with a letter, contain alphanumeric characters and underscores only.
   Description	Enter the purpose and characteristics of this custom report type. Description is displayed to users when they select a report type for a new report.
   Store in Category	Picklist. Select the category in which this custom report type is included. Categories are displayed on the Create Reports screen. Typically Other Reports.
   Deployment Status	Radio buttons, defaults to In Development. A custom report type in development is not yet visible to users creating new reports. Select Deployed when you are ready for the custom report type to be available for new reports.

4. Select Next.

5. In Step 2. Define the Report Records Set you can add other objects related to the primary object (A) to the custom report type. Only objects related to the primary object are selectable. After selecting the second object (B), only objects related to that object are selectable as the third object (C), and so on.

   For example, for a report about bonuses containing fields from the Team Member object, add the object relationships as follows:

   • Team Member (A): primary object

     • Employment (B): each A record must have at least one related B record

       • Bonuses (C): B records may or may not have related C records

   This combination of object relationships is displayed in the following screenshot: 
   

   

   Note

   When you use the option to require related records—each record must have at least one related record—the reports based on the report type do not include records without any related records for the selected object. If a report does not contain the records you expect, check the object relationships in the custom report type.

6. Select Save.

   After saving a custom report type, all the fields on the objects you selected in your custom report type are added as available fields to the custom report type. The number of fields for each object is listed in the Fields Available for Reports section.

7. To remove fields from the report type, select Edit Layout, as shown in the following screenshot:

   

8. On the edit layout screen, drag fields from the layout into the selection area as in the screenshot below:

   

   Tip

   If you remove a field, make a note of it in the report type Description.

9. To add fields to the report type, drag them from the selection panels, or select Add fields related via lookup and choose the fields to add, as shown in the following screenshot:

   

   By default, fields are added to the report type layout in alphabetical order. When you add fields, you can drag and drop them anywhere on the layout. The location on the layout determines the order in which fields are available in the report builder.

   Custom report types automatically contain only the fields available in the object when the custom report type was created. If you add new custom fields to an object, the new fields are not available for reports until you add them to the custom report types.