SSRS Interview Questions - What is Single Value parameter in SSRS Report

Parameter/s in reports are used to filter the data. Single Value parameter in SSRS is the parameter which can accept only single value.

You can configure Single Value Parameter with default value or leave for user to choose before view the report data.

The values for Single value parameter can be stored in report ( Static values) or you can use Query to get values from database and user can choose one at run-time.

Single Value parameter value can be provided by using below

A text Box for parameter value where user has to type by himself/herself
Drop Down list and user will choose one value out of them
Radio Button ( User can either choose True or False)
Date-Time ( Calendar Drop down)
In case of linked reports(drill through) cell value can be mapped to single value parameter

1 comment: