Skip to content
Tutorials Center
My learning

Topics

Lesson 24 of 36 ยท Reports and Dashboards

Report Types and Report Formats in Salesforce

Understand Salesforce reports: standard and custom report types, object relationships, tabular, summary, matrix and joined formats, and how to choose one, with a JavaScript stand-in.

A report answers a question about your data: which opportunities close this quarter, how many cases are open by owner, which accounts have no contacts. Reports are the way managers see what the CRM contains, and building them well is a core administrator skill. Two choices shape every report before you add a single filter: the report type (which records and relationships are available) and the format (how the results are laid out).

The Salesforce screens are described in words here, because the product cannot run on this site. The code is a labelled JavaScript stand-in that models how reports group and summarize data.

Report types

A report type defines which objects the report reads and how they are related. You choose it first (Reports tab, then New Report, then pick a category and a type). It decides which fields you can show and filter.

  • Standard report types come with Salesforce, for example Accounts, Opportunities, Cases, Accounts with Contacts, Opportunities with Products, Activities with Leads.
  • Custom report types are created by an admin (Setup, then Report Types, then New Custom Report Type). You pick a primary object and add up to three related objects (four in total), choosing for each whether the child records are required or optional.

The two relationship styles matter:

  • "A with B": only primary records that have at least one related B record appear (an inner join). Accounts with Contacts lists accounts that have contacts.
  • "A with or without B": all primary records appear, whether or not they have B records (a left join). This is what you want for "accounts with no contacts": choose with or without, then filter for a blank contact (or use a cross filter, see Filters, buckets and formulas).

You can also store a custom report type in a category so users find it, set it to In Development or Deployed, and edit its layout to add or rename fields, including fields from lookup objects. Deploy only when it is ready, because users will start building on it.

flowchart LR
  A["Accounts (primary)"] -->|"A with B"| C["Contacts"]
  C -->|"with or without"| O["Opportunities via Contact Role"]

A custom report type: the primary object and up to three related objects, each with a required or optional link.

Report formats

After picking a type, you choose how the data is displayed. Lightning Report Builder lets you switch formats at any time.

Format What it does Use for
Tabular A plain table of rows, like a spreadsheet; no groupings or subtotals Simple lists and exports
Summary Rows grouped by one to three fields, with subtotals "Opportunities by Stage", "Cases by Owner"
Matrix Groups by rows and by columns, like a pivot table "Revenue by Region (rows) and by Quarter (columns)"
Joined Up to five blocks, each a different report type, shown side by side Comparing unrelated data in one place, like accounts with cases and accounts with opportunities

Choose the simplest format that answers the question. Many reports are better as summary reports than as long tabular lists, because the grouping makes patterns visible.

Joined reports have extra rules: blocks can use different report types and share common fields called cross-block fields; you can add summary formulas that apply across blocks. They support fewer filters and fewer dashboard uses than other formats.

Parts of the report builder

  • Fields panel: the list of fields of the type. Drag them into the report or double-click.
  • Outline panel: the columns, the groupings (up to 3 in summary, 2 rows and 2 columns in matrix) and the choice of row limit.
  • Filters panel: standard filters (Show Me, date range) plus field filters, Filter Logic and cross filters.
  • Add Chart: bar, column, line, donut, funnel, scatter and more, using the groupings.
  • Preview: a sample of the rows while you build, which is quick even on huge data. Run the report to get the full result.
  • Save, Save As, Run: you pick a folder when you first save.

A summary or matrix report has Summarize options on number columns: Sum, Average, Max, Min. You can also show or hide details, and show grand totals or subtotals.

Rows, limits and performance

  • The report run page displays up to 2,000 rows of detail; larger result sets are cut off there (summaries and exports still use all rows, subject to export limits).
  • A summary report can have three groupings; a matrix two rows and two columns.
  • Use selective filters (date ranges, owners, record types) so reports run fast. Filter on indexed fields where possible.
  • Reports run as the viewer by default, so each user only sees the records they have access to (record sharing applies). Dashboards use a running user (see Dashboards and components).

Stand-in: tabular to summary to matrix

This is not Salesforce. It takes rows and shows the same data as a tabular list, a summary report grouped by one field, and a matrix grouped by two fields.

JS Stand-in: three formats from one dataset

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Stand-in: "with" versus "with or without"

JS Stand-in: inner join versus left join

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Choosing quickly

  1. Which object holds the thing I am counting? Make it the primary object of the report type.
  2. Do I need records that have no children? Use "with or without".
  3. Do I need totals by a category? Summary. By two categories? Matrix. Just a list? Tabular.
  4. Do I need two unrelated measures side by side? Joined.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Which custom report type relationship lists accounts that have no contacts?

    'With or without' keeps every primary record, so blank related records can be filtered for.
  2. 2. Which format works like a pivot table with row and column groupings?

    Matrix groups by rows and by columns.
  3. 3. How many related objects can a custom report type add to its primary object?

    A custom report type has a primary object plus up to three related objects.
  4. 4. A report is run by two users with different record access. What do they see by default?

    Reports run as the viewer, so sharing and field security apply.

Summary

  • The report type decides which objects, joins and fields exist; the format decides how results are shown.
  • Use "with or without" when you need records that have no related records.
  • Tabular lists, summary groups (up to three levels), matrix cross-tabulates, joined shows several report types in blocks.
  • Reports respect each viewer's access.

Next: Filters, buckets and formulas