>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

What I do is create a UDF that creates the group/report totals... have it return a string formated the way you want it to show on the report. Put it in a field/band that is set to streach as necessary.

BOb