This is a case where you may have no choice but to include a portal to either Expenses or Crew on your report layout.
You can base your report layout on one of these two tables, pull in data from Event by adding fields from the related event table occurrence and then add a portal to the remaining table, either Expenses or Crew--whichever you did not choose to base your layout on.
You can put a large portal on the layout with many rows specified and then use sliding/resize enclosing part to shrink it to fit the number of rows actually needed for a given report.
I'd select whichever of these two tables is best suited to a simple "table like" format to use for the portal and whichever most needs more complex formatting as the one on which to base the layout, using a list view type layout design.
I don't quite get the purpose to your Report table.
Note that there are other options, but the complexity of how you pull them off increases significantly with the other options.
The REPORT table was an attempt to organize and combine the related tables. Fail.
Thanks for your answer.