how to display only first and last record in a report

[faisalsham]

I have a list of records, however I only want my report to display the first and last record on the report.
here is a sample of what I would like:

records
-------
A1001
A1002
A1003
A1004
A1005


To Be Displayed on the Report
-----------------------------

A1001 A1005


Thanks in advance.

 

[lbass]

Use two formulas:

//{@min}:
minimum({table.field})

//{@max}:
maximum({table.field})

-LB

 

[lbass]

Or actaully, just insert a minimum on the field, insert a maximum on the field, and then suppress the detail section.

-LB