SSRS Interview Questions - What type of parameters are available in SSRS Report

Parameters are used to filter the report data. By using the parameter/s users can filter the information they would like to see instead of looking entire data on report.

SQL Server Reporting Services Reports can be configured to run with default parameter values or user can choose the values for parameter/s and then view the report.

For Parameter values, you can use either Static values inside report or you can use Query which can get the parameter values from Database.

SQL Server Reporting Services provided different types of parameters

  • Single Value Parameter
  • Multi Value Parameter
  • DateTime type Parameter ( Calendar type)
  • Boolean Type Parameter ( Radio Button)
  • Cascading Type Parameter

1 comment: