Examkin

Soru

Zorluk: OrtaStandard/Custom Report Types and Formats

A Customer Support Director wants to analyze Case distribution across different Account Industries. The report must list all Accounts regardless of whether they have associated Cases, and display a grid total of Case counts summarized simultaneously by Account Industry along the rows and Case Status across the columns. Which Custom Report Type object relationship and Report Format selection meets these business requirements?

  1. Define a Custom Report Type with Accounts as the primary object and Cases as 'Each record may or may not have related records', then select the Matrix report format.Cevap
  2. B
    Define a Custom Report Type with Accounts as the primary object and Cases as 'Each record must have at least one related record', then select the Matrix report format.
  3. C
    Define a Custom Report Type with Accounts as the primary object and Cases as 'Each record may or may not have related records', then select the Summary report format.
  4. D
    Use the standard Cases report type with a lookup filter to Accounts, then select the Joined report format.

Cevap

Define a Custom Report Type with Accounts as the primary object and Cases as 'Each record may or may not have related records', then select the Matrix report format.
To include Accounts without associated Cases, an outer join is required by setting the Custom Report Type relationship so that 'Each record may or may not have related records'. To group data simultaneously by rows (Account Industry) and columns (Case Status), a Matrix report format must be used.

Adım Adım Çözüm

1
Determine the required object relationship logic for record visibility
Configuring 'Each record may or may not have related records' (outer join) on the Custom Report Type ensures Accounts without Cases are retained in the report output.
An inner join ('Each record must have at least one related record') would filter out unserviced Accounts.
2
Select the appropriate Salesforce report format for two-dimensional grouping
Choosing the Matrix report format enables grouping row data by Account Industry and column data by Case Status.
Summary reports only allow row groupings, whereas Matrix reports provide grid-style summarization across both rows and columns.

Anahtar Kavram

Custom Report Type Object Relationships ('with' vs 'with or without') and Matrix Report Format Selection
Tahmini Süre:1m 30s
Bu soruyu puanla

Konular

Standard/Custom Report Types and Formats

Bu konudan daha fazla soru