CODEWITHSUNDEEP
sql-serverssrs-2008reporting-services
Behrang Saeedzadeh
Behrang Saeedzadeh

Reputation: 47913

SSRS counting null values

How can I count the number of null values using SSRS? The following expression is not working:

= Count(IsNothing(Feilds!.FieldName.Value))

This also isn't working:

= Count(Feilds!.FieldName.Value Is Nothing)

Upvotes: 1

Views: 11167

Answers (1)

Kevin Ross
Kevin Ross

Reputation: 7215

Try

=Sum(IIF(IsNothing(Fields!FieldName.Value),1,0))

I don’t have my copy of SSRS to hand but that should work just fine

Upvotes: 5

Related Questions