Answers.Body: <p>Advanced Search and Search Builder produce a list of Contacts. But a report can pull data other than Contacts and the Group By in the report can be such that you can get a Contact more than once in your output. For example when pulling a Membership or a Contribution Report.</p>
  
  <p>For a Constituent Report if you're seeing the Contacts more than once: hit the checkbox for Contact ID (under Columns) - to confirm these are the same contacts in your CiviCRM database. If the Contact IDs are different - then go and merge them. If Contact IDs are the same then you are likely selecting a column that a contact has more than one bit of data for.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-17T00:11:15.157Z
Answers.Text: That just doesn't make sense to me. If I report by selecting a smart group shouldn't the report contain what's in the smart group and nothing else? Even when I remove the Group By in the report the result is the same. Where do I look to find out why a contact is included more than once?
Answers.UserDisplayName: Martin Fuggle
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-17T00:17:31.487Z
Answers.Text: No - not necessarily - it could be that you're looking at eg Memberships or Donations for all contacts in your Smart Group. What specifc report template are you using?
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-17T06:16:38.037Z
Answers.Text: I am using the template Constituent Report - Summary. There are only two contact records that are shown twice and I cannot see what is different about these contacts for them to be treated differently from the other 145 contacts in the particular dataset.
Answers.UserDisplayName: Martin Fuggle
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-17T13:17:48.707Z
Answers.Text: Updated my Answer above. So look to see if the contacts that are show twice have multiple (primary) phone numbers or addresses - depending on what columns you pull
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-18T02:19:57.840Z
Answers.Text: Hi Karen - many thanks for your persistence in assisting me. The cause was a duplicate Home Address in the contact record and once that was resolved the results were as I expected.
Answers.UserDisplayName: Martin Fuggle
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-18T02:22:04.387Z
Answers.Text: Excellent! Glad to hear.
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-15T22:45:03.690Z
Answers.LastActivityDate: 2016-04-17T13:15:50.680Z
Answers.LastEditDate: 2016-04-17T13:15:50.680Z
Answers.UserDisplayName: KarinG - Semper IT
Body: <p>When I use the Advanced Search or Search Builder to select a dataset the returned contacts are correct. If I do the same search using in CiviReport with the same search criteria one contact is displayed twice. If from the advanced search I create a smart group the group contains the correct number of contacts. If I then use CiviReport and search using the smart group one of the contacts is shown twice.</p>
  
  <p>I have looked at the database to see if I can understand what might be causing this without success. It is possible that it has happened after merging the erroneous contact but I am not certain.</p>
  
Tags: <civireport>
Title: Advanced Search gives different dataset than same search in Reports
ThreadText: # Advanced Search gives different dataset than same search in Reports
  
  (Asked by: username_0 on 2016-04-15)
  
  When I use the Advanced Search or Search Builder to select a dataset the returned contacts are correct. If I do the same search using in CiviReport with the same search criteria one contact is displayed twice. If from the advanced search I create a smart group the group contains the correct number of contacts. If I then use CiviReport and search using the smart group one of the contacts is shown twice.
  
  I have looked at the database to see if I can understand what might be causing this without success. It is possible that it has happened after merging the erroneous contact but I am not certain.
  
  **Tags:** civireport
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-04-15. Score: 3
  
  Advanced Search and Search Builder produce a list of Contacts. But a report can pull data other than Contacts and the Group By in the report can be such that you can get a Contact more than once in your output. For example when pulling a Membership or a Contribution Report.
  
  For a Constituent Report if you're seeing the Contacts more than once: hit the checkbox for Contact ID (under Columns) - to confirm these are the same contacts in your CiviCRM database. If the Contact IDs are different - then go and merge them. If Contact IDs are the same then you are likely selecting a column that a contact has more than one bit of data for.
  
  > **Comments:**
  > **username_0**: That just doesn't make sense to me. If I report by selecting a smart group shouldn't the report contain what's in the smart group and nothing else? Even when I remove the Group By in the report the result is the same. Where do I look to find out why a contact is included more than once?  
  > **username_1**: No - not necessarily - it could be that you're looking at eg Memberships or Donations for all contacts in your Smart Group. What specifc report template are you using?  
  > **username_0**: I am using the template Constituent Report - Summary. There are only two contact records that are shown twice and I cannot see what is different about these contacts for them to be treated differently from the other 145 contacts in the particular dataset.  
  > **username_1**: Updated my Answer above. So look to see if the contacts that are show twice have multiple (primary) phone numbers or addresses - depending on what columns you pull  
  > **username_0**: Hi Karen - many thanks for your persistence in assisting me. The cause was a duplicate Home Address in the contact record and once that was resolved the results were as I expected.  
  > **username_1**: Excellent! Glad to hear.  
  
  ---
  
  