Loading

Report Does Not Display All Records or Shows Incorrect Results

Publiseringsdato: May 5, 2026
Beskrivelse

If one of your reports is either missing records or contains results that shouldn't display, try these suggestions.

Løsning
  1. Check the Report Type Selected.

    If you have multiple relationships between two objects, select the appropriate one to get the correct results.
    Example: In an "Opportunities with Contact Roles" report, any Opportunity without a Contact Role doesn't appear.

  2. Verify that the records expected fall into the TIME FRAME identified on the Salesforce reports.

    If no records fall within the defined reporting time frame, then no records are displayed on the report.

  3. Verify that the records expected fall into the FILTER CRITERIA section of the report.

    Example: If the record is an Opportunity that is "Closed/Won" and the filter is "Open," that record won't display.
    Review built-in filters like "All opportunities" or "My team's opportunities".

  4. Have fields from a Child Object been selected to be displayed, filtered upon, or summed in the Salesforce reports?

    Adding a field from a Child Object can result in the report dropping rows without a related record.

  5. Does every user have a role assigned to them? (displayed on user records)

    Activity and Opportunity reports rely on the Role or Territory Hierarchy to determine accessible records. Users without a Role assigned won't see their records in these reports.

    This applies to System Administrators as well, though administrators can click through the "Organization Drill Down."

  6. Reports created using a Custom Report Type don't follow the sharing rules on the Opportunity and Activity objects.

    Example:

    • When running an "Opportunities with Products" report, if no Product or Price book fields are selected, the report is treated as an "Opportunities" report. A field from these child objects requires that a relationship to be defined.

    • In the standard report type "Activities with Cases," Activities don't show unless they have a populated Contact Name field, even if related to a case. This usually occurs when an Activity is created through Email.

    • In the custom report type "Case with Activities," Activities related to a Case appear on the report, even without a Contact relation.

  7. Reports based on a "with" Custom Report Type may show varying results depending on selected fields.

    Review the following article for more details: Report 'Record Count' changes when 'Details' are hidden or exposed.
  8. Check your personal Time Zone setting.

    Users in different Time Zones may see different results in reports. When comparing results, ensure both users are assigned the appropriate Time Zone in their User Detail.
  9. Verify access to filtering fields.

    If your profile lacks "Read" access to fields used as report filters, these filters won't apply. This may lead to different results for different users. Contact your System Administrator if you believe you should have access to a specific field that isn't visible.
  10.  An "Accounts" Standard Report Type uses a "My territories' accounts" or "My territory team's accounts" filter.

    If an account belongs to multiple territories that the running user also belongs to, the account appears multiple times in the report. Using "My territory team's accounts" results in similar behavior. To return a single row for Accounts, consider using a Custom Report Type.
Knowledge-artikkelnummer

000385139

 
Laster
Salesforce Help | Article