Watch this video demonstration for how to check is null in a Reporting Services Expression http://youtu.be/k2P4Qi20jkA.

To perform the equivalent of isnull in a Reporting Services Expression use the IsNothing command. Begin by using IsNothing to determine if your measure is null, wrap it in a conditional IIf statement.   When the value is null, return 0, otherwise return the original value.

=IIf(IsNothing(Fields!YourField.Value),0,Fields!YourField.Value)

3 Comments

  1. Pingback: How to check is null in a Reporting Services Expression | POP-BI

Leave a Comment

Your email address will not be published. Required fields are marked *