Skip to main content

Format Your Report

Learning Objectives

After completing this unit, you'll be able to:

  • Describe report formats: tabular, summary, and matrix.
  • Create a matrix report.
Note

Accessibility

This unit requires some additional instructions for screen reader users. To access a detailed screen reader version of this unit, click the link below:

Open Trailhead screen reader instructions.

Use Report Formats

There are three report formats available: Tabular, Summary, and Matrix. Tabular is the default format.

Report Format

Primary Use Case

Supported in Dashboards

Report Charts Supported

Bucket Fields**

Formulas**

Cross-Object Formulas**

Tabular

Make a list

Check icon indicating true*

Check icon indicating true

Summary

Group and summarize

Check icon indicating true

Check icon indicating true

Check icon indicating true

Check icon indicating true

Matrix

Group and summarize, by row and column

Check icon indicating true

Check icon indicating true

Check icon indicating true

Check icon indicating true

* Row limit required. Learn more here.

** Bucket fields and formulas are not covered in this module.

Let’s walk through building a sample report for each report format.

Tabular Reports

Tabular reports are the simplest and fastest way to look at your data. Similar to a spreadsheet, they consist simply of an ordered set of fields in columns, with each matching record listed in a row. They're often best used for tasks like generating a mailing list. When Lincoln asked Maria for a report of all open opportunities, Maria knew that a tabular report would fit the bill.

Let’s help Maria build the tabular report.

Note

Depending on which org you’re using to practice these steps, you may or may not see data in your report at runtime. When you’re ready to preview data, manually refresh the report preview. Or, see sample records returned after each edit by turning automatic previews on.

  1. On Reports, click New Report, choose the ‘Opportunities’ report type, and click Start Report.
  2. Click Filters, then apply the following filters:
    • For the Show Me standard filter, select All opportunities and click Done.
    • For the Opportunity Status standard filter, select Open and click Apply.
    • For the date standard filter, select Created Date and All Time for the range and click Apply.
      For your Trailhead playground, we're suggesting All Time for the range, but for the fastest results in your production environment, always set the smallest date range you can. If your report has to sift through a great many dates, it can take longer to show the information you’ve asked for.
  1. The following columns should already be included in your report: Opportunity Name, Type, Lead Source, Amount, Close Date, Next Step, Stage, Probability (%), Fiscal Period, Age, Created Date, Opportunity Owner, Owner Role, Account Name.
  2. Click Save.
  3. Name your report Open Opportunities This Year.
  4. Enter a description and save the report in the Public Reports folder.
  5. Click Run. The report should look something like this:

Tabular report example

Summary Reports

Summary reports are similar to tabular reports, but also allow you to group rows of data, view subtotals, and create charts. Summary reports give us many more options for organizing the data, and are great for use in dashboards. Yes!

Summary reports are the workhorses of reporting—most people find that most of their reports tend to be of this format.

Roberto Alvarez, COO of Ursa Major Solar, wants to know how many of the company's closed customer cases were high, medium, or low priority. Maria can help Roberto by building a summary report.

Note

Depending on which org you’re using to practice these steps, you may or may not see data in your report at runtime. When you’re ready to preview data, manually refresh the report preview. Or, see sample records returned after each edit by turning automatic previews on.

  1. From the Reports tab, click New Report, select the ‘Customer Support Reports’ category, choose the ‘Cases’ report type, and click Start Report.
  2. Click Filters, then apply these standard filters:
    • For Show Me, select All Cases and click Apply.
    • For Date Field, select Opened Date and All Time for the range. Then click Apply.
  1. From the Add filter picklist, apply a field filter for cases where Closed equals True.
    • Search for and select Closed.
    • From the dropdown list, select True and click Apply.
  1. Verify that these columns appear in your report: Case Owner, Subject, Date/Time Opened, Age, Open, Closed, and Account Name. If necessary, add them.
  2. To make this report a summary report, you need to group rows. To group rows, first click Outline.
  1. Under GROUP ROWS, from the Add group picklist, select Priority

  1. [Alt text: Creating a summary report]
  2. To see just the totals for each priority level, turn off Detail Rows at the bottom of the preview page.
  3. Save the report as Closed Cases for All Time, and accept the auto-generated unique name.
  4. Enter a description, choose the Public Reports folder, and click Save.
  5. Click Run. The report should look something like this:

Example of summary report

Note

Click Detail Rows to toggle between showing and hiding columns in your summary report.

Matrix Reports

Matrix reports allow you to group records both by row and by column. These reports are the most time-consuming to set up, but they also provide the most detailed view of your data.

So why would you want to use a matrix report? If you’re looking for an at-a-glance overview of data, especially for something like totals of revenue or quantity of products sold, then the matrix report format is for you.

Let’s build a matrix report. Sita, the CEO, is planning for the coming year and wants to know revenue trends, month over month.

Let’s start by helping Maria create the basic report. In this step, you’ll create a matrix report showing sales by type for each month.

Note

When you’re ready to preview data, manually refresh the report preview. Or, see sample records returned after each edit by turning automatic previews on.

  1. On the Reports tab, click New Report, choose the ‘Opportunities’ report type, and click Start Report.
  2. Click Filters, then apply these standard filters:
    • For the Show Me standard filter, select All Opportunities and click Done.
    • For the Opportunity Status standard filter, select Closed Won and click Apply.
    • For the Date Field standard filter, select Close Date. For Range, select All Time. Click Apply.
      For the fastest results, always set the smallest date range you can. If your report has to sift through a great many dates, it can take longer to show the information you’ve asked for.
  1. To summarize the report by Sum of Amount, click the dropdown arrow on the Amount column. Then, click Summarize and select Sum.
  2. To change the report format to matrix, first group rows by Close Month and columns by type. To start grouping, click Outline.
    • Under GROUP ROWS, from the Add group picklist, select Close Month.
    • Under GROUP COLUMNS, from the Add group picklist, select Type.
  1. You may want to hide the report details when viewing a matrix report. Matrix reports are usually easiest to consume with details hidden. To hide the report details, turn off Detail Rows.
  2. Save your report as Opportunities by Sum of Amount and accept the auto-generated unique name.
  3. Click Run Report.
  4. The report should look something like this. 

Example of matrix report

Resources

Share your Trailhead feedback over on Salesforce Help.

We'd love to hear about your experience with Trailhead - you can now access the new feedback form anytime from the Salesforce Help site.

Learn More Continue to Share Feedback