Count on boolean column

[resdevlabs]

I need have a boolean column in my report for which I need to count the number of TRUE values and the number of FALSE values. I have two groups - 1) Subject 2)MetSLA (the boolean column on which I need the counts). I want the counts to appear on the footer of group 1. I have tried

Count({@MetSLA},{@Subject},"every Yes")

, but I receive the message "The summary/running total field could not be created".

Anyone have any ideas on how to get this done?

Thanks in advance,
Rob

 

[IdoMillet]

One option is to create a formula:
---------------------------
IF {@MetSLA} THEN 1 ELSE 0
---------------------------

Then, SUM that formula.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com