SSRS Interview Questions and Answers - What is Multi value parameter in SSRS Report

Parameter/s in report are used to filter the data. Parameters are really useful to extract only required data as well present the data which is required by the user.

Multi Value parameter in SSRS Report let the user choose multiple values for the Parameter. While creating SSRS Report, we can either provide Static values for our Multi value parameter inside the report or we can use query to extract values from database for our multi value parameter.

Default values can be configured for multi value parameter as well if required, otherwise user can choose values for parameter at run-time.

If a parameter is multi value parameter, you will see a drop down with check boxes. You have the option to Select All or you can choose the values what you like. For value for multi value parameter can be text, integer, date type.

1 comment: