How to Hide/UnHide Columns and Shrink the remaining columns by using Parameter in SSRS Report.
The demo will present a scenario in which we will use a Boolean Type parameter, by Clicking True we would like to see all the columns or you can call that detail report. When we click False we would like to see limited number or columns or compact format of our report. We will follow below steps to create our final report in SQL Server Reporting Services
- Create empty Report in SSRS
- Create Tabular report in SSRS
- Create Boolean type Parameter
- Write Expressions to Hide Column/s by using Parameter value in SSRS Report