Zero an empty SSRS table field

If a table value is returned as NULL then its appearance may be improved by displaying a ‘0’ instead.  this is achieved by the expression:

=IIF(Sum(Fields!theCount.Value) is Nothing, “0”,
Sum(Fields!theCount.Value))
Advertisements