Examkin

Question

Difficulty: Very hardStandard/Custom Report Types and Formats

A Sales Operations Manager requires a report that lists all Account records in Salesforce, including Accounts that do not have any associated Opportunities. The report must summarize the total Opportunity Amount across two dimensions simultaneously: Account Industry along the rows and Opportunity Stage across the columns. Furthermore, the administrator must ensure that any custom fields created on Accounts or Opportunities in the future are automatically available in the report builder without requiring manual updates to the report type field layout. Which solution should the Salesforce administrator implement to satisfy all requirements?

  1. Enable the organizational setting to automatically add new custom fields to custom report types, build a Custom Report Type with Accounts as the primary object and Opportunities defined with 'A records may or may not have related B records', and construct the report using the Matrix format.Answer
  2. B
    Use the standard 'Accounts with Opportunities' report type, apply a Summary report format with two row groupings, and enable automatic field inheritance on the report layout.
  3. C
    Create a Custom Report Type with Accounts as the primary object and Opportunities defined with 'Each record must have at least one related record B', and summarize data using a Joined report format.
  4. D
    Build a standard 'Accounts' report type, insert a row-level formula to evaluate Opportunity Stage and Amount, and group the report using a Summary format.

Answer

Enable the organizational setting to automatically add new custom fields to custom report types, build a Custom Report Type with Accounts as the primary object and Opportunities defined with 'A records may or may not have related B records', and construct the report using the Matrix format.
To include primary records regardless of whether they have child records, a Custom Report Type with a 'may or may not have related records' (left outer join) relationship must be created. Grouping data simultaneously along rows (Industry) and columns (Stage) requires the Matrix report format. Finally, enabling the automated setting to add new custom fields to custom report types eliminates the operational overhead of manually adding future fields to the CRT layout.

Step-by-Step Solution

1
Determine the required object relationship model ('with' vs 'with or without').
Standard report types for Accounts with Opportunities perform an inner join, omitting Accounts without Opportunities. A Custom Report Type (CRT) with 'A records may or may not have related B records' (left outer join) is required to include Accounts missing Opportunities.
Business requirement mandates seeing all Accounts, even those without related Opportunities.
2
Select the correct report layout format based on grouping requirements.
Matrix format is required to group data by both row (Account Industry) and column (Opportunity Stage) vectors.
Summary format only supports row groupings, whereas Matrix format supports two-dimensional grid summarizing.
3
Configure custom field maintenance strategy for the report type.
Enable 'Auto-add new custom fields to custom report types' in Salesforce setup.
By default, CRT layouts do not automatically include newly created custom fields, unlike standard report types. Enabling this setting ensures future fields appear in the report builder without manual layout editing.

Key Concept

Custom Report Type Object Relationships, Report Format Selection (Matrix), and CRT Field Layout Administration
Rate this question

Topics

Standard/Custom Report Types and Formats

More questions from this topic