Lookup-Field-Search as parameter for reports

Lookup-Field-Search as parameter for reports

Hi there,
I love the functionality Zoho Creator is offering, its awesome!
One thing I could figure out properly (probably because I'm not using the correct search terms), is how to do the following:
I want to have one page with a big variety of lists and KPIs, but all the underneath data should be filtered by one criteria. I figured out, how to pass the searchstring from the search widget to reports, however the search is not the best option to provide the criteria as it is free text field.

I'd basically need the functionality of a lookupfield/dropdown (based of the available values in one column of one of my lists) as a search criteria.

Details about my use case:
I have created my personal events module and I want to create a report page: which shows based of the selected event:
1. a List of all Participants
2. a list of all assigned team members
3. some panel and chart items