How can I create reports with 2 different CSA
**This post was created as part of a How to Service Request (SR)
Summary of the question:
I am trying to create a report using 2 different custom subject areas. The first CSA is produced using a custom object named "Events". This CSA contains detailed information about events such as event name, event date etc. The other CSA is created by intersecting the Contact with "Participants" table, which contains the contact's participants' information. The name of the intersection table is "Events_Participants".
I am aiming to create a report that shows the name of the event and the name, email, phone number of the participant contact. I tried to combine these two CSA using the union functionality of BI tool, however, it needs to match all the fields that I put into "Events" to "Events_Participants".