SSRS Tutorial 57 - Hide Or UnHide Columns By Using Parameter Value in SSRS Report

In this video of SSRS Tutorial, we will learn

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

Check out Step by Step Tutorials such as SQL Server DBA, SQL Server Reporting Services,SSIS,Dynamics AX and others on website

[vinciallen-steward]

Pure perfection!! Well explained and illustrated.

[krismaly]

I enjoyed watching this video and recommend others.

Thanks for educating the community and appreciate your volunteership.

Thanks lot

[JoeG]

you are awesome, this is exactly what I needed!

[GodoMatrix]

I was looking for something that allow me to hide based on the user selection, but I will try to learn from this and see if I can improvise the answer I'm looking for. Thanks for the video.

[Toturials]

thanks. is there a way to add column run Time, Because some time data comes from different tables.and number of column unknown.

[ratanak]

Hi teacher, i can merge cell 2 column 1 row but i can't merge cell 1 column 2 row. do you know how to merge cell 1 column 2 row ?

[Bonezz]

Thanks for the video. It's pretty ridiculous that they've made everything that used to be simple, 100x more difficult.

[danielaltamirano]

Did you do a video using a text parameter instead a boolean? This can be done using multiple text parameters?

[hariharanb]

Im using dynamic columns, ie: Column is element category and contain many catagories. say I want to only hide two specifics. how?

[sultanmalik]

When colum is grouped if you try to hide that group it removes everything from the report. Is there a way to hide a group column like you are showing in this video for columns?

[DharmYogi]

I have a multiple group by relationships but I don't want to show some columns with group by. when I set the visibility/hidden property to true it leaves white space for the column. how do I remove the space.  any thoughts

[BewithuNnk]

Hi, how to publish the report if you want to be true for details parameter while deploying the report.how to do it. And replicate in browser

[GauravChaudhary]

When we export this report data?? Will the hidden fields get export

[PoorvaAwale-iift]

Hi Sir,

I have two tables in one report in SSRS and want to Hide and unhide each of the tables based of the filter/parameters values that is passed. How can this be achieved?

[krismaly]

Can you make Hide and UnHide clicking on the column of user choice

Say User want to make column 3 hide and Unhide or same property to be fixed ooon each and every column

Just a thought

[delmensah]

can this work when you extract the output as well?