Limited RecordNumbers on Groups. 1

[Bvontur]

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.

 

[lbass]

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

 

[Bvontur]

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

Thanks again, have a good one.