CiviCRM Community Forums (archive)

I recently imported information on a 15 local businesses (all the same name with a store #) and tinkered with the information to get a hang of the system.  On import, it created several duplicates that I was able to merge and now when I search for the businesses by name, I get 15 results - great!

However, when I run a report for the same name and information as the search, I recieve a list with 54, with some businesses duplicated multiple times (up to 6x, most are 4x and some aren't duplicated at all!).  If I click on the each of the duplicated company names for one store in the list, the details are all identical with the same internal civicrm # and each shows the one employee I imported.  Thinking it may be due to multiple relationships made via imports I looked at the contact directly, it shows just one relationship to one individual. Deduping based on name or address shows no duplicates. 

The data looks great everywhere but the report.  Any advice on where to start cleaning this up?

Yes - of course.  This was a 'contact report' based on 'contact address and phone' - i'm showing email and phone but not addresses, but I believe the result was the same either way.

Sorry I forgot that I renamed the report as well as made a copy.  This is the 'Constituent Summary'

<!-- .tpl file invoked: CRM/Report/Form/Contact/Summary.tpl. Call via form.tpl if we have a form in the page. -->
          <form  action="http://bgcparkersburg.org/wp-admin/admin.php?page=CiviCRM&amp;q=civicrm/report/instance/1" method="post" name="Summary" id="Summary" class="CRM_Report_Form_Contact_Summary" >