To enable reports to pull data from more than just the primary object, consider adding one or more related objects to your report type.
|Available in: both Salesforce Classic and Lightning Experience|
|Available in: Professional, Enterprise, Performance, Unlimited, and Developer Editions|
|To create or update custom report types:||“Manage Custom Report Types”|
|To delete custom report types:||“Modify All Data”|
- Click the box under the primary object.
- Select a child object.
Only related objects are shown.
Type in the search box to find objects quickly.
- For each child object, select one of the following criteria:
- Each "A" record must have at least one related "B" record. Only parent records with child records are shown in the report.
- "A" records may or may not have related "B" records. Parent records are shown, whether or not they have child records.
When Users are the primary object, select child objects by field—for example, Accounts (Account Owner) or Accounts (Created By).
- Add up to three child objects.
The number of children depends on the objects you choose.
- Click Save.
- If you select that object A may or may not have object B, then all subsequent objects automatically include the may-or-may-not association on the custom report type. For example, if accounts are the primary object and contacts are the secondary object, and you choose that accounts may or may not have contacts, then any tertiary and quaternary objects included on the custom report type default to may-or-may-not associations.
- Blank fields display on report results for object B when object A does not have object B. For example, if a user runs a report on accounts with or without contacts, then contact fields display as blank for accounts without contacts.
- On reports where object A may or may not have object B, you can't use the OR condition to filter across multiple objects. For example, if you enter filter criteria Account Name starts with M OR Contact First Name starts with M, an error message displays informing you that your filter criteria is incorrect.
- The Row Limit option on tabular reports shows only fields from the primary object on reports created from custom report types where object A may or may not have object B. For example, in an accounts with or without contacts report, only fields from accounts are shown. Fields from objects after a may-or-may-not association on custom report types aren't shown. For example, in an accounts with contacts with or without cases report, only fields from accounts and contacts are available to use. Also, existing reports may not run or disregard the Row Limit settings if they were created from custom report types where object associations changed from object A with object B to object A with or without object B.