Allow the user to set a variable for the workbook/report similar to an App.Config.
For example set at the workspace level the variable @location and then in the report you could reference that variable and pass it through as a parameter to a SQL Server stored procedure to retrieve only information for that @location