views:

13

answers:

1

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)
+1  A: 

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

Kevin Ross