As you report on your data, be aware of these limits and restrictions.
Available in: both Salesforce Classic and Lightning Experience
Available in: All editions except Database.com
Salesforce Reports and Dashboards Limits
Unlimited and Performance Edition
Custom report types
(Limits apply to all custom report types regardless of development status.)
3 per dashboard
Dynamic dashboards per org
Up to 5
Up to 10
Up to 3
Field filters per report1
Formulas per report
12, 3, 4
12, 3, 4
Scheduled dashboard refreshes
Scheduled reports per hour
(Emailed reports can be up to 10 MB.)
12, 3, 5
12, 3, 5
1 These limits apply to the report builder. If you’re using the report wizard, the limit is 10.
2Up to 200 total.
3 Off-peak hours (between 6 PM and 3 AM local time) only.
4 Limited to one preferred start time per day.
5 Limited to three preferred start times per day.
Salesforce retains historical data for the previous three months, plus the current month.
The following Salesforce Reports and Dashboards limits apply to all supported editions.
The report builder preview shows a maximum of 20 rows for summary and matrix reports, and 50 rows for tabular.
You can't have more than 250 groups or 4,000 values in a chart. If you see an error message saying that your chart has too many groups or values to plot, adjust the report filters to reduce the number. In combination charts, all groups and values count against the total.
Reports display a maximum of 2,000 rows. To view all the rows, export the report to Excel or use the printable view for tabular and summary reports. For joined reports, export is not available, and the printable view displays a maximum of 20,000 rows.
Summary and matrix reports display the first 2,000 groupings when Show Details is disabled.
Matrix reports display a maximum of 400,000 summarized values.
Matrix reports display a maximum of 2,000 groupings in the vertical axis when Show Details is disabled. If there are more than 400,000 summarized values, rows are removed until the 2,000 groupings limit is met, then columns are removed until the number of summarized values moves below 400,000.
Matrix reports that return more than 2,000 rows don't show details. If you click Show Details, nothing happens. You can only view the report with details hidden.
Up to five metrics display in the Lightning Experience report header. Metrics such as summarized fields appear in the order that they appear in the report, left to right. The grand total, when shown, always displays.
When reports that have groupings are viewed in Salesforce1, they’re converted to tabular reports.
By default, reports time out after 10 minutes.
In a joined report, each block can have up to 100 columns. A joined report can have up to 5 blocks.
You can add up to 10 custom summary formulas to each block in a joined report. A joined report can have a total of 50 custom summary formulas.
Each joined report can have up to 10 cross-block custom summary formulas.
When you filter on standard long text area fields, such as Description or Solution Details, only the first 1000 characters of the field are searched for matches in reports.
Only the first 254 characters in a rich text area or a long text area are displayed in a report.
Summary fields on tabular, summary, and matrix reports can display up to 21-digits.
Reports can’t be filtered on custom long text area fields.
Joined reports require that the new user interface theme is enabled. Users without the new theme are unable to create, edit, or run joined reports.
Forecast reports include only opportunities that are set to close within the forecast period, except those assigned to the Omitted forecast category.
Internet Explorer 6 is not supported for joined reports.
Acceptable range for values: The maximum value allowed is 999999999999999.The minimum value allowed is -99999999999999.
A dashboard filter can have up to 50 options. By default, 10 options are enabled. Contact Salesforce to extend your limit.
Each dashboard can have up to 20 components.
It’s not possible to filter on bucket fields. However, it is possible to use a report filtered on a bucket field on the dashboard page.
A dashboard table or chart can display up to 20 photos.
You must wait at least one minute between dashboard refreshes.
Report Type Limits
A custom report type can contain up to 60 object references. For example, if you select the maximum limit of four object relationships for a report type, then you could select fields via lookup from an additional 56 objects. However, users will receive an error message if they run a report from a custom report type and the report contains columns from more than 20 different objects.
You can add up to 1000 fields to each custom report type.
Reporting Snapshot Limits
The maximum number of rows you can insert into a custom object is 2,000.
The maximum number of runs you can store is 200.
The maximum number of source report columns you can map to target fields is 100.
Only the first 255 characters in a custom text field count for filtering purposes.
Embedded Report Charts Limits
You can have two report charts per page.
You can only add report charts from the enhanced page layout editor. The mini console and the original page layout editor are not supported.
On detail pages, users can refresh up to 100 report charts every 60 minutes.
Your org can refresh up to 3,000 report charts every 60 minutes.
List View Limits
Only the first 255 characters are shown for custom long text area fields in list views.
Bucket and Bucket Field Limits
Each report can include up to five bucket fields.
Each bucket field can contain up to 20 buckets.
Each bucket can contain up to 20 values.
Bucket fields are available for use only in the report where they’re generated. To use a bucket in multiple reports, create the field for each report, or create a separate formula field for the object that’s dependent on the bucket.
These limits don’t apply to the use of Other as permitted within the bucket field’s setup.
Buckets and bucket fields aren’t available for reports that include external objects.
External Object Report Limits
If your report includes an external object, the results probably don’t reflect the full data set. External objects behave similarly to custom objects, except that they map to data that’s stored outside your Salesforce org. A report that includes an external object fetches up to 2,000 records for the primary object and can encounter callout limits while fetching external object data. If the report results in few or no rows, try customizing the report to obtain more relevant external object rows.
Reports and Dashboards API Limits
The following limits apply to both the Reports and Dashboards REST API and Reports and Dashboards API via Apex.
Cross filters, standard report filters, and filtering by row limit are unavailable when filtering data.
Historical trend reports are only supported for matrix reports.
The API can process only reports that contain up to 100 fields selected as columns.
A list of up to 200 recently viewed reports can be returned.
Your org can request up to 500 synchronous report runs per hour.
The API supports up to 20 synchronous report run requests at a time.
A list of up to 2,000 instances of a report that was run asynchronously can be returned.
The API supports up to 200 requests at a time to get results of asynchronous report runs.
Your organization can request up to 1,200 asynchronous requests per hour.
Asynchronous report run results are available within a 24-hour rolling period.
The API returns up to the first 2,000 report rows. You can narrow results using filters.
You can add up to 20 custom field filters when you run a report.
Your org can request up to 200 dashboard refreshes per hour.
Your org can request results for up to 5,000 dashboards per hour.