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?

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

2 Answers 2

Reset to default
5

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

Improve this answer
2
  • Isn't that part of comment?
    – Santanu Boral
    Commented 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
    Commented Jan 12, 2017 at 20:03
4

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

Improve this answer

You must log in to answer this question.

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