Crystal Reports has been doing my head in today. It always seems to be things that on the face of it should be easy to do that I struggle with. If anyone can help me with this it would be much appreciated:

All I want to do is display the first occurence of a field from the detail level in the group footer. For instance:

RecordID - Fruit - Buyer

100 - Apple - John
101 - Orange - Bill
102 - Apple - Mary

So I want to return the fruit field from the first line. I'm used to using OnFirstRecord in running totals but I can't figure out how to use them to get what I want here. Any Ideas?

Peter

So you want the lowest RecordID as the last 'group'. Did you set the group sort to descending?

I didn't but I think I see where you're going. If I sort decending and put the table field in the group footer it will display the last record? I'll give it a go.