What we do
Tools
Industries
Department
How we workLet's talk →
Home/Salesforce/How to Create a Report in Salesforce Lightning
Salesforce Lightning

How to Create a Report in Salesforce, Step by Step

Every Salesforce report starts with a report type, and that choice decides which records and fields you can use. Get it right and the rest is filters and grouping. Here are the clicks, which format fits which question, and the fixes for a report that comes back empty.

Create a report in Salesforce

Go to the Reports tab and click New Report. Pick a report type (search by object name, for example Opportunities), then click Start Report.

Reports New Report Choose report type Start Report

Set Filters, add Columns, drag a field into Group Rows if you want subtotals, then Save & Run into a folder others can see.

Filters Columns Group Rows Save & Run

No Reports tab? Use the App Launcher and search Reports, or the Analytics tab, then Create, then Report.

Building the report

  1. 1

    Choose the report type

    New Report Choose Report Type

    The dialog lists categories and a search box. Opportunities gives you deals. Accounts and Contacts gives you companies and people. A type like Opportunities with Products adds the product lines on each deal. If nothing on the list joins the objects you need, an admin can build a custom report type in Setup.

    Watch for: you can't change the report type after you start. Picking the wrong one means building the report again.

  2. 2

    Set the filters first

    Open the Filters pane. Every report type starts with a few standard filters, such as whose records to show and a date range. Set those before anything else, because they're the usual reason a report looks wrong. Add field filters after, for example Stage equals Closed Won.

  3. 3

    Pick the columns

    Under Columns in the Outline pane, add the fields you need and remove the defaults you don't. Eight useful columns beat thirty.

  4. 4

    Group and summarize

    Drag a field into Group Rows (Owner, Stage, Close Date by month) to get subtotals. Add a second field to Group Columns for a grid, such as rep by quarter. To total a number column, open its menu and choose Summarize, then Sum or Average.

    Watch for: bucket fields and row-level formulas, under the Columns menu. A bucket groups several picklist values into one label, such as "Early stage" for three stages.

  5. 5

    Save & Run

    Name it so a colleague would find it, and save it to a shared folder rather than your private one. A report in Private Reports can't feed a dashboard other people use.

Which report format fits your question

In Lightning you don't pick the format up front. It follows from how you group the report, except for joined reports, which you switch to from the report builder.

Your question Format How you get it
"Give me the list" (for an export or a call list) Tabular No groupings. Just filters and columns.
"Totals by rep" or "deals by stage" Summary Add one or more fields under Group Rows.
"Each rep, each quarter, in a grid" Matrix Group by rows and add a field under Group Columns.
"Open deals and open cases for the same accounts, side by side" Joined Switch the format to joined, then add a block per report type. Blocks share a common field such as Account.

When the report looks wrong

No records, or far fewer than you expected

How you'll know: The report runs but shows a handful of rows, or none.

Fix: Check the standard filters. A default that shows only your own records, or only a short date range, hides everything else. Switch it to all records and widen the dates, then narrow down again.

The field you need isn't in the list

How you'll know: You search Columns and the field doesn't appear.

Fix: The report type doesn't include that object or field. Start a new report on a type that does, or ask your admin to add the field to a custom report type.

The dashboard shows people different numbers

How you'll know: You see one total, your manager sees another, from the same dashboard.

Fix: Check who the dashboard runs as in its properties. Set to a fixed person, everyone sees that person's data. Set to the viewer, it's a dynamic dashboard and each person sees only what their own access allows. Both are correct, they just answer different questions.

Turning the report into a dashboard

  1. 1

    Create the dashboard

    Dashboards New Dashboard Create

    Give it a name and pick a shared folder. You land in the dashboard builder.

  2. 2

    Add a component for each report

    Add a component, choose the source report, then pick a chart, gauge, metric or table. One report can feed several components. A component only charts what the report has grouped, so group the report first.

  3. 3

    Decide who it runs as

    In the dashboard properties, set who viewers see the data as: a fixed user, or the person viewing. Save, then subscribe yourself or the team so it arrives by email on a schedule.

When the number you need isn't in Salesforce

A Salesforce report can only read Salesforce. Ask "which closed deals have actually paid?" and the answer sits in QuickBooks or your ERP. Ask "can we ship what we sold this month?" and it sits in the inventory system. Teams answer it by exporting the report, pasting in a second export, and sending a spreadsheet that's out of date by Tuesday.

There are two ways out. Bring the outside numbers into Salesforce, through the Salesforce API or a sync onto a custom object, so the report builder can see them. Or build the combined dashboard outside Salesforce, where pipeline and payments sit side by side and people without a Salesforce login can see it too. n-frames builds both, and picks based on who needs to read the numbers.

Questions people ask

What is a joined report in Salesforce?

A joined report puts several report blocks on one page, and each block can use a different report type. The blocks are tied together by a field they share, usually Account. It's how you see a customer's open opportunities and their open cases in one view instead of running two reports.

How do I export a Salesforce report to Excel?

Run the report, open the menu next to Edit and choose Export. Formatted Report keeps the header, groupings and subtotals and downloads as an Excel file. Details Only gives one row per record, as Excel or CSV, which is easier to load into another spreadsheet or tool.

What is a dynamic dashboard in Salesforce?

A dashboard that runs as whoever is looking at it. Each person sees only the records their own permissions allow, so one dashboard can serve every rep without showing anyone the others' numbers.

What are the different report types in Salesforce?

Standard report types come with Salesforce and are built around objects like Opportunities, Leads, Accounts, Contacts and Cases, plus common combinations such as Opportunities with Products. Custom report types are built by an admin in Setup to cover a custom object or a mix of objects the standard ones don't.

Can a Salesforce report include data from outside Salesforce?

Not directly. A report only reads records stored in Salesforce. To report on outside data you either sync it into Salesforce first, onto a standard or custom object, or build the report outside Salesforce against both sources.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.