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
How to create Drilldown reports in SSRS
How to create Static parameter in SSRS Report for Expand/Collapse
How to set default Value for Parameter
How to write expressions to Expand/Collapse rows by using Parameter in SSRS Report

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

Visit our website to check out SSRS Tutorial Step by Step

SSRS Collapse Expand Report Parameters
How to Implement Expand All/Collapse All for Drill-Down in SSRS
SSRS--Expand/Collapse Parameters

[patrickwilliams]

THIS VIDEO IS PERFECT!! Concise, and effective. Cannot find how to do this anywhere else. Thank you for covering this.

[mendeleyes]

Thanks for the tutorial! Additionally we need to synchronize +/- sign or image of the group with the Expand/Collapse parameter. For example, if we defined parameter/values as:
expandAll={true, false}
- Go to design mode and select the text box that has the toggle image
- Go to the Properties grid and set the property named InitialToogleState as expression =Parameters!expandAll.Value

[javierc]

if your fieldname is not a parameter, put the name of field like this ("Fields.Region.Value"). Thanks, your video is really usefull :) .

[janoso]

Hello! Great content it helps me alot. I have a question, how can i change the name of that true or false?