+ Start a Discussion
NehaaNehaa 

Report Request - URGENT

How I can pull all contacts that donot have an opportunity record?

 

There is alook up relation between contact and opportunity.

 

 

Satish_SFDCSatish_SFDC
You will have to create a Custom Report Type.
Set up > Create > Report Types.

Select 'Contacts' as the Primary Object and in the next page, where is says 'Click to Relate another object', Select Opportunities. There will be two options here. Select the second one which says 'A records may or may not have related B Records'

Create a new report with this report type and then add appropriate filters to remove the contacts which do not have any opportunity record.

Regards,
Satish Kumar
Please mark my answer as a solution if it was helpful so it is available to others as a proper solution.
If you felt I went above and beyond, please give me Kudos by clicking on the star icon.