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?
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