Soru

Zorluk: Çok zorStandard/Custom Report Types and Formats

A Salesforce Administrator is configuring a Custom Report Type to analyze Customer Service operations. Management needs to report on all Cases, including those without any associated Work Orders, while also displaying detailed technician fields from the related Service Resource lookup object on the Work Order. Which two configuration steps must the administrator execute within the Custom Report Type layout and object relationship setup to satisfy these requirements? (Select TWO)

  1. Define the relationship between Case (Primary Object) and Work Order (Secondary Object) using the 'Each record "A" may or may not have related "B" records' option.Cevap
  2. Use the 'Add fields related via lookup' feature on the Custom Report Type field layout to include fields from the Service Resource object.Cevap
  3. C
    Set the default report layout format to 'Matrix' directly within the Custom Report Type general settings tab.
  4. D
    Create a Roll-Up Summary field on the Case object to count Work Orders so unlinked records can be categorized using a row-level formula.
  5. E
    Configure the running user setting on the Custom Report Type to bypass Organization-Wide Defaults for non-work-order Cases.

Cevap

To satisfy the reporting requirements, the administrator must configure the object relationship as 'Each record "A" may or may not have related "B" records' and utilize the 'Add fields related via lookup' feature in the Custom Report Type layout editor.
The correct requirements are met by establishing a left outer join ('with or without' relationship) between Case and Work Order so that Cases lacking related Work Orders remain in the report. Additionally, using 'Add fields related via lookup' in the Custom Report Type field layout enables access to fields on referenced lookup objects (up to four levels away, such as Service Resource) without modifying the core object hierarchy of the report type.

Adım Adım Çözüm

1
Determine the join requirement between Case and Work Order.
Identified that an outer join is required so that Cases without Work Orders are retained in the report output.
Choosing 'Each record A must have at least one related B record' would perform an inner join, filtering out Cases that do not have Work Orders.
2
Configure object relationship in Custom Report Type setup.
Set relationship to 'Each record "A" may or may not have related "B" records'.
This enforces the required left outer join structure at the report type level.
3
Identify how to bring fields from the indirect lookup object (Service Resource) into the field layout.
Navigated to the Field Layout editor of the Custom Report Type and selected 'Add fields related via lookup'.
This avoids creating unnecessary object relationship tiers while exposing indirect lookup fields to end users in the report builder.

Anahtar Kavram

Custom Report Type Object Relationships and Layout Field Customization
Bu soruyu puanla