Results 1 to 2 of 2

Thread: How to remove duplicate from report ?

  1. #1
    Nicolasbombourg is offline Junior Member
    Join Date
    Jul 2008
    Posts
    1

    Default How to remove duplicate from report ?

    Hi,
    I prepared a report containing :
    - all the contact
    - that at least ordered once

    To do so, my query is build on :
    - A contact report
    - containing all the contacts having at least 1 opportunity closed and won

    The issue I have is that if they ordered twice, I get 2 times their details in my list.
    How can I get a report without any duplicate ?

    Thank you !
    N

  2. #2
    jmertic's Avatar
    jmertic is offline Sugar Community Manager
    Join Date
    Dec 2007
    Posts
    3,996

    Default Re: How to remove duplicate from report ?

    You could try a summation report, grouping on contact.
    John Mertic
    Sugar Community Manager

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Why do duplicate contracts appear in my report?
    By ene-ce in forum Developer Help
    Replies: 1
    Last Post: 2013-08-05, 07:00 PM
  2. How to Remove Duplicate Button
    By art G in forum Help
    Replies: 5
    Last Post: 2011-08-05, 08:28 PM
  3. Remove Duplicate BTN by role
    By cff_moiseszaragoza in forum Help
    Replies: 0
    Last Post: 2011-06-22, 04:27 PM
  4. Cannot Remove Duplicate Contacts
    By GerryKey in forum Help
    Replies: 0
    Last Post: 2011-05-09, 06:29 PM
  5. How to remove duplicate link fields
    By ldebaets in forum Developer Help
    Replies: 3
    Last Post: 2010-12-16, 07:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •