SSRS Tutorial Part 94.1 - How to create Expand Collapse Parameter in SSRS Report

In this video of SSRS Tutorial, you will learn how to create a parameter by using that you will be able to Expand or Collapse groups/detail rows in single click.

In this video of SSRS Tutorial, you will learn

  1. How to create Drilldown reports in SSRS
  2. How to create Static parameter in SSRS Report for Expand/Collapse
  3. How to set default Value for Parameter
  4. How to write expressions to Expand/Collapse rows by using Parameter in SSRS Report


Expressions used in the video
=iif(Parameters!Expand.Value,FALSE,TRUE)


How to Expand Collapse Rows in Drilldown SSRS Report by Parameter - SQL Server Reporting Services(SSRS) Tutorial