If I wanted to create a report for each of 30 different locations based on a query that has a where statement something like WHERE Location = 1 what would be the easiest way to do it?

If I save a report file such as location1.rdp and the query as location1.sql and the design file as location1.design is there an easier way than using the visual designer again to create a new set of files that work for WHERE Location = 2, 3, 4, etc?