Hi I have report in which i have some empty cells how to replace thous empty cells with a value say '0' or 'N/A' what expression can fulfill my requirement?Thanks & Regards $@m

You can set the value of a cell referencing the VBA function IsNothing in an expression: =iif(isnothing(Fields!FieldName.Value), "N/A", Fields!FieldName.Value) Hope that helps! Cheers!Ryan - Please mark all answers and useful posts!

Hi Waco I have tried this one.. but still i am having empty cells in my reports.. Thanks & Regards $@m

when you run it in SSMS, were those fields NULL or blank? Well you could try either IsNothing or check for "" or use Len function. eg. =iif(IsNothing(somefield) or somefield = "" or Len(somefield) = 0,"N/A",somefield)

You may also need to test for blank values, e.g.: =iif(isnothing(Fields!FieldName.Value) or (Fields!FieldName.Value = ""), "N/A", Fields!FieldName.Value) Hope that helps! Cheers!Ryan - Please mark all answers and useful posts!

Thank you very much.. now its working... Thanks & Regards $@m