sql server reporting services: What version of SSRS are you running? In 2005 there is the expression
builder that will tell you definitively yes or no and if not what the
problem is. I believe your problem with this one is that you have not
told SSRS what to do if the count is not one. you need another comma
and some default value if the statement evaluates to false. Make sense?

Should this expression work?

=Count(Fields!Sequence.Value = 1, "Group1")

Hi Kurt. I haven't summed up row counts using a boolean in the field spec,
but you might also try this:

=Sum(IIF(Fields!Sequence.Value = 1, 1, 0), "Group1")

As long as you have a group in your table called "Group1", you should be
fine.
-Tim

[quoted text, click to view]