---
schema_version: "1"
id: 74134410a957e2e37ee259a46cfb43dffb99470ae43a35100d662dc675864647
title: Limit Report Results
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/reports_limiting.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.reports_limiting.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2889e0e325219d333e1ffbf49da812e46485c24d673bdd4675c353b8c3b952b5
description: Set limits to the scope of your report to avoid processing too many records. The built-in choices for limiting your results vary according to the object you’re reporting on.
products:
  - Cross Cloud
release: "264"
---
# Limit Report Results

Set limits to the scope of your report to avoid processing too many records. The built-in choices for limiting your results vary according to the object you’re reporting on.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Essentials</strong>, <strong>Group</strong>, <strong>Professional</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
      <colgroup>
        <col style="width:50%">
        <col style="width:50%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="vertical-align:top;" id="d15468e80">User Permissions Needed</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d15468e80 ">To create, edit, and delete reports:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d15468e80 ">
            <p>Create and Customize Reports </p>
            <p>AND</p>
            <p style="margin-bottom:0;">Report Builder</p>
          </td>

        </tr>
      </tbody>
    </table>

- To see a collapsed view of a report showing only the headings, subtotals, and total in report builder, deselect **Show** | **Details**.
    
    On the report run page, click **Hide Details** or **Show Details** at the top of the report.
- To filter by a field, click **Add** | **Field Filter**. With tabular, summary, and matrix reports, you can drag a field from the Fields pane to the Filters pane to add a report filter.
- As you create and work with cross filters, take note of these considerations and limits. To add one, click **Add** | **Cross Filter**.
- In Professional, Enterprise, Unlimited, Performance, and Developer edition organizations, the **Hierarchy** links let you browse report results based on the role or territory hierarchies.
- If your organization uses divisions to segment data and you have the “Affected by Divisions” permission, use the Division dropdown list to include records in just one division or all divisions. To show records in your current working division, select Current. Reports that are already scoped (such as My Cases or My team’s accounts) include records in all divisions, and you can't further limit them to a specific division. If you don’t have the “Affected by Divisions” permission, your reports include records in all divisions.
- You can set the maximum number of records to display in a tabular report by clicking **Add** | **Row Limit** in report builder. Set the number of rows, then choose a field to sort by, and the sort order. [Limiting rows on a tabular report](https://help.salesforce.com/s/articleView?id=analytics.reports_tabular_in_dashboards.htm&release=264.0.0&type=5 "You can use a tabular report as the source report for a dashboard table or chart widget if you limit the number of rows it returns.") allows you to use it as a source report for dashboard table and chart widgets. If you change the report format, Row Limit settings are lost.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-analytics-264-0-0-production-enus/295fead5-b71d-4e1c-9886-4af4d53400b6/images/icon_note.png)

Note Only the first 255 characters in a custom text field count for filtering purposes. For example, if you add a field filter to find opportunities where the custom text field Customer notes includes the word “phone,” but “phone” appears after the 255th character in the field, the filter doesn’t find the record. In standard text fields, all characters count, regardless of the length of the field.

#### See Also

- [Filter Across Objects with Cross Filters](https://help.salesforce.com/s/articleView?id=analytics.reports_cross_filters.htm&release=264.0.0&type=5 "Use a cross filter to fine-tune your results by including or excluding records from related objects and their fields, without having to write formulas or code. You can apply cross filters by themselves, or in combination with field filters.")