"#of records greater than or equal to X " formula

[JoyCR9]

Crystal Reports 9


Group Name One is: {Company.Company_ID}
Group Name Two is: {Service_call.Service_call_id}

Group One Footer has a Distinct Count of {Service_call.Service_call_id}


I want my report to print the service call history for the given date range based on 3 or more service call ids per company id in that date range (ie: print the info on those companies with 3 or more calls per quarter).

How do I write the group selection/or record selection formula for this?

 

[vidru]

Your Record Selection Formula would limit the records by your date range parameter, and your Group Selection Formula would be:

DistinctCount ({Service_call.Service_call_id}, {Company.Company_ID}) >= 3

-dave

 

[JoyCR9]

DUH!!!! Way too easy. Had been making this harder than necessary.

Thanks for your help, Dave.