In Service Cloud, I'm trying to make a standard report on Cases. Our Cases have a custom lookup field, named Customer / Customer__c
. This field is a Lookup(Account)
. And the Account
has a custom field on it named Building Name
.
When I create a standard Cases report, the Building Name
field is available to add to the report.
However, the Building Name
column on the report is blank (shows a "-") for all Cases. All Cases do have an Account set in the Customer__c
field, and all of those Accounts do have a Building Name
set.
I'm also unable to filter on the Building Name
field, even though it's available in the filter list. Filtering on that value shows no results for Cases.
I'm an admin and have verified the custom field is viewable for my profile.
What am I missing? Is it possible to use a custom field to on a Lookup relationship to show on and filter on a standard report?