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)
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)
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