Standard report types created by object relationships
Key Takeaway
The relationship type decides which standard report types you get. For a many-to-many relationship, choose the report type in the report category of the master whose records should set the report's scope, because that report type lists that master first.
When you relate objects, Salesforce makes standard report types available so you can report on the related objects together. The kind of relationship (lookup, master-detail, or many-to-many through a junction object) decides two things: how many objects a report can join, and which report category each report type appears in.
What each relationship lets a report join
The type of relationship you create decides which standard report types are available and how they are categorized. Those report types in turn decide which related objects a report can include.
| Objects one report can join | |
|---|---|
| Lookup relationship | The two related objects |
| Master-detail relationship | Three: the master object, the detail object, and one other lookup object |
| Many-to-many relationship (through a junction object) | Both master objects and the junction object |