Selecting the first record of a record set

[clydejones]

Hello,
Is there a way to show only the first or last record of a recordset?

Thanks,
Clyde

 

[MalcolmW]

If you display a record in the report header, the record is the "first" record. The report footer displays the "last" record.
So, if you build your entire report in the report header or footer, it will display just one record. Malcolm

 

[dcm]

clydejones: As an alternative to MalcolmW's correct suggestion, if you merely want to display the first or last record contents together with other information you could create a formula using OnFirstRecord or OnLastRecord functions as e.g.

stringvar first_employee:= If OnFirstRecord then {Employee.FirstName} else first_employee

This would have the effect of making the first name available throughout your report David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner