Building a useful report takes deliberate design, not just clicking through the wizard. Pick the right Report Type, set focused filters, choose the format that fits the analytical question, group meaningfully, and verify the numbers against a known reference. The best reports answer one specific question cleanly rather than displaying every possible column.
- Identify the question the report answers
State the question in one sentence. "Which open opportunities owned by my team close this quarter?" beats "Show opportunity data." The question shapes the Report Type, filters, groupings, and chart choices.
- Pick the Report Type
App Launcher > Reports > New Report. Pick a Report Type that includes the primary object and any related objects needed. Use standard Report Types when they fit; build custom Report Types for cross-object analysis the standard ones do not support.
- Add and configure filters
Filters panel > add filters for the time range, ownership, stage, status, or whatever narrows the data to the question. Use cross-filters for records that need a related record (Accounts with Opportunities) or the absence of one (Accounts without Activities in the last 30 days).
- Choose the format and add groupings
Tabular for flat exports. Summary for grouped totals. Matrix for cross-tabs. Joined for multi-block comparisons. Add Group Rows and Group Columns based on the question. Each grouping produces subtotals automatically.
- Select columns and reorder them
Drag fields from the Fields panel onto the report. Reorder columns by dragging headers. Remove columns that do not help answer the question; clutter reduces readability and slows the report.
- Add summary formulas and bucket fields
Add Formula for derived metrics: percentage of total, win rate, average deal size. Bucket fields for ad-hoc categorization without modifying the underlying data: bucket Amount into Small, Medium, Large ranges.
- Add a chart and conditional highlighting
Chart icon > pick a chart type and configure axes. Conditional Highlighting > set thresholds for color coding. The chart and highlighting should reinforce the question being asked.
- Save to the right folder and configure sharing
Save the report to a folder that matches its audience. Confirm folder sharing covers the right users. Test by logging in as a representative user to verify they can see it and the data matches expectation.
Defines which objects, relationships, and fields are available. The foundational design choice that constrains every other option.
Tabular, Summary, Matrix, or Joined. Determines how groupings and summaries render and which chart types are available.
Combines filters with AND, OR, and NOT operators. Default is AND across all filters; custom logic lets you build complex criteria.
- Reports cap at 2,000 rows in the preview and 50,000 rows for export. Larger result sets need pagination, Bulk API queries, or CRM Analytics.
- Report Type choice constrains every other report option. Picking the wrong Report Type means rebuilding the report from scratch because the field list cannot be expanded mid-build.
- Filters on non-indexed fields with high cardinality can time out on large objects. Use indexed fields (Id, Name, Owner, External ID) wherever possible for fast filter evaluation.
- Cross-filters are powerful but expensive on large data sets. Each cross-filter adds a sub-query; multiple cross-filters can produce queries that exceed report timeout limits.
- Folder access controls report visibility. Saving a report to the wrong folder either hides it from the intended audience or exposes it to people who should not see it.