Wednesday, January 30, 2013

How to check NULL in SSRS Formula Expression

The problem that literally takes a week to find solution is that I can't find any way to handle NULL values in my SSRS report.

Suppose Field1 returns NULL value, i need to check if Field1 is null then 0 else Field1

Solution:

Right now you can do it by building the following expression:
if(Field1 = Empty, 0, Field1)

No comments:

Post a Comment