How to show oldest recode for particular region and date in the singletons

[jd]

I have list report with 6 coumns. filters are region and start date and end dae.

for particular region and for period of time I will get ex: of 10 records.
in my report top of the list I have singletons for all the list columns. in that singltions I have to show up oldest record for that particula region and date range.

any help can I get in this?

[PRIT AMRIT]

How you r determining the oldest record? U mean the lowest date value?

Create another data item in your singleton query and use the same to show in your report.

Minimum([DATE] for [region])

Hope it helps?

Thanks
P