Using the Maximum function

[PauloMongo]

I have a date field showing the last time an item was brought and another field showing a quantity. I need to show the latest date something was brought, I can use the maximum function to return the date, but how do I return the value associated to that date, I can not use the maximum function on the quantity field as the value before may have been higher.

Any ideas ????

 

[dgillz]

If your date field shows the last time something was bought, then just place it in the report, no formulas required.

If your data field shows the date every time someting was bought, not just the last time it was bought, place it and the quantity field on the report, sort the report so that the latest date is at the top of each item (I am assumming you are grouping by item) then also place your fields in the group header, and hide the details section.

Let me know if you have any questions. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com