Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I was looking into joined reports and need some understanding of how the common fields are set.

For example I have a opportunity and Lead report types in my joined report. I also have one custom field in opportunity called lead source and i also have lead source in leads.

I dont see this field as a common field in the joined reports. How are the common fields determined?


share|improve this question
up vote 1 down vote accepted

Please refer: How Joined Reports Work

A field is a common field if it’s shared by all report types or if all report types share a lookup relationship to the field. These fields appear in the Common Fields area in the Fields pane, and can be used to group report blocks.

share|improve this answer
if i am understanding this correct, then i need to have the field on opportunity for leadsource to be a lookup on leads to be able to show as a common field in joint report???? – Prady Feb 7 '13 at 9:36
NO. The field needs to be present on both the objects. But the objects need related to each other via that field. So in case of Opportunities and Leads, Owner is the only field by which both can be related. – Shailesh Deshpande Feb 7 '13 at 9:45
ok got it.. thanks mate – Prady Feb 7 '13 at 10:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.