I built an Inventory Report within Crystal. It basically gives me the Inventory at each location.

I want to limit it so it only brings in the top inventory record, because Inventory is not updated every day. I just want the most current record to pull in.

Can someone tell me how I can accomplish this in Crystal Reports 9.0?

My fields are

Product
Location
Date
Volume