I have a report that uses a select statement to build the data into a cursor grouped by employee. The employee pages can have 1 to infinite lines of grouped totals based on work codes (one line per work code).

The client would like a "recap" total at the end of the report. The recap total is to list all work codes previously listed on thier employees and a "group" total for each code.

If it was just a column, total, no problem.. Now it is almost like another report without the employee group breaks. What is the best way of handling a situation like this?

Thanks