You can use parameters to control the contents and presentation of a report. A runtime parameter provides a value to be used in a query condition. … There is a default set of runtime parameters for all queries, and any number of runtime parameters can be defined in the query that is used by the report.
What are report parameters in SSRS?
The SSRS Report Parameters allows the users to enter a specific value in the textBox and then, SSRS will filter the Report data using the user-specified value. OR Report Parameters enables the users to Filter the SSRS Reports Dynamically.
When report parameters are used how data is filtered?
This includes filtering after the source query has come back – on a data region (like the Tablix), or a data grouping. When you implement a filter within the report, when the report is re-executed again with different parameter choices, the Report Server uses cached data rather than returning to the database server.