The SSRS IsNothing function is an Inspection function that checks whether the given field or expression has an object assigned to it. If the object is assigned, it returns a boolean True; otherwise, it returns False. The syntax of the IsNothing function to find whether the column is Null (empty) is shown below.
=IsNothing(Fields!ProductDescription.Value)
To demonstrate the SSRS IsNothing function in reporting services, we use the Employee table below, which has 20 records. The image shows the records in the Table report.
SSRS IsNothing function Example
For this, let me add a new column to the right side of the Middle Name column. Next, right-click the textbox under it and choose Expression to open the expression window shown below. The IsNothing function expression below will check whether there is any object or text inside the Middle Name. If empty, it will return a Boolean True; otherwise, it will return False.
=IsNothing(Fields!MiddleName.Value)
Although the above SSRS IsNothing function meets the requirement, replacing the empty column with something instead of True or False would be nice. So, let me create a new column called middle and use the IIf function to return ABC if it is nothing; otherwise, return the Middle Name. The IIf and IsNothing function expressions to perform the same are shown below.
=IIf(IsNothing(Fields!MiddleName.Value) = True,
"ABC", Fields!MiddleName.Value)
Please click the preview tab to see the IsNothing report.
