I am trying to create a custom report but a field on my contact object is not showing when I'm building that report even though I added that field to the page layout of the report.

On my contact object, the field is a formula field that is referencing a field on the account object. The formula is Account.NO__c.

I also added that field as a look-up and that worked no problem. It's just that the formula field is not showing up...

I tried looking at this solution: reporting - Report Filter - Cannot Use Formula? but to no avail.

What could be happening here?

  • By Page layout of the report you mean the report type. Right? Can you also check the access for the field – manjit5190 Jan 12 '17 at 18:24
  • FLS is given to that field? – Santanu Boral Jan 12 '17 at 18:28
  • @manjit_singh Yeah, I mean the page layout of the report type. Which field level access should I look at? – akcorp2003 Jan 12 '17 at 18:35
  • 1
    Go to the object and open the field which is not showing up. Make sure that is is visible to you profile. – manjit5190 Jan 12 '17 at 18:37
  • Yup. That was the issue, it was not visible on my profile. – akcorp2003 Jan 12 '17 at 18:39

The solution is that the field level security needs to be set correctly for your profile.

|improve this answer|||||
  • Isn't that part of comment? – Santanu Boral Jan 12 '17 at 18:53
  • Should I leave it in the comments? I don't want someone to scroll through the comments to find an answer. – akcorp2003 Jan 12 '17 at 20:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.