- Create report parameters to prompt the user to specify values that determine what rows to retrieve.
- Insert parameter markers in the SQL query.
- Create a data set parameter to supply a value for each parameter marker in the SQL query.
- Bind the data set parameter to the report parameter, so that the data set parameter gets the user-specified value from the report parameter and passes it to the SQL query.
- Determine how to present the report parameters to a user.
- Test the report parameters.