Help Please count based on critera

[wayneCl]

Need to add a number of count fields to a report.

contact.rec field has either "D" , "A" , "O"

what im trying to do is count the number of "D" recorders

i have tried count{contact.rec) = 'D'

and other methods with no luck

do a simlar count in R&R reports with no problems just woundered what im doing wrong.

Thanks

 

[IdoMillet]

You can use 3 running totals with an evaluate option based on a formula.

Alternatively, you can use a CrossTab.

Alternatively (and this is the technique I prefer),
you can create 3 formulas like:
------------------------------------
IF {contact.rec) = 'D' THEN 1 ELSE 0
------------------------------------

Place them in the detail section and SUM (note: not COUNT!)
them.

Cheers,
- Ido

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

http://www.MilletSoftware.com

 

[wayneCl]

Thanks for the help