Using the standard report object: Opportunities, I need to group by the standard field: AccountSource.
The field is visible to all:
and required even
However, when using the report builder, the field is missing from the list
- 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.