Skip to Content
0
Former Member
Jul 27, 2010 at 09:14 PM

Problem using Max formula for record selection

452 Views

Hi Folks - I have a SQL fleet management database that contains service information on vehicles. I have created a Crystal Report to pull out a list of vehicles and their latest service dates and mileages. I have succesfully created a field in the database - "Last Distance" using a Max formula. However when runing the report I get many lines of max mileages for each fleet vehcile. So I attempted to use the Record Selection Formula, to just pull out the last odometer reading per vehicle - and I'm getting error messages, including "The Field Cannot Be Summarized". This is a Max formula, not a summary. I've also gotten "Formula can't be used because it will be evaluated later", and have tried changing the evaluation timing, but without success. There must be a way to select only the highest value of a field, per vehicle. Any help would be appreciated, thanks.