I'm trying to figure out how I can count a field only if it equals a specific value but I can't seem to find or figure out the syntax
basically i want something like =Count(Fields!Severity.Value) where Fields!Severity.Value = "Critical"
but that is obviously not right because it comes up blank.
I've tried every language I know and the reporting seems to be a mix of SQL and vbscript but I just can't seem to get it.
try this thread
Documentation for Report Designer in 9.6
Put me on the right track, found what i needed here
=AggregateIf(Fields!Severity.Value="Critical", Count, Fields!Severity.Value)
Retrieving data ...