[SalesForce] Standard Field not shown in Standard Report

Using the standard report object: Opportunities, I need to group by the standard field: AccountSource.

enter image description here

The field is visible to all:

enter image description here

and required even

enter image description here

However, when using the report builder, the field is missing from the list

enter image description here

  • It's a standard object, why don't I see it?
  • Is that report: "Opportunities" is like a CRT? (Custom Report Type) – it does not make any sense

Best Answer

Wow, that's annoying and dumb. I found another complaint about this, as well as looking for myself. But sure enough, it's not there.

Best workaround would be to create a new Formula(Text) field on Account or Opportunity. On Account, the formula would be TEXT(AccountSource). On Opportunity, TEXT(Account.AccountSource). You don't need to add the field to page layouts, and it will become available on the standard Opportunities report type.

Also, I posted an Idea, which you're welcome to vote on.

Related Topic