double grouping in Crystal 9.2

[lana123]

Hi,people.
I try to group data for my report but I cannot understand why one of group doesn't work.
I have to show in my report the doctors which have more than 2 patients and each patient has to do payment equal or greater than $100.00(in Details I have to show all information for each patient).
I create 2 groups:first-doctors,second-patient and I wrote these formulas for groups:
sum({field.payment},@patient)> 100 and
distinctcount({field.patientname},@doctors)>2
I cannot understand but "distinctcount({field.patientname},@doctors)>2" doesn't work.

I'll appreciate any answer.

Thanks,
Lana

 

[synapsevampire]

Try posting technical information, it's not clear to me what you're asking:

Database/connectivity used
Example data
Expected output

-k

 

[Madawc]

If you have Crystal 8.5 or better, try using a Running Total. Or right-click and use [Insert] and [Summary]. Let Crystal do the work for you, rather than doing your own detailed coding.

Madawc Williams (East Anglia)

 

[lbass]

Lana, what are your formulas for {@doctor} and {@patient}?

-LB