# Reporting on associated contacts **URL:** \ **Category:** Dashboards & Reporting\ **Tags:** reports, professional\ **Created:** [July 12, 2022, 12:47pm UTC](https://community.hubspot.com/t/reporting-on-associated-contacts/60772 "2022-07-12T12:47:42Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![JoeWilliamsEBS](https://avatars.discourse-cdn.com/v4/letter/j/a88e4f/32.png) [@JoeWilliamsEBS](https://community.hubspot.com/u/JoeWilliamsEBS)\ **Post date:** [July 12, 2022, 12:47pm UTC](https://community.hubspot.com/t/reporting-on-associated-contacts/60772/1 "2022-07-12T12:47:42Z")
We have just migrated from Salesforce, where each company in our DB had an “Introducer” field which linked to the contact record of the person who introduced them to us. In Hubspot, these contacts are linked to the company record with an Association Label of “Introducer”. We want a report which simply shows a list of companies with the introducer contact listed alongside. I can happily produce a report with Companies as the primary source, Contacts as the second, and a suitable association filter so that I can get Company Name, Contact First Name, Contact Last Name. What I would like to do is to add the Primary Company of the contact to the report so that we can see which organisation they belong to. Is this possible, or am I going one step too far? 🙂 ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [July 12, 2022, 12:56pm UTC](https://community.hubspot.com/t/reporting-on-associated-contacts/60772/2 "2022-07-12T12:56:38Z")
Hi @JoeWilliamsEBS, Could you clarify one thing, you already have the _Company name_ in there… > * * * > > @JoeWilliamsEBS wrote: > > I can happily produce a report with Companies as the primary source, Contacts as the second, and a suitable association filter so that I can get Company Name, Contact First Name, Contact Last Name. … but you want to add the Primary company as well? Could you elaborate this part? Why the _Company name_ and the Primary company? From a first glance, I think this would be a second report. Best regards ---
**Author:** ![JoeWilliamsEBS](https://avatars.discourse-cdn.com/v4/letter/j/a88e4f/32.png) [@JoeWilliamsEBS](https://community.hubspot.com/u/JoeWilliamsEBS)\ **Post date:** [July 12, 2022, 1:04pm UTC](https://community.hubspot.com/t/reporting-on-associated-contacts/60772/3 "2022-07-12T13:04:50Z")
> * * * > > @karstenkoehler wrote: > > Hi @JoeWilliamsEBS, > > Could you clarify one thing, you already have the _Company name_ in there… > > … but you want to add the Primary company as well? Could you elaborate this part? Why the _Company name_ and the Primary company? > > From a first glance, I think this would be a second report. > > Best regards > > * * * Hi Karsten, Apologies for the confusion! The structure is: Client Company → “Introducer” association label → Introducer Contact → “Primary Company” association label → Introducer Company So I would like a report of Client Companies with the corresponding Introducer Company, linked by the introducing contact. ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [July 12, 2022, 1:10pm UTC](https://community.hubspot.com/t/reporting-on-associated-contacts/60772/4 "2022-07-12T13:10:45Z")
Hi @JoeWilliamsEBS, I don’t think this can be done at this point, as it would include two different kinds of company objects/records. Have you considered including the contact property _Company name_ instead of trying to pull in a second company record? (With a Professional subscription and company-based workflows, you can also copy the company record’s name into the contact property _Company name_.) Best regards! ---
**Author:** ![JoeWilliamsEBS](https://avatars.discourse-cdn.com/v4/letter/j/a88e4f/32.png) [@JoeWilliamsEBS](https://community.hubspot.com/u/JoeWilliamsEBS)\ **Post date:** [July 12, 2022, 2:20pm UTC](https://community.hubspot.com/t/reporting-on-associated-contacts/60772/5 "2022-07-12T14:20:58Z")
> * * * > > I don’t think this can be done at this point, as it would include two different kinds of company objects/records. > > * * * Thanks; I was reaching the same conclusion! > * * * > > Have you considered including the contact property _Company name_ instead of trying to pull in a second company record? > > * * * ![Screenshot 2022-07-12 145857.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/1/c13b07ef40d32790d299d01c09e0591abbb2ec5f.png) I may be doing something wrong, but I get this message and no data appears in the _Company name_ property column. > * * * > > (With a Professional subscription and company-based workflows, you can also copy the company record’s name into the contact property _Company name_.) > > * * * That may be the best solution. I haven’t dived into the possibilities of workflows yet so I’ll need to get my head around the right approach 🙂 ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [July 12, 2022, 2:25pm UTC](https://community.hubspot.com/t/reporting-on-associated-contacts/60772/6 "2022-07-12T14:25:37Z")
Hi @JoeWilliamsEBS, If that column is empty, then yes, copying it using a workflow would be a next step: [https://community.hubspot.com/t5/Tips-Tricks-Best-Practices/How-to-Automatically-Populate-the-Contact-Property-Company-Name/m-p/361030](https://community.hubspot.com/t5/Tips-Tricks-Best-Practices/How-to-Automatically-Populate-the-Contact-Property-Company-Name/m-p/361030) Best regards! ---
**Author:** ![JoeWilliamsEBS](https://avatars.discourse-cdn.com/v4/letter/j/a88e4f/32.png) [@JoeWilliamsEBS](https://community.hubspot.com/u/JoeWilliamsEBS)\ **Post date:** [July 12, 2022, 2:37pm UTC](https://community.hubspot.com/t/reporting-on-associated-contacts/60772/7 "2022-07-12T14:37:23Z")
Thank you Karsten - I’ll get stuck in 🙂 ---
**Author:** ![JoeWilliamsEBS](https://avatars.discourse-cdn.com/v4/letter/j/a88e4f/32.png) [@JoeWilliamsEBS](https://community.hubspot.com/u/JoeWilliamsEBS)\ **Post date:** [July 13, 2022, 7:51am UTC](https://community.hubspot.com/t/reporting-on-associated-contacts/60772/8 "2022-07-13T07:51:51Z")
> * * * > > @karstenkoehler wrote: > > Hi @JoeWilliamsEBS, > > If that column is empty, then yes, copying it using a workflow would be a next step: [https://community.hubspot.com/t5/Tips-Tricks-Best-Practices/How-to-Automatically-Populate-the-Contact-Property-Company-Name/m-p/361030](https://community.hubspot.com/t5/Tips-Tricks-Best-Practices/How-to-Automatically-Populate-the-Contact-Property-Company-Name/m-p/361030) > > Best regards! > > * * * Just to follow up, that solution worked perfectly 🙂