I am confused with this basic reporting issue:

I have a simple criteria:

enter image description here

I would expect to see only unique records in my view/ export, but I see duplicate rows of the same record.

Irrespective of what I chose either "My Teams opportunities" / "All Opportunities" I see duplicate rows, is the report including my visibility + my subordinates who can see this record making the count to 4 instead of one unique record?

Please clarify what I am missing here !!!

enter image description here

  • I dont think visibility will double records .Its weird .Your screenshot is so tiny for me to view Jul 8, 2014 at 19:39
  • What Report Type are you using? Jul 8, 2014 at 19:49
  • @AlexTennant Tabular
    – Rao
    Jul 8, 2014 at 19:49
  • I meant is this an "Opportunities" report, or "Opportunities with Contact Roles"... etc. Jul 8, 2014 at 19:51
  • @AlexTennant oh sorry its a custom report type
    – Rao
    Jul 8, 2014 at 19:53

1 Answer 1


You mentioned you are using a custom Report Type with Opportunity as the parent object.

If an Opportunity has multiple child records under it then the Opportunity rows on your reports will be repeated for each child object, for example, if your Opportunity had 5 of your child object, the Opportunity fields will be repeated 5 times.

However, if you look at the columns which correspond to the fields on your child object you should notice that each of those lines has different values and refers to a different record.

This is similar behaviour to if you do a left join in SQL and more than one record on the right side of the join matches the left side.

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.