Field Types to Custom Report Type

How to Add Fields to a Custom Report Type

If a report based on a Custom Report Type is missing some fields, you’ll need to edit the layout of the report type to make those fields available.

Thank you for reading this post, don't forget to subscribe!

For example, if an ‘Activities with Accounts and Contacts’ report type lacks certain fields in the ‘Select Columns’ step of the Report Builder, follow the steps below to resolve this.

Steps to Add Missing Fields to Your Custom Report:

Navigate to Setup: In the Quick Find box, type Report Types and select Report Types from the results.
Select Your Report Type: Choose the name of the Custom Report Type you want to modify.
Edit the Layout: In the ‘Fields Available for Reports’ section, click Edit Layout. If there’s an Object Relationship, you can adjust the View drop-down to find additional fields.
Drag and Drop Fields: From the Field Definition Fields section, drag and drop the missing fields into the layout, then click Save.
Add Fields via Lookup (Optional): You can also add additional fields from related objects by clicking Add fields via lookup on either the primary or secondary object.

Note:

When previewing the layout, you’ll see all fields and objects, even those you don’t have permission to access. You can only access data stored in fields or objects that you have the appropriate permissions for.

Once you’ve completed these steps, the missing fields will be available in the report.