Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Limited RecordNumbers on Groups. 1

Status
Not open for further replies.

Bvontur

Programmer
Sep 2, 2003
4
US
Good morning.

I'm brand spanking new to Crystal with an upcoming training course, but I need a solution to this problem as quickly as possible.

My quality department wants five rows of data per person in a Case-like table. The output should look like this:

Name Case Number Record Number
John Black 123456 1
123457 2
123458 3
Suzy Zoo 012345 1
012346 2
Jeremy Jonez 654321 1
654320 2

Each person can work up to 50 rows, but I only want 5 sample rows. If they work less than 5 rows, I want all rows.

I'm using Crystal 8.5 with an Oracle ODBC.

Thanks in advance.
 
You could try the following:

Group on {table.person}. Then create a running total {#cntwingrps} using the running total editor. Select {table.person}, count, evaluate for each record, reset on change of group (person).

Then go to format section->details->suppress->x+2 and enter:

{cntwingrps} <> 1 to 5

This will suppress all but the first five (or fewer) records.

-LB
 
Thank you LBass, that was prompt, intuitive and completely accurate! Worked like a charm.

Thanks again, have a good one.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top