depends on how you want to use it...if you only want to display the record associated with the earliest date, I would set a variable in the group header and then suppress all detail records that don't match...
in the header
global datevar earliest := {table.datefield};
"" //to hide the assignment (or don't use and place on the form where the date would be displayed)
in the Section Expert for the detail section:
global datevar earliest;
earliest <> {table.datefield}
Hope this points you a direction that'll work for you
Anyway I just wrote a report which I'm pulling information from 3 tables, the main one being our Inventory file, and I want to pull information from the Open Order file, but since there are multiple open orders with the same Inventory part, I want to pull ONLY THE RECORD WITH THE EARLIEST DUE DATE. I thought if I put the information in the Heading section of the Inventory Part group that it would work, which it did, but when I do that, I am getting repeats of a detail section below. Any help would be greatly appreciated. Thanks! 
IP Logged
