Client report - future events

I need to create a report that will display a certain category of clients, and I need to show the next upcoming event date for each client, or indicate that there is no event booked.

I cannot find a way to do this.