Excellent, thanks Guruprasath. Kind regards RP Reddy

Hello, How to insert a space in the column chart report. There is few zero values in the column (Assume, January sales is Zero, February sales 20, March sales 30).In the column chart January data is not appearing because of ZERO value, at the same time i can see only Feb and March data. I need to show January as space as well. I am using SSRS2008R2. Kindly help me. Thank you.

Hi, Use can use the FILED Expression like below.. IIF(Field!Months ==0, '',Field!Months).. Try this !! Regards, Guru

Thanks for your replay Guruprasath, but it is not working. Kind Regards Raghu

Hi, I think we cannot show space instead of zero values but you can show something like '0.001' instead of 0 to represent January if your customer accepts. =IIF(Field!Column.value = 0 , 0.001, Field!Column.value) Rajesh Jonnalagadda http://www.ggktech.com

Hi, This is the correct statement in the FIELD Expression. =IIF(Fields!Months.Value = 0,"",Fields!Months.Value) Thanks, Guru