When a report returns records with blank field values, a common cause is that Field Accessibility is set to "Hidden" for the field that is missing values.
The Field Accessibility results in the field not displaying on record pages, meaning that the field may not have had a value previously entered.
Here's how to correct the Field Accessibility so that the field's information can appear in your reports:
Step 1: Update the Field Accessibility preferences for the missing field (change from "Hidden")
Step 2: Add the missing field to the Page Layout for the field's Object.
Step 3: Once the field is added to the Object's Page Layout, edit the field to change its value. The newly added information will appear when you refresh the report.
See Also:
Owner Role displays empty or blank in Reports
Report Does Not Display All Records or Shows Incorrect Results
Set Field-Level Security for a Single Field on All Profiles
Set Field Permissions in Permission Sets and Profiles
Page Layouts
000386280

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.