+ Start a Discussion

Report to relate portal user and their contact

I am trying to create report to relate portal user and its contact who have campaign history.I'm able to relate contact and portal user but i couldn't get campaign history result.I created a report type like Users->Contacts(modified by)->campaign history->campaign member.Can anyone help me out to get the result?
Hi Manoj.mj,

You need to create a joined report for this.
first create a report for portal user with contact id by going to administartive reports folder.
Then try to create a new report type on campaign and campaign memebers then filter both reports by common fields in both the reports.
Other wise create both records differently and download those reports and do a vlookup from users  contactid to campaign memebers report contact id in excel.