I am trying to use the minimum date for a report. Basically I have orders that come in and I need to only see the first receive date of these orders. I can get this. But the issue is when I look at the qty received it is not pulling the right amount. It pulls it from another date. I have tried to group on minimum date but it is not working.   Sample data - Order 105 - ordered 100 - first receive date 2/5/12 - receive 5, next receive date 2/10/12 and receive 80. The 80 is showing up in my line. I am not using the detail section - I've tried that and no luck either.

I have done the following to link a date with a result.

(year({@BMI_obsdate})*10000) + (month({@BMI_obsdate})*100) + (day({@BMI_obsdate})) + ({@BMI_obsvalue}/1000)

Which creates an entry like 20130214.024 for Feb 14, 2013 and BMI of 24. Thus, assuming only one entry in a day, I can grab for max or min of this field and then pull it back apart with before the decimal being the date and after the date being the result.