Report filtering

Hello,
we have an application for a customer, where he stores records of events made for his customers.
He wants to send an automated report of all the events for the past month (or year) to all his customers on a regular basis.
Now how can I schedule a report, that will contain data just for the specified customer ?
For simplification, let’s assume I have a “customer” table with customer_name and customer_email fields and a linked table “events” with an event_name and event_date fields.

This obviously needs some dynamic filtering based on the customer, but I could not find any option to achieve this.

Denis