What is a joined report in Salesforce?

A joined report in Salesforce consists of up to five report blocks , which you add to the report to create multiple views of your data. For each block, you can add regular and summary fields, create standard and cross-block custom summary formulas, apply filters, and sort columns.  A joined report can contain data from multiple standard or custom report types.

What is the drawback of joined reports in Salesforce?

Salesforce Joined report limitations

  • We cannot add bucketed fields to Salesforce Joined Reports.
  • We cannot add cross filters to a joined report.
  • Using drag-and-drop filters on joined reports from the Fields pane onto the Filter pane is not allowed.

A joined report in Salesforce is a report that allows you to show data that shares a relationship with one or more objects. Joined reports are often used when objects are not in parent-child relationships, such as Accounts and Opportunities.

Advantages of Using Joined Reports

  • A joined report lets you merge data from various objects or report types, enabling analysis and comparison across different aspects of your business.
  • Upon exporting a joined report, all data from the different report blocks are included in the export.
joined report in salesforce

What report types can be converted into joined reports?

  • Account and Contact Reports.
  • Activity Reports.
  • Administrative Reports.
  • Campaign Reports.
  • File and Content Reports.
  • Sales Engagement Reports.
  • Lead Reports.
  • Opportunity Reports.
Related Posts
Salesforce OEM AppExchange
Salesforce OEM AppExchange

Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more

The Salesforce Story
The Salesforce Story

In Marc Benioff's own words How did salesforce.com grow from a start up in a rented apartment into the world's Read more

Salesforce Jigsaw
Salesforce Jigsaw

Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more

Service Cloud with AI-Driven Intelligence
Salesforce Service Cloud

Salesforce Enhances Service Cloud with AI-Driven Intelligence Engine Data science and analytics are rapidly becoming standard features in enterprise applications, Read more

author avatar
get-admin