top 10 detailed records

[PQTIII]

What is the easiest way to display only the last(most current events) 10 records for each group?

Thanks Paul

 

[synapsevampire]

Depends on database design, Crystal version, etc.

One method would be to sort the rows descending on the date field, and then use formulas to suppress those greater than 10 rows per group:

group header formula:

whileprintingrecords;
numbervar RowCount:=0;

Place a formula in the Details section as in:

whileprintingrecords;
numbervar RowCount:=RowCount+1;

Right click the details and select format section->X 2 next to suppress place:

whileprintingrecords;
numbervar RowCount;
RowCount > 10

-k

 

[PQTIII]

k

It work great!

Thanks Paul