A tabular report is the fastest report format to build in Salesforce. The steps below cover the common path from a blank report to an exportable list.
- Pick a report type
Open Reports, click New Report, pick the report type that exposes the object and fields you need. A tabular report can use any standard or custom report type.
- Add filters before columns
Add filters first to narrow the row count. Common filters are a date range, a status, a record owner, an Active = true flag. Tight filters cut render and export time significantly on large objects.
- Add the columns you want
Drag fields from the Fields panel to the Columns shelf. Order matters for export readability. Keep the column count modest because wide reports are slow to render and slower to export.
- Run, then refine
Click Run to see the rows. Sort by a column header. Add or remove filters until the result is what the consumer of the report actually needs. Save with a descriptive name and a folder shared to the right audience.
- Export or schedule
Use Export from the report toolbar for ad-hoc CSV downloads. For recurring delivery, subscribe the report to a schedule so the list arrives in the inbox of the people who use it daily.
Caps the number of rows the report returns. Required when you want to use the tabular report as the source for a dashboard component.
Available only on summary, matrix, and joined formats. Not available on tabular because there are no aggregate values to colour-code.
Always on for tabular reports. There are no subtotal rows to hide, so the Detail Rows toggle has no effect.
- Tabular reports cannot power most dashboard components without a row limit. The Lightning Report Builder refuses to save a dashboard widget from a tabular source unless the row limit is set.
- The 2,000-row viewer cap is just the in-browser viewer. The export limits (25,000 formatted or 100,000 details-only) are the real ceilings. For larger pulls, use the Reports API or a data warehouse export.
- Reporting Snapshots require tabular source reports. Summary or matrix snapshots silently fail with a configuration error. Always check the source format before setting up a snapshot.