Report Type Strategy
Custom Report Types (CRTs) determine which objects can be reported
on together, with what join semantics, and which fields appear in
the report builder. They are the substrate every report sits on
top of. Standard report types ship with the platform for the
common shapes ("Accounts and Contacts", "Opportunities"). CRTs
exist for everything else: custom-object joins, with-without
queries, and curated field sets.
The decision matrix is small. Use a standard report type when one
exists for your shape and the field set is acceptable. Create a
CRT when (a) the join you need does not exist as a standard, (b)
you need an A-with-B-without (or A-without-B) join semantic
unavailable on the standard, (c) you need to expose a custom
object as the primary, or (d) you need to curate the field list
because the standard exposes too many fields and overwhelms the
admin. Build a joined report (a report that combines multiple
report types) only when one CRT cannot model the shape — joined
reports have their own constraints (no cross-block formulas
across all blocks, no cross-block filters in some cases).
The hard parts are the join semantics and the 60-field display
limit. A primary-with-secondary CRT inner-joins by default; a
"with or without" CRT outer-joins (rows from primary that have
no secondary still appear). Once a CRT is created, the join
shape cannot be edited — only the field layout can. The
60-field limit is a display cap (the field-picker UI shows 60);
the underlying CRT supports up to 1,000 fields, but anything past
60 is reachable only through search.
Recommended Workflow
- Confirm a standard report type does not already cover this.
Setup → Report Types → Show All; filter by primary object.
Most "Account" and "Opportunity" shapes are already there.
- Decide the join shape before creating the CRT. A → B
inner: "Accounts with Contacts" — Accounts that have ≥1
Contact. A → B with-or-without: "Accounts with or without
Contacts" — every Account; Contacts join when present. A →
B without: cannot be modeled as a single CRT — needs a
subtraction in a joined report or a Cross Filter.
- Pick the primary object as the one users always need on
every row. Secondary objects are optional rows. Tertiary
("related via lookup") joins go through a lookup field on the
secondary.
- Curate the field list deliberately. Add only the fields
users will reference. Group by section ("Account Information",
"Lead Source") so the field picker is scannable. Adding all
1,000 fields produces an unusable picker.
- Set up the CRT layout in two passes. First pass: bring in
every field you might need. Second pass: hide the ones you
don't, group the rest. The hidden fields can still be added by
savvy users via search; they don't clutter default layouts.
- Document the report type's purpose. The CRT description
field is small but visible in the report-builder picker. "Use
for renewals tracking. Excludes closed-lost." beats "Custom
Account Reporting".
- Test access by running as a low-privilege user. CRTs
inherit object permissions; if Sales Reps can't see the
tertiary object, the report row collapses to whatever they can
see.
When To Reach For Joined Reports
Joined reports stitch results from multiple report types into one
output, side by side. Use when a single CRT cannot model the
shape: cross-object summary alongside detail, "this quarter vs
prior" comparisons, A-without-B as a subtraction. They are more
fragile (cross-block formulas have limits, some filters apply
per-block) but they are the only single-report answer for
multi-shape data.
What This Skill Does Not Cover
- Designing individual reports (filters, summaries, charts)
— see
admin/reports-and-dashboards-fundamentals.
- Dashboard composition — see
admin/reports-and-dashboards.
- Reports API / Reporting Snapshot — not covered here; the
closest guidance is async report execution via the Analytics API
in
admin/report-performance-tuning.
- Big Object reporting — see
data/external-data-and-big-objects.
1---2name: report-type-strategy3description: "Custom Report Type design — when to create a CRT vs use the standard, A-with-B-without and A-without-B joins, primary/secondary/related-via-lookup objects, the 60-field display limit, and field-set vs cross-join layouts. NOT for building the report or dashboard itself once the report type exists — use admin/reports-and-dashboards-fundamentals."4category: admin5salesforce-version: "Spring '25+"6well-architected-pillars:7 - Operational Excellence8 - Performance9triggers:10 - "custom report type vs standard report type"11 - "report type a with b without related"12 - "report type primary secondary tertiary object"13 - "salesforce report type 60 field display limit"14 - "report type which fields are reportable"15 - "joined report custom report type"16 - "report builder cannot find object combination"17 - "custom report type in development not deployed"18 - "accounts without contacts child field filter contradiction"19tags:20 - reports21 - custom-report-type22 - data-access23 - field-availability24 - performance25inputs:26 - "Primary object and the join shape (with/without related, lookup vs master-detail)"27 - "Field set users actually need (vs everything on the object)"28 - "Whether the report type will be packaged or org-only"29outputs:30 - "Decision: create CRT, reuse standard, or build a joined report"31 - "Object hierarchy (primary, secondary, optional tertiary, related-via-lookup) with join semantics"32 - "Field layout grouped by section, within the 1,000-field cap and 60-display limit"33dependencies: []34version: 1.0.035author: Pranav Nagrecha36updated: 2026-08-1437metadata:38 source: https://skillmd.com/skills/pranavnagrecha/report-type-strategy39---4041# Report Type Strategy4243Custom Report Types (CRTs) determine which objects can be reported44on together, with what join semantics, and which fields appear in45the report builder. They are the substrate every report sits on46top of. Standard report types ship with the platform for the47common shapes ("Accounts and Contacts", "Opportunities"). CRTs48exist for everything else: custom-object joins, with-without49queries, and curated field sets.5051The decision matrix is small. Use a standard report type when one52exists for your shape and the field set is acceptable. Create a53CRT when (a) the join you need does not exist as a standard, (b)54you need an A-with-B-without (or A-without-B) join semantic55unavailable on the standard, (c) you need to expose a custom56object as the primary, or (d) you need to curate the field list57because the standard exposes too many fields and overwhelms the58admin. Build a *joined report* (a report that combines multiple59report types) only when one CRT cannot model the shape — joined60reports have their own constraints (no cross-block formulas61across all blocks, no cross-block filters in some cases).6263The hard parts are the join semantics and the 60-field display64limit. A primary-with-secondary CRT inner-joins by default; a65"with or without" CRT outer-joins (rows from primary that have66no secondary still appear). Once a CRT is created, the join67shape cannot be edited — only the field layout can. The6860-field limit is a *display* cap (the field-picker UI shows 60);69the underlying CRT supports up to 1,000 fields, but anything past7060 is reachable only through search.7172## Recommended Workflow73741. **Confirm a standard report type does not already cover this.**75 Setup → Report Types → Show All; filter by primary object.76 Most "Account" and "Opportunity" shapes are already there.772. **Decide the join shape before creating the CRT.** A → B78 inner: "Accounts with Contacts" — Accounts that have ≥179 Contact. A → B with-or-without: "Accounts with or without80 Contacts" — every Account; Contacts join when present. A →81 B without: cannot be modeled as a single CRT — needs a82 subtraction in a joined report or a Cross Filter.833. **Pick the primary object as the one users always need on84 every row.** Secondary objects are optional rows. Tertiary85 ("related via lookup") joins go through a lookup field on the86 secondary.874. **Curate the field list deliberately.** Add only the fields88 users will reference. Group by section ("Account Information",89 "Lead Source") so the field picker is scannable. Adding all90 1,000 fields produces an unusable picker.915. **Set up the CRT layout in two passes.** First pass: bring in92 every field you might need. Second pass: hide the ones you93 don't, group the rest. The hidden fields can still be added by94 savvy users via search; they don't clutter default layouts.956. **Document the report type's purpose.** The CRT description96 field is small but visible in the report-builder picker. "Use97 for renewals tracking. Excludes closed-lost." beats "Custom98 Account Reporting".997. **Test access by running as a low-privilege user.** CRTs100 inherit object permissions; if Sales Reps can't see the101 tertiary object, the report row collapses to whatever they can102 see.103104## When To Reach For Joined Reports105106Joined reports stitch results from multiple report types into one107output, side by side. Use when a single CRT cannot model the108shape: cross-object summary alongside detail, "this quarter vs109prior" comparisons, A-without-B as a subtraction. They are more110fragile (cross-block formulas have limits, some filters apply111per-block) but they are the only single-report answer for112multi-shape data.113114## What This Skill Does Not Cover115116- **Designing individual reports** (filters, summaries, charts)117 — see `admin/reports-and-dashboards-fundamentals`.118- **Dashboard composition** — see `admin/reports-and-dashboards`.119- **Reports API / Reporting Snapshot** — not covered here; the120 closest guidance is async report execution via the Analytics API121 in `admin/report-performance-tuning`.122- **Big Object reporting** — see `data/external-data-and-big-objects`.