Effectively using MAXIMUM functions for dates within groups

[Guest_imported]

We have Crystal Reports 7.0, and I need to find the maximum date, separately, for several different groups. EX) 25 people with 75 dates between them, or 3 each. I need the report to pull only the most recent date for EACH person, and not have the person duplicated with all dates.

 

[swilliams]

If you are using something like Access for your database, why not do this in the native database - select the maximum date for each person as an extra field in your query (that is if you are basing your report on a query!!) and then you just need to show this extra field on your report, and reduce the processing that the crystal engine has to do.

 

[Trapper13]

I'm drawing the data from a homemade SQL table, and I honestly don't know any MAX functions in the query side of things to make this 'extra' date possible. If you have any ideas, i'm always up for them. Thanks much for the response.

 

[LindaC]

Have you tried grouping by person. Put the date field in the detail section, right click on it and choose Insert Summary then on the screen displayed choose maximum in the top box and your group field in the second box.