How to Replace Null Values in SSRS Report ?
How to Replace Null Values in SSRS Report ?
You can replace the NULL Values with some Custom value using IIF , IsNothing Function in SSRS.
Just Right Click on TextBox on which you want to replace NULL Value and write an Expression :
=IIF(IsNothing(Fields.ColName.Value),0,Fields.ColName.Value) [ To Replace with 0]
or
=IIF(IsNothing(Fields.ColName.Value),"Not Available",Fields.ColName.Value) [To Replace with String]
You can replace the NULL Values with some Custom value using IIF , IsNothing Function in SSRS.
Just Right Click on TextBox on which you want to replace NULL Value and write an Expression :
=IIF(IsNothing(Fields.ColName.Value),0,Fields.ColName.Value) [ To Replace with 0]
or
=IIF(IsNothing(Fields.ColName.Value),"Not Available",Fields.ColName.Value) [To Replace with String]
Comments