I’m not sure if this is possible but any insight you have would be helpful.

I have 3 records in my database – as follows:

ID          Quantity     Pay Date
P121          100          6/1/2010
P122          100          1/1/2015
P123          100          1/1/2015

I’m using crystal to combine the quantities into a single line by summing them if the first 3 characters of the ID are the same. So, it looks like this on my report:

ID          Quantity     Pay Date
P12          300          

You’ll notice in my above data that the pay date varies by ID. I want the pay date on my report to always show the latest of the 3 dates. Right now, crystal randomly selects one of the 3 pay dates above when I insert the “Pay Date” field and run the report. I get either 6/1/2010 or 1/1/2015 - randomly.

Can I control the pay date field so it always gives me the latest field in my summed total?

Thanks,
Steve
ID

This is great. Thank you very much.

To clarify - my goal was to display the maximum date so your solution is perfect.

Thanks again!

Steve