Limiting record returns to Crystal

[seller]

Sample table structure is :

ID COURSENUM CODE
28244 12200100 A
15639 12200100 U
28244 44001000 A
36186 44001000 U
28244 12200100 U

As you can see from the table above ID 282244 has entries of the same COURSENUM (12200100) twice. I need to limit the return to Crystal only data where the number of ID and COURSNUM matching pairs are greater than 10.

TIA

 

[IdoMillet]

Group by ID and within ID by COURSNUM.

Use a Group Selection Formula of
-----------------------------------
Count({COURSNUM}, {COURSNUM}) > 10
-----------------------------------

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

http://www.MilletSoftware.com

 

[seller]

Ido,

That worked great! I had started looking at the count function but could not get it to work until you pointed out that it needs to go into the group selection.

I appreciate the help.