0

I'm trying to create a custom report type linking two standard objects together -- Opportunity as the primary and Account as the child. I am able to create everything fine, but when I actually use the report type, no Account fields are visible.

enter image description here

I'm a system admin, so there shouldn't be any permission problems. Any ideas where I'm going wrong?

enter image description here

  • 1
    you have a custom lookup field from Account to Opportunity? As normally, Opportunity is the child of Account – cropredy Feb 14 at 1:46
  • @cropredy That's probably it... I was thrown off since it let me set it up that way to begin with. Is there a way to connect two child objects to the primary? So instead of A>B>C it would basically be A>B, A>C? – Matt Feb 14 at 5:08
  • 1
    Matt. Unfortunately, no. There’s no way for SFDC to know how to render such a schema. The number of rows per sibling could be different. You might consider joined reports. – cropredy Feb 14 at 6:01
0

You've gotta edit the report type layout to include fields from the Account. Here's a Salesforce Help article detailing how to do so; it'll take you 15 minutes to do this if you go thru steps 1 - 9.

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.