Examkin

Question

Difficulty: HardStandard/Custom Report Types and Formats

A business operations manager requires a Salesforce analytics solution for reviewing Accounts and their associated Assets. The solution must satisfy three specific criteria:
1. Include all Accounts in the report, including those without any related Asset records.
2. Group the summarized data across two distinct axes: Asset Status along rows and Purchase Calendar Quarter along columns.
3. Ensure any new custom fields added to the Asset object in the future are automatically included in the report builder field palette without requiring manual administrator updates to the report design layout.

Which configuration of report type settings and report format should the administrator implement to meet these requirements?

  1. Create a Custom Report Type with Accounts as the primary object and Assets as a secondary object using 'with or without' relationship, select the setting to automatically add new custom fields to report layouts, and choose the Matrix report format.Answer
  2. B
    Use the standard Accounts with Assets report type, select the Summary report format grouped by Asset Status and Purchase Calendar Quarter, and create a row-level formula to evaluate blank Asset records.
  3. C
    Create a Custom Report Type with Accounts as the primary object and Assets as a secondary object using 'each record must have at least one related record' relationship, add a roll-up summary field to track field changes, and select the Joined report format.
  4. D
    Use a standard Accounts report type, set up a dynamic dashboard component grouped by Asset Status, and grant users dynamic dashboard running user access to automatically expose newly created fields.

Answer

Create a Custom Report Type with Accounts as the primary object and Assets as a secondary object using 'with or without' relationship, select the setting to automatically add new custom fields to report layouts, and choose the Matrix report format.
To satisfy all requirements: (1) Creating a Custom Report Type with Accounts 'with or without' related Assets performs an outer join, displaying Accounts regardless of Asset presence. (2) Selecting the 'Auto-add new custom fields' option ensures any new fields created on Assets in the future are automatically made available to report builders without manual CRT maintenance. (3) Selecting the Matrix format allows summarizing metrics across two dimensions simultaneously (rows for Asset Status and columns for Purchase Calendar Quarter).

Step-by-Step Solution

1
Determine object relationship requirement for missing child records
Standard report types for Accounts with Assets perform an inner join ('with' relationship), hiding parent Accounts that have no Assets. A Custom Report Type (CRT) must be created specifying 'Each record ("A") may or may not have related ("B") records' (with or without) to ensure all Accounts are included.
Only CRT outer joins retain primary object records when secondary child records do not exist.
2
Determine report layout maintenance settings for future custom fields
In Setup under Custom Report Type field layout settings, enable the option to auto-add new custom fields to existing report layouts.
By default, custom fields added to an object after CRT creation are excluded from the CRT layout unless this auto-add setting is enabled or fields are manually dragged onto the layout.
3
Select appropriate report format for two-dimensional grouping
Select the Matrix report format (or group by both rows and columns in Lightning Report Builder).
Matrix format allows grouping data by both row headers (Asset Status) and column headers (Purchase Calendar Quarter), fulfilling the two-axis summarization requirement.

Key Concept

Custom Report Type outer join definitions, auto-add field layout behavior, and Matrix report format capabilities.
Rate this question

Topics

Standard/Custom Report Types and Formats

More questions from this topic