How to replace Null values in SSRS Report - SSRS Interview Questions and Answers

If we are getting the data from a Database, we can use ISNull or COALESCE function to replace Null values with values we would like. 

But if we want to replace the Null/Blank values in SSRS Report, we need to use IIF and Isnothing functions in expressions.

Here are the expressions to replace Null/Blank to 0, otherwise print the value itself.

If we would like to replace Null/Blank with "Missing Value" for string type column
=IIF(Isnothing(Fields!Region.Value),"Missing Value",Fields!Region.Value)

1 comment: