Make formulas for the competitors to display a number across, say 6 of them, and set them to pickup their value on the respective detail record line 1,2,3 etc
@Comp1 @Comp2 @Comp3 etc etc
Group by a formula that changes value every 6 records and suppress the detail line and group header.
whileprintingrecords;
global numbervar MyGrouper:= 0;
in page header and
whileprintingrecords;
global numbervar MyGrouper;
if RecordNumber mod 6 =0 then MyGrouper := MyGrouper +1;
MyGrouper
(or is it "mod 6 = 1" ? I always get this backwards)
in detail should work (since it will be suppressed anyway)
In the group footer, add the formulas @Comp1 through 6.
Scotto the Unwise