Monday, November 3, 2014

SSRS Display Zero for Nulls

Josh,

So you have a report where there are null values in some of the text boxes.  To display zero instead, use this handy expression.


=IIF(
IsNothing(
Fields!MyField.Value
),
0,
Fields!MyField.Value
)

No comments:

Post a Comment

Please only include comments that add to the substance of the Blog Post:
- Question or request for clarification
- Idea for improvement
- Identifying an issue

Please refrain from promotion.