Creating a Report with a relationship with another report

Hello All,

On a daily basis, I should make a daily reports for different governorates. The report is a little bit complicated as it

1- Relationship between the first report and the second report. i.e: Dealer ID-Report 1, and Dealer name- Report 2.
2- The Report includes a lot of records sometimes exceed 1 million record.
3- The Report includes too many graphs.

I need to have a template that includes the following:

1- Slicers per each governorate (Cairo, Alex,….)
2- Relationship between both reports (Report 1 &2)
3- Have a database that can be daily updated but on Access.

Appreciate your support regarding the above.

The attached file is a sample of the report.

Thanks,