You should be able to resolve the problem using the Count function in Crystal this is from the CR Help files. More information including examples are found there.

-------------------------
Count (fld)
Count (fld, condFld)
Count (fld, condFld, cond)
Count (x)
Arguments
fld is any valid database or formula field that can be evaluated by the function.
condFld is a field used to group the values in fld by.
cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime or Boolean field. For more information on the valid strings for this argument, see Conditions for summary functions.
x is an array of values that can be evaluated by the function being used.
Returns
Number

Action
Enables you to count the values that appear in your report (for a specified field). For example:

If a sales report includes all orders made and the amount of each order, you can compute the total number of orders that appear on the report (a grand total count).
If you break orders into groups (for example, orders grouped by the state that they come from), you can compute the number of orders per group (in this case, per state).
If you break orders into date or Boolean groups (for example, orders grouped by the month in which they were placed), you can compute the number of orders per group based on a particular change in the date or Boolean field (in this case, per month).
If you specify a set of individual values, you can compute the number of values in the set. For information on this kind of counting, see Array summary functions.
--------------------------------

*********Second Function that may be useful again from CR help
--------------------------------

Overloads
DistinctCount (fld)
DistinctCount (fld, condFld)
DistinctCount (fld, condFld, cond)
DistinctCount (x)
Arguments
fld is any valid database or formula field that can be evaluated by the function.
condFld is a field used to group the values in fld by.
cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime or Boolean field. For more information on the valid strings for this argument, see Conditions for summary functions.
x is an array of values that can be evaluated by the function being used.
Returns
-----------------------------------------------

You should be able to use these to create the formula needed to return the count you want. If you need help writing the formula, post it so we can help troubleshoot it.

Hope this helps

Regards,

John W.
www.CustomReportWriters.net