Skip to main content

SF-0199 · Concept · Medium

What is the maximum number of blocks allowed in a joined report?

✓ Verified by Vikas Singhal · Last reviewed 5/17/2026 · Updated for Spring '26

A Joined Report supports a maximum of 5 blocks. Each block is its own self-contained mini-report — its own report type, filters, groupings, and columns — running side by side in the same report viewer.

Why 5

Five gives admins enough flexibility for multi-perspective views (Opps + Cases + Activities + Quotes + Knowledge linked to an Account, say) without making the report unreadable or unmanageably slow. Two or three blocks is the practical sweet spot for most use cases; five is the ceiling.

Other relevant limits on joined reports

LimitValue
Blocks per Joined Report5
Groupings per block3
Custom summary formulas per Joined Report10
Cross-block summary formulasYes — calculate across blocks
Charts per Joined Report1 chart per report; chart pulls from one block
Bucket fields in JoinedNot supported
Cross filters in JoinedNot supported

Examples within the limit

Block 1: Opportunities by Stage
Block 2: Cases by Status
Block 3: Activities by Type
Block 4: Knowledge Articles attached
Block 5: Quotes by Status

Or in a sales-only context:

Block 1: Open Opps this quarter
Block 2: Won Opps this quarter
Block 3: Lost Opps this quarter

What happens if you try to add a 6th

Salesforce greys out the Add Block button once you hit 5. The workaround is either:

  • Drop one of the existing blocks
  • Build a second Joined Report alongside the first
  • Move some logic into a Summary or Matrix report and link the two on a dashboard

Performance implications

Each block is essentially its own query. A 5-block joined report runs 5 queries serialised, then assembled in the report viewer. For high-volume orgs:

  • Use selective filters per block (indexed fields)
  • Avoid 5-block reports on millions-of-records objects
  • Consider Tableau CRM / CRM Analytics for true multi-dataset analysis

Common follow-ups

  • 5 — strict or soft limit? — Hard limit. The UI prevents going above.
  • Can blocks have unrelated report types? — Yes — but they should share a useful dimension for the report to be coherent.
  • How many groupings within a block? — 3 groupings per block.

Verified against: Salesforce Help — Joined Report Limits. Last reviewed 2026-05-17 for Spring ‘26.