## Enabling the user to filter at query run time

To enable users to filter database data, you complete the following tasks in the recommended order. For detailed information about these tasks, see the corresponding topics later in this section.

- 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 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.