Examkin

Soru

Zorluk: ZorStandard/Custom Report Types and Formats

A support director needs a unified view that presents all Account records in Salesforce alongside their associated Support Cases, ensuring that Accounts remain visible even if they have zero related Cases. In addition, the report must display key metrics from related Work Orders in a side-by-side structure grouped by Account Name. Which combination of Custom Report Type configuration and report format selection satisfies these requirements?

  1. Create a Custom Report Type with Accounts as the primary object and Cases as the secondary object using 'Each A record may or may not have related B records' (outer join), then build a Joined Report that pairs this report type block with an Accounts with Work Orders report type block.Cevap
  2. B
    Create a Custom Report Type with Accounts as the primary object and Cases as the secondary object using 'Each A record must have at least one related B record' (inner join), and configure a Summary Report grouped by Account Name and Work Order Status.
  3. C
    Use a standard Cases report type, write a summary formula to evaluate record-by-record Work Order values, and apply a Matrix Report format grouped by Account Name on rows and Case Priority on columns.
  4. D
    Create a standard Accounts with Cases report type, configure a dynamic dashboard running user security setting to expose hidden records, and select a tabular report format with cross-object formula fields.

Cevap

Create a Custom Report Type using an outer join ('Each A record may or may not have related B records') between Accounts and Cases, and build a Joined Report format to place the Accounts with Cases block alongside an Accounts with Work Orders block grouped by Account Name.
The correct choice configures a Custom Report Type with an outer join ('Each A record may or may not have related B records'), ensuring Accounts without associated Cases are retained in the report results. Additionally, choosing a Joined Report format enables the administrator to combine two separate report type blocks (Accounts with Cases and Accounts with Work Orders) side-by-side, grouped by the shared Account Name field.

Adım Adım Çözüm

1
Determine the required object relationship logic for Accounts and Cases.
Configuring the Custom Report Type relationship as 'Each A record may or may not have related B records' ensures Accounts without Cases appear in report results.
Standard report types use inner joins ('with' relationship), which automatically exclude parent records that lack child records.
2
Determine the correct report format for multi-object side-by-side analysis.
Selecting the Joined Report format allows the report to contain up to 5 distinct report blocks based on different report types.
Neither Summary nor Matrix report formats can display metrics from separate unrelated child relationships (Cases vs. Work Orders) in parallel blocks.
3
Apply the common grouping field across report blocks.
Group both blocks by the common field 'Account Name'.
Joined reports require a shared principal grouping field across blocks to align data side-by-side.

Anahtar Kavram

Custom Report Type Object Relationships and Joined Report Format Selection
Bu soruyu puanla

Konular

Standard/Custom Report Types and Formats

Bu konudan daha fazla soru