19 Antworten
@Jingjing Fang Create a custom report type. Primary Object = "Campaigns". Then on the second page, relate "Contacts" as object B using 'Each "A" record must have at least one related "B" record.', then relate "Opportunities" as object C using '"B" records may or may not have related "C" records.'
Reports generated from this custom report type will display a detail row for every unique combination of Campaign Member and Opportunity Contact Role for each contact, plus a detail row for each Campaign Member where the Contact does not have any Opportunity Contact Role records meeting the filter criteria.