It can be tricky to understand how Joined reports work in Salesforce. For those who have experience with database queries or other report writing tools, the name Joined report can raise expectations that it will be possible to report on data joined from different objects in the one report. A way to think of joined reports is of separate block reports where the data can be optionally grouped to ‘join’ the data.

The most basic use case of a joined report is to display different views of data from the same object in the same report. For example, create an opportunity report and change the type to joined. Once the report type is changed, the report fields are grouped together in a block. Dragging fields to an area to the right of the first block will create a second block. Up to 5 blocks can be created in the one joined report.
Continue Reading