If I'm getting this right, that is actually what parameters are used for. Get a value for something that affects the result of the report.

When you create a parameter for the report do not assign a default value so when you open the report it will ask for a value to execute the query and obtain the resulting report. Just make sure that the query/stored procedure receives the value of the parameter and it is used on the query as a filter.