---
schema_version: "1"
id: 2b500e14d4e6b042b757abd8b794dd1fa6d3fd1a64c807986e08873fc4349019
title: Why doesn’t my report return the data I expect?
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/faq_reports_why_doesnt_my_report.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.faq_reports_why_doesnt_my_report.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b8cf258ffb5a3a13b44c652cae9115b111ed7decaf5a6c7c49a9ee0d1c491d78
description: Check your filters, groupings, fields, report type, and role or user hierarchy to make sure that you are asking the right questions of your data.
products:
  - Cross Cloud
release: "264"
---
# Why doesn’t my report return the data I expect?

Check your filters, groupings, fields, report type, and role or user hierarchy to make sure that you are asking the right questions of your data.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small " summary="Command Center Glossary">
        <caption>Command Center Glossary</caption>
        <colgroup>
          <col style="width:20.08032128514056%">
          <col style="width:79.91967871485943%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d24709e41">Feature</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d24709e44">What to look out for</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Feature" class="slds-cell-wrap" style="vertical-align:top;" headers="d24709e41 ">Filters</td>

            <td data-label="What to look out for" class="slds-cell-wrap" style="vertical-align:top;" headers="d24709e44 ">
              <p>Make sure to include all the data you want.
              </p>
              <p style="margin-bottom:0;">To change a report filter, hover over it and click <strong class="uicontrol">Edit</strong>
                or <strong class="uicontrol">Remove</strong>. Your filters display when you run your report;
                click <strong class="uicontrol">Edit</strong> on that page to make additional changes.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Feature" class="slds-cell-wrap" style="vertical-align:top;" headers="d24709e41 ">Groupings</td>

            <td data-label="What to look out for" class="slds-cell-wrap" style="vertical-align:top;" headers="d24709e44 ">When you group by a field, you remove it from the details of the report. If
              you export the report, you see the field, though it doesn’t appear in the detail area.</td>

          </tr>
          <tr class="">
            <td data-label="Feature" class="slds-cell-wrap" style="vertical-align:top;" headers="d24709e41 ">Fields</td>

            <td data-label="What to look out for" class="slds-cell-wrap" style="vertical-align:top;" headers="d24709e44 ">After checking your groupings, check your fields. If your report contains
              multiple related records—for example, an account, its opportunities, and
              their products—look at the detail pages for the account record, opportunity
              record, and product line item to ensure that the fields contain data. If the data isn't
              available in the format you want, work with your Salesforce administrator to add
              formula fields to get the data. When formula fields are added to an object, they
              appear in record detail pages and in reports.</td>

          </tr>
          <tr class="">
            <td data-label="Feature" class="slds-cell-wrap" style="vertical-align:top;" headers="d24709e41 ">Report Type</td>

            <td data-label="What to look out for" class="slds-cell-wrap" style="vertical-align:top;" headers="d24709e44 ">
              <p>The report type selected isn't appropriate or the records anticipated don't
                share the relationship between objects required for the report type. When choosing a
                report, be sure you understand which fields are available in the report type. </p>
              <p style="margin-bottom:0;">If your
                report type includes both parent and child objects, but no child fields are used in a
                report, the report shows parent records whether they have a child record or not.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Feature" class="slds-cell-wrap" style="vertical-align:top;" headers="d24709e41 ">Hierarchy</td>

            <td data-label="What to look out for" class="slds-cell-wrap" style="vertical-align:top;" headers="d24709e44 ">
              <p><strong class="uicontrol">Hierarchy</strong> options let you drill down to different
                datasets based on the role or user hierarchy. The selected hierarchy level, or its
                default role, can affect the data shown.</p>
              <p style="margin-bottom:0;">Hierarchy applies to activity and
                opportunity reports.</p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Feature" class="slds-cell-wrap" style="vertical-align:top;" headers="d24709e41 ">External Objects</td>

            <td data-label="What to look out for" class="slds-cell-wrap" style="vertical-align:top;" headers="d24709e44 ">If your report includes an external object, the results probably don’t reflect
              the full dataset. 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 20,000 records for the primary object and can
              encounter callout limits while fetching external object data. <span>If the report
                results in few or no rows, try customizing the report to obtain more relevant
                external object rows.</span></td>

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