One report for each store

Hello,

I have the sales data of over a hundred stores, and I would like to build the same report for each one of them. The owner of the store would only have access to his report.

I have one single database that contains the data of all the stores. In the database tables, there's a column specifying which store the data is about.

Is there a way to build one single report and replicate it for all the stores, or do I have to build one report at a time (over 100 times)?

Thanks