The simplest way I can think of is to convert your table links to a SQL statement that pre-consolidates your "multiple-gift-on-same-day" rows into a single row using GROUP BY. Then, your Crystal experience is fine. In other words:
SELECT ID, DATE, SUM(AMNT)
FROM TABLE
GROUP by ID, DATE
If that luxury is not an option (i.e. the report is already built, you don't feel comfortable with SQL), then do the following:
1) Group by Person
2) Group further by ID and Date combined (make a formula that concatenates the two and use as your group field.
3) You can do this step at any time, but suppress detail and the group footer sections of group 2. We won't need them.
4) Create a Sum(AMNT) subtotal for the second group and place it in the group header so it is visible.
5) Use TOP N aka Group Sort expert to Sort Second group by biggest sums first. This will place the maximum consolidated sum at the very top for each Person.
5) To suppress all but the top row for each Person, use a formula in Section Expert>Suppress similar to the following:
Previous({@group_field}) = {@group_field}
6) This will give you the maximum consolidated amount for each person. Make any other cosmetic changes and you are done.
These are a few steps, but that is the price we pay for having a data structure not in agreement with our data objective. Note that if you are also including grand totals, running totals will have to be used in lieu of standard grand total functions or it will pick up the hidden amounts. If yours is destined for export, however, this is probably less of a concern.
