1 Reply Latest reply: Nov 21, 2012 9:23 AM by SimonHoy RSS

    Report of all contacts associated with account

    436551
      Hi,

      Can someone tell me how to create a report of all the contacts associated with an account?
      I have tried several options, but everytime I get stuck that it only show the primary contact. I have tried to join it with the contacts, but still no result.

      Any help would be appreciated. Thanks in advance.

      Best regards,
      Wing
        • 1. Re: Report of all contacts associated with account
          SimonHoy
          wi**** wrote:
          Hi,

          Can someone tell me how to create a report of all the contacts associated with an account?
          I have tried several options, but everytime I get stuck that it only show the primary contact. I have tried to join it with the contacts, but still no result.

          Any help would be appreciated. Thanks in advance.

          Best regards,
          Wing
          Hi Wing,

          I suspect most of you issues may be down to your choice of reporting object or metrics.

          Try using Organisation Contact History under the Analytics section when creating your report and add the necessary fields, I added "Name" from Org/Ac object and the contact details from the contact object, and could see all the contact associated.

          P.S no need for a metrics as these two tables are pre-linked Organisation Contact History

          Thanks
          Si