I got a solution by which I can hide the column in the column expression. i.e. I have selected Jul column Select Column -> Propeties -> Visibility -> Select Expression radio button and type the following expression =iif(Fields!Jul.IsMissing,true,false) However this is not the perfect solution. If I fetch records which contains Jun, Jul, Aug and write the above expression to hide the jul column then the Jul column will be hide but there would be space between the Jun and Aug. I want the space should not be there if the column does not hide. I am getting the following formate before hide State Jun Jul Aug A 10 12 12 B 12 14 15 After hiding State Jun <--space--> Aug A 10 <--space--> 12 B 12 <--space--> 15
Pankaj