2

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?

5
  • By Page layout of the report you mean the report type. Right? Can you also check the access for the field
    – manjit5190
    Jan 12, 2017 at 18:24
  • FLS is given to that field? Jan 12, 2017 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, 2017 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, 2017 at 18:37
  • Yup. That was the issue, it was not visible on my profile.
    – akcorp2003
    Jan 12, 2017 at 18:39

2 Answers 2

5

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

2
  • Isn't that part of comment? Jan 12, 2017 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, 2017 at 20:03
3

What worked for me: Added newly created fields to the Report Type

The fields had been added to the object after the report type was created, so I had to add the fields to the report type.

How I added the fields to the Report Type: Salesforce > Setup > Home tab > quick search for and choose 'Report Types' > Click on the report type name > choose 'Edit Layout' Under 'Fields Available for Reports' > follow the instructions on that page to add the fields

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .