Examkin

Question

Difficulty: MediumStandard/Custom Report Types and Formats

A Sales Operations Director wants to create a single report that shows Opportunity revenue metrics alongside Customer Support Case metrics, grouped by the shared Account. The requirements state that data from two different report types—Opportunities and Cases—must be presented in separate side-by-side blocks within the same report view. Which report format should the Salesforce administrator select to fulfill this requirement?

  1. Joined ReportAnswer
  2. B
    Summary Report
  3. C
    Matrix Report
  4. D
    Tabular Report

Answer

The correct format is a Joined Report because it allows combining multiple blocks of data from different report types into a single report view using common join fields.
A Joined Report is specifically designed to create up to 5 distinct blocks of data, where each block can be derived from a different standard or custom report type, joined together by common fields such as Account.

Step-by-Step Solution

1
Analyze the reporting requirement
Identified the need to combine data from two distinct report types (Opportunities and Cases) into separate blocks within a single report view.
Standard single-object report types cannot combine unrelated or separate object metrics into block structures within one report view.
2
Evaluate standard Salesforce report formats
Tabular, Summary, and Matrix formats only support a single report type. Joined Reports support up to 5 blocks, each based on a separate standard or custom report type.
Joined Reports use common fields (such as Account Name) as join keys to align records across blocks.
3
Select the optimal format
Choose Joined Report format.
It fulfills all requirements for combining Opportunity and Case metrics into side-by-side blocks grouped by Account.

Key Concept

Salesforce Report Formats & Joined Reports
Rate this question

Topics

Standard/Custom Report Types and Formats

More questions from this topic