My client had a desire to show that some numbers were “NULL” instead of either blank or zero (0) when they appeared on a particular report. I looked for a check box that might handle this but no thanks to SSRS I had to create an expression using the IsNumeric Function.
Check it out:
If the Quantity is a number, it returns the number. Otherwise the word “NULL” is returned.