Salesforce Report Not Showing Records: Admin Debug Guide

5 min read · By a 2x Certified Salesforce Architect · 9 years, 12+ orgs

Understanding and Resolving the Issue of a Report Not Showing Records in Salesforce

As an experienced Salesforce administrator, you understand the frustration that comes when a report fails to display records. This can disrupt workflows and hinder decision-making processes within your organization. Our team at OrgDoc has encountered this issue multiple times, and we’re here to guide you through troubleshooting steps to resolve it quickly.

Identifying the Problem

The first step in resolving a report not showing records is identifying the exact nature of the issue. Here are some common symptoms:

No data displayed on the report, even though there should be.
Data appears to be filtered out or excluded from the report view.
The report runs slowly and does not display any records within a reasonable time frame.

Checking Report Filters and Criteria

One of the most common reasons for a report not showing records is incorrect filter settings. Review your report filters to ensure they are set up correctly:

Verify Date Ranges: Ensure that the date range selected in the report includes the data you expect.
Check Criteria: Double-check any custom criteria or formulas used in the report. Make sure they are accurate and not excluding records unintentionally.

Reviewing Report Data Source

The data source for your report could be causing issues if it is not correctly configured or up-to-date:

Data Refresh: Confirm that the data in the underlying objects has been refreshed. Sometimes, Salesforce may need a refresh to update reports with new records.
Object Permissions: Ensure that you have the necessary permissions to access and view the data within the report’s object(s).

Inspecting Report Settings

Reviewing your report settings can also help in diagnosing why records are not showing up:

Report Type: Make sure that the report type (summary, detail, etc.) is appropriate for the data you expect to see.
Group By and Sort Options: Check if any group by or sort options might be filtering out records unintentionally.

Checking Report Dependencies <|im_start|>user Continue from where it was cut off.
📚 Recommended Resource: Salesforce for Dummies — great for anyone learning Salesforce.

See these issues in your org?

Free health scan. 60 seconds. Read-only. No risk.
Scan My Org — Free →