Reporting Services: need to summarize the results of an expression.
This expression, in the detail line, properly, returns a 1 where there are no values in Deficiency.
It returns a 0 for each record with a deficiency:
iif(countdistinct(Fields!Deficiency.Value)> 0, 0 , 1)
If I could summarize these results, or capture them in a field where they could be summarized, or increment a counter, I would have the results I need: the count of records with no deficiency.
I've not had luck encapulating the IIF inside a sum, runningvalue, etc. I've not had luck incrementing a calculated field with the results, so I could summarize later.
I see where I could put some VB code in the report, but I'm used to working within events, and the books I've reviewed so far haven't been much help. How would I trigger the code?