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