1

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

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.

  • 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? – Ankita Gupta Feb 7 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 Feb 7 at 7:07

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.