Trail Map › Use-Case Catalog › Reports
📈 Growth & Insight · Module 06

Reports: A Live Number Instead of a Stale Spreadsheet

Give leadership an always-current answer inside the tool your team already works in — no exports, no BI team ticket.

4
Units
~10 min
Time to Complete
80 pts
Available
1 Badge
Insights Builder
Unit 1 · Business Problem

Why self-service reporting matters

SO
Sasha Ortiz · Sales Operations

"I want 'Closed Won this Quarter, by rep' live before Monday's standup — not a spreadsheet somebody exported on Friday afternoon that's already wrong by the time we look at it."

Every export-to-spreadsheet cycle introduces staleness and manual error. Leadership needs numbers that reflect the data as it exists right now, filtered exactly the way the business asks the question.

💡
Business outcome
An always-current answer inside the CRM itself — no data exports, no stale numbers, no dependency on a separate BI team.
Unit 2 · How It Works

Anatomy of a report

A report definition is just four decisions: which object, which fields, which filters, and how to group.

{ "name": "Q1 Opportunities", "objectApiName": "opportunity", "selectedFields": ["name", "amount", "stage", "close_date"], "filters": [{ "field": "stage", "operator": "EQUALS", "value": "Closed Won" }], "groupByField": "stage", "sortField": "amount", "sortDirection": "DESC" }
✅
Same rules, everywhere
Running a report re-uses the exact same sharing/visibility filter as record lists — a report can never surface a record its viewer isn't otherwise allowed to see.

Supported filter operators: EQUALS | NOT_EQUALS | CONTAINS | STARTS_WITH | GREATER_THAN | LESS_THAN | IS_BLANK | IS_NOT_BLANK. Every report can be exported straight to CSV on demand.

Unit 3 · Hands-On Challenge

Build "Closed Won This Quarter, by Rep"

Open the Report BuilderReports → New Report.
Pick the object and fieldsObject: Opportunity · Fields: name, amount, stage, close_date, owner.
Add filtersstage = "Closed Won" AND close_date within this quarter.
Group and sortGroup by: Owner · Sort by: amount, descending.
Save, run, and exportSave the report, click Run, then try the "Export CSV" button.
Unit 4 · Knowledge Check

Test what you learned

1. Do report results bypass a viewer's sharing/visibility restrictions?
Yes, reports always show every record in the org
No — reports apply the same sharing filter as record lists
2. Where does CSV export happen?
A background job you have to wait hours for
Streams directly to the browser — no server-side file storage