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
When I create a standard Cases report, the
Building Name field is available to add to the report.
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?