Hi, I am trying to hide a column in SSRS report by using expression like: =iif(Fields!CASE_TYP_DESCN.Value = "Appeal Assistance",false,true) My report is drill down type and based on certain value i have to hide one column, but does not happens like so. Can anybody help me out. Thanks, Nishant Nishant

Hi, I am trying to hide a column in SSRS report by using expression like: =iif(Fields!CASE_TYP_DESCN.Value = "Appeal Assistance",false,true) My report is drill down type and based on certain value i have to hide one column, but does not happens like so. Can anybody help me out. Thanks, Nishant Nishant =Fields!CASE_TYP_DESCN.Value <> "Appeal Assistance" would do what you're looking for. Assuming you're wanting to hide the column if its not Appeal Assistance, since your current expression says, if it's appeal assistance, dont hide it, otherwise, hide it. You could also try =Trim(Fields!CASE_TYP_DESCN.Value) <> "Appeal Assistance" in case whitespaces are screwing up your data.

Hi, This solution had hide my column but leaves the whitespace. I also try some solutions given on internet like: Go to Column Group->select the static coulmn which i need to hide->Go to column property->Select Hidden and set conditional expression to hide the column. But the above solution just hide the entire column irrespective of my given expression. Please guide me how do i hide a column without any whitespace in SSRS-2008 Nishant Kumar