2

Are there any specific field data types which are not available for reporting in salesforce ? Or all fields can be used in reports? Apart from checking manually under setup-> Report Types -> available fields for any specific object , is there any way we can check if some specific fields are available for reporting or not?

1 Answer 1

1

All fields on all objects that support reporting can be included in a report. Some fields may have restrictions on which filters may be used (e.g. no filtering allowed, or only equals/not-equals). Note that reports respect field level and record level security, so a field or record may not appear depending on a user's profile settings and/or permission sets. Some "standard reports" also don't include custom fields, but that is a report-specific limitation.

2
  • 1
    Regarding - 'Some fields may have restrictions on which filters may be used (e.g. no filtering allowed, or only equals/not-equals). ', How to find out this? Commented Feb 7, 2019 at 7:01
  • 1
    @AnkitaGupta They're all related to specific data types. Once you know how a data type behaves, all fields of that type will behave the same. For example, encrypted fields don't support starts with, contains, etc. Multiselect is the only type that allows includes/excludes, etc. I don't know of a single resource that contains this information. Basically, there are normal fields, long fields (long text, long rich text), encrypted fields, picklists, and multiselect lists.
    – sfdcfox
    Commented Feb 7, 2019 at 7:07

You must log in to answer this question.

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