Skip to main content
Is there a way to create a report that will show contacts with a closed won opportunity containing certain numbers in the opportunity name? We name all of our opportunities based on the year and number they come in (ex 20-0450). I want to see all the contacts that have opportunites associated with them that contain "20-" in the opportunity name. The report needs to show the contact name, account, phone, email, and ideally the opportunity names. I'm at a loss of how to obtain a report like this. Is it even possible? Thank you!!
8 respuestas
  1. 29 oct 2020, 18:34
    No problem at all, I get it -- and thanks for explaining.

     

    So I see that you have a lookup relationship on Opportunity to Contacts.

     

    Therefore I also build a lookup relationship to contacts from Opportunity.

     

    Right after this, I tried to create a Custom Report Type and.. voilà! I also have two Opportunity objects (not really, not visible in Object Manager).

     

    No problem at all, I get it -- and thanks for explaining. So I see that you have a lookup relationship on Opportunity to Contacts.

     

    So I created this custom report type, named it asd - lol.

     

    I also selected an opportunity and a selected a contact related to it, through the newly created lookup (you already have this so nothing to do here). Like this.

     

    User-added image

     

    Then I went and created a report, but this time I didn't use a cross-fliter, I just used a normal filter. The report now shows me all the contacts that are related to at least one opportunity, see below.

     

    User-added image

     

    You can then maybe try and group your report by Contact Full Name, as some of your contacts are related to multiple opps.

     

    Let me know how it goes?

     

    Any further hickups and we definitely need to jump on a Hangouts :) just to save us time etc.

     

    Regards,

     

    Viorel