6

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 Jan 19 '14 at 17:15
  • but do you see it in the Account Object? – Saariko Jan 19 '14 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 Jan 19 '14 at 17:44
2

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 Jan 20 '14 at 7:57

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.