How to join two reports in salesforce


  1. Go the Reports tab, click New Report .
  2. Select the Accounts Report type.
  3. Change the Report to a Joined Report format type :
  4. Add or amend the filters for the Account report. This is your baseline and will determine what data the other report blocks will pull in. Add a Report Block
  5. Select the Cases report type, click Add Block .
  6. Add or amend the filters for the Cases block. Perhaps “Status” = “Open” is a good option, given our use case.
  7. Add another report block for Opportunities. Again, add or amend the filters to perhaps include only the open Opportunities (“Opportunity Status” = “Open”). …
  8. You can group rows by “Account Name”, for example, which then aligns all of the Account’s Cases and Opportunities, so anyone scanning the report can understand the data faster:
  9. Run the report to see where Cases and Opportunities overlap (by Account). Add a Report Chart Report charts help users to understand reports even more. …
  10. Click Add Chart, then select the chart type that will best represent your data. Select the appropriate Y-Axis value. You will notice these include the report block name.
Create a Joined Report
  1. From the Reports tab, click New Report.
  2. Choose a report type and click Continue. …
  3. The report opens in the report builder. …
  4. To add another report type to the joined report, click Add Block. …
  5. Customize the joined report with columns, groups, filters, and formulas.
  6. Click Save and name the report.

Table of Contents

How do I create a joined report in Salesforce?

Go to the Reports & Dashboards tab and click on the New Report button. Choose which Report Type to use for the first report block of the joined report. Remember that this will be the principal report type for the entire joined report.

How to combine two unrelated objects in Salesforce report?

Salesforce doesn’t allow to combine two unrelated objects either from UI or through API for reporting purpose. Even if in Joined report works on the relations. A joined report can contain data from multiple standard or custom report types.

Can I see both opportunities and cases in a Salesforce account?

There’s no way you would be able to see both an Account’s related Opportunities and related Cases in one view – without Joined Reports. In this Salesforce Joined Reports tutorial, we will be creating a report that shows:

Can you have multiple report types in a joined report?

Even if in Joined report works on the relations. A joined report can contain data from multiple standard or custom report types. You can add report types to a joined report if they have relationships with the same object or objects.


How do I link two reports in Salesforce?

2:513:49Introducing Joined Reports with Salesforce (Salesforce Classic)YouTubeStart of suggested clipEnd of suggested clipYou and now let’s group the report by. Account. You finally we’ll add titles to the blocks toMoreYou and now let’s group the report by. Account. You finally we’ll add titles to the blocks to clarify what they’re showing. Now let’s run our report to see summary information only click hi details.

How do I enable joined reports in Salesforce lightning?

Go to Username > Setup > App Setup > Customize > Reports & Dashboards > User Interface Settings. From there you simply click the Enable button to turn on the Report Builder Upgrade. With the new Report Builder enabled, you get the Joined format option in your reports.

What are joined reports in Salesforce?

A joined report 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.

How do I group reports in Salesforce?

Click Show | Drop Zones to make them visible. You can also click a column menu for a field in the report and choose Group by this Field. Tip If you group your report by a date field, you can click the group menu, select Group Dates By, and specify the grouping time frame: day, week, month, quarter, year, and so forth.

Can I merge 2 reports in Salesforce?

You can turn any existing report into a joined report, or start fresh with a new one. From the Reports tab, click New Report. Choose a report type and click Continue. The report type you choose becomes the joined report’s principal report type.

Why do we use joined reports in Salesforce?

Salesforce users can use joined reports to create an overall summary of different data objects in multiple sections. Joined reports give users the ability to bring together several data points neatly arranged in blocks within a single report.

Can you join two report types in Salesforce?

A Joined Report in Salesforce combines two reports that have different report types, within a single view. Salesforce Joined Reports appear like one single report so that you can get a more holistic data view.

Can you subscribe to joined reports in Salesforce?

Allow Joined reports to have Subscription functionality available. Any user who can run and view a report should have the subscription function available to have the report delivered on a scheduled basis like a tabular report.

Can we use joined reports in dashboards?

Winter ’13 now allows Joined reports on Dashboards (Winter ’13 release notes, pp. 88-89). Simply build a chart on your Joined report, add the same chart type to a Dashboard, select the Joined report as the source, and you’re almost good to go.

What is grouping in report?

In a paginated report, a group is a named set of data from the report dataset that is bound to a data region. Basically, a group organizes a view of a report dataset. All groups in a data region specify different views of the same report dataset.

What is grouping level in Salesforce?

grouping_level is the API name of the peer level group whose summary value is used for the previous grouping. increment is the number of previous groupings.

What is bucketing in Salesforce reports?

The Bucket Field in Salesforce is a valuable feature that allows you to rapidly categorize values for a field in a report without having to create a custom formula field at the object level. In reporting, a bucket is a custom category that you create. Bucketing is a Salesforce report and documentation tool.

What is a joined report?

A joined report may contain one or more data from different report types. If various report types have a linked relationship with a single object, they can be combined in a joined report. The first report type added to a joined report becomes the principal report type.

How many data blocks can be in a joined report?

Joined reports allow data blocks to enable multiple views of different data. A single joined report can have up to five data blocks. Users can add fields, filters, formulas and do column sorting within these blocks. Charts can also be added accordingly.

How many blocks can you join in a report?

It’s easy to get started with joined reports, and there’s no limit to what you can do. Mix standard and custom report objects in up to five blocks, set up meaningful row groupings, name and apply filters to each block, and even apply summary formulas across all the blocks.

Can you add report types to a joined report?

You can add report types to a joined report if they have relationships with the same objects. For example, Opportunities and Cases both have fields in common with Accounts, so you can create a joined report with them.

7 Reasons Why Your Business Needs to Know Salesforce

The main use of Salesforce is to create customer relationship management (CRM) software that facilitates break down the technology between divisions to give firms a…

Detailed Guide to Implement Salesforce Multi-Factor Authentication (MFA)

Plan To Implement MFA Configuring Permission Set in Salesforce Login in to your Salesforce account On the setup page, search “Permission Set” Click the “New”…

Steps to setup Communities in Salesforce

To setup the communities, the very first thing you need to do is enable the communities in the org. Once the communities are enabled in…

Top 5 Features Salesforce Winter Release ’21

Even though we’re in the middle of one of the strangest summers in our lives, we can rely on one constant: releases from Salesforce. It’s…

Salesforce Contact Tracing for Employees Demo

As businesses gradually reopen after worldwide closures, many people feel concerned about the second spike in COVID-19 cases. To ensure public safety, local officials have…


Leave a Comment