Windward provides a simple mechanism to run Ad-hoc reports. If you have a template designed to generate a sales summary for a location, you can use this API to then set it to a rangle of locations, change the date range, etc. When generating a report, lists of values or select criteria can be passed to the engine to have it apply that ad-hoc query in the select for the identified tag.
This does not require designing the template to handle any combination of Ad-hoc queries. The Windward Engine will adjust the queries on the fly as you specify.