Hide Duplicate question?

[Apollo6]

I have a mileage report that a supervisor signs off on an employee's records for the month. If the same supervisor signs off on say, 10 records, I want to Hide Duplicates. Okay, no problem, set flag to YES. It prints the supervisor's name on the first record and hides it on the rest.

However, I don't want to print the supervisor's name on the first record and hide the supervisor's name on the following nine records. I want to hide the supervisor's name on the first nine records and print it on the 10th record.

Any suggestions?

 

[THWatson]

Apollo6
If there's a way of knowing which is the 1st through the 10th record...could you sort in Descending order? Then your 10th would show and Hide Duplicates would be from record 9 through record 1.

Tom

 

[Apollo6]

I can't sort in descending order. Basically, each record has a date. The report needs to display from the first of the month to the last.

I attempted adding a group footer for the supervisor but haven't had much luck getting that to work either. I also was looking at the On Print event but not sure about that either, somehow looking at either the OLD value or the next value and doing some type of comparison.

Still thinking about it.