Count

[lous]

I have a Crystal Report that prints data from an Access database for a 5 day period.

What I need Crystal to do now is to actually count how many of the records actually has data in them and output the total. For example, if one person had data for 5 days, it would display 5. If someone else only had data for 2 days, it would say 2 (the other 3 days are null).

I'm sure this is easy, but I can't figure it out and was hoping you all could help.

Thanks!

 

[stormtrooper]

Create a formula:

@my_formula:
if isnull({your_field}) or {your_field} = ""
then 0
else 1

Now summarize on the formula field.

 

[synapsevampire]

Group by the person.

Right click the date and select insert summary->Count

It's hard to say if this is what you want, you're best served to post example data and expected output.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com