Displaying only the most recent date?

[pokerace]

C10

I have a report that groups be SSN and then by Date. For each day, the report will display the date, number of hours worked that day, and total hours worked for the month so far (formula field). I would like the the date group to only display the row with the highest date. For example:

Jim Smith

7/28/06 5 hours 5 total
7/29/06 5 hours 10 total
7/30/06 4 hours 14 total

so that it only displays the last line only:
7/30/06 4 hours 14 total.

Thanks.

 

[Madawc]

Choose Report > Record Sort Expert. Put the detail lines in date order, ascending or descending.

You can now show the most recent details in the group header or footer, suppressing the other detail lines.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[synapsevampire]

When you group by date, do you mean the month? If not, insert another date group by month above the day grouping.

Then a formula of:

maximum({table.value},{table.date})

will produce the results providing you drop it in the group header or footer of the month.

-k