- Insert parameter markers in the SQL query where conditions for row retrieval are to be dynamically updated when the report is run.
- Create a data set parameter to supply a value for each parameter marker in the SQL query.
- Create report parameters to prompt the user to specify values that determine the rows to retrieve.
- 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.
- Design the presentation of report parameters to your report users.
- Test the report parameters.