John,

Try having the expression evaluate like this:

Count(iif(cint(field!.condtion1.value)=-1, 1, nothing))

I have a simple report, listing patient names, and then columns depending on
certain condition. If they have the condition the column is True, and if
they don't the column is false.

The problem I have is trying to count how many have each condition. I
inserted the following expression in the footer:

=Count(cint(field!.condtion1.value)=-1)

If the column is true it does resolve to a -1, a 0 if it is false.
The expression just counts every row. It doesn't seem to evaluate the
expression.

Any help would be appreciated.

John Hart

or try

SUM(iif(field!.condtion1.value = true, 1, nothing))