Groups | Blog | Home
all groups > sql server reporting services > august 2005 >

sql server reporting services : Conditional Coount


C a r l o s - A n t o n i o
8/17/2005 4:41:55 PM
Hi,

how do I condittionally count the result of a field. Like count if of
something like that...


thanks...


Robert Bruckner [MSFT]
8/17/2005 6:44:48 PM
Try this:
=Sum(iif(Fields!X.Value = "SpecialValue", 1, 0))

or this:
=Count(iif(Fields!X.Value = "SpecialValue", Fields!X.Value, Nothing))

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

[quoted text, click to view]

C a r l o s - A n t o n i o
8/18/2005 9:50:44 AM
with little changes it worked pretty well. Thanks for your help...
:)


[quoted text, click to view]

AddThis Social Bookmark Button