Conditional DistinctCount -- sql server reporting services

Anand Prabhu
8/25/2004 9:43:10 PM

I want a distinctCount in a group for a criteria. How can i do it
I am doing something like this

=CountDistinct(IIF(Fields!CATE.Value='N'),Fields!ERNR.Value,nothing),
"grpResCat")
Is this right?

Robert Bruckner [MSFT]
8/25/2004 10:10:44 PM

Try this:
=CountDistinct(IIF(Trim(CStr(Fields!CATE.Value)) = "N", Fields!ERNR.Value,
Nothing), "grpResCat")

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

sql server reporting services : Conditional DistinctCount