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
  • 1
    Weird; I double-checked in my dev org and sure enough it wasn't on that report either. I don't think I've ever seen that before.
    – Mike Chale
    Commented Jan 19, 2014 at 17:15
  • but do you see it in the Account Object?
    – Saariko
    Commented Jan 19, 2014 at 17:17
  • 2
    Yes; I see the field and was logged in with the System Admin profile, verified FLS, verified I was on the standard report. I'm baffled.
    – Mike Chale
    Commented Jan 19, 2014 at 17:44

1 Answer 1


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.

  • I have a feeling that Idea will be released one day :-)
    – Saariko
    Commented Jan 20, 2014 at 7:57

You must log in to answer this question.

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