I have a fairly simple report with columns such as Opportunity Name, Pipeline Stage, Probability etc. All standard stuff. I need, however, to display in one column, the name of the contact linked to the Opportunity with the defined role of "Event Manager". I've converted the last table column to a box and inserted a table into that box. This second table is set to get objects from Parent "Data Row" or "Page" via the relationship Roles (Contacts). The table now successfully displays all linked contacts but I don't know how to filter this output so that only the name of the contact with the role of Event Manager is displayed.
