Hi, My ssrs report has several columns. I would like to hide two of the columns i.e. column7, column 8 (positioned in the middle of the table) if for example the value of the column2 is null. Questions: 1- How do I do the above and 2- after deleteing I do not want to see gaps between the fields due to hiding the fields Thank you

Hi, Please use the following expression in the Visibility property of the column you want to hide. =IIF(IsNothing(Fields!Column2.Value), TRUE, FALSE) Hope this helps! Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

How about: =IIF(Fields!Column2.Value is null, TRUE, FALSE) ?

That won't work. Did you try the expression I posted? Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

Thanks Muhammed it worked like charm for me. But i have small issue, when i do this what i should write in the column header because i am using same statement in the column header do i need to use it in column header same condition? for eg. i have column1 (header) and values are null then both are hidden.that is after i write the above condition in properties of both column header and just below the column header. for the same if i have data then header is missing and data is shown in that column. but i want to show header when there is data i dont know how, could any one help me in this.