The SSRS IsNumeric function is an Inspection function that checks whether the given field or expression is a number. If it can be evaluated as a number, it returns a boolean True; otherwise, it returns False. The syntax of the IsNumeric function to find whether the column value is a Number (numeric) is as shown below.
=IsNumeric(Fields!Income.Value)
To demonstrate the SSRS IsNumeric function in reporting services, we use the Employee table below, which has 20 records. The image shows the records in the Table report.
SSRS IsNumeric function Example
For this, let me add a new column to the right side of the Sales column. Next, right-click the textbox under Is Numeric and choose Expression to open the expression window mentioned below. The IsNumeric function expression below will check whether the values in the SalesAmount column can be evaluated to a number. If they can, return Boolean True; otherwise, return False.
=IsNumeric(Fields!SalesAmount.Value)
Let me create one more column to evaluate the YearlyIncome column.
=IsNumeric(Fields!YearlyIncome.Value)
Although the above SSRS IsNumeric function expressions meet the requirement, showing any message instead of True or False would be nice. So, let me create a new column and use the IIf function to return Good if it is a number; otherwise, it will return Bad Entry. The IIf and IsNumeric function expressions to perform the same are shown below.
=IIf(IsNumeric(Fields!OrderQuantity.Value) = True,
"Good", "Bad Entry")
Please click the preview tab to see the IsNumeric report.
