Thanks for your reply Rich,
You are correct, I could calc the totals in a cursor and populate the last rec of the group in the cursor with the total. That is more trouble than it is worth. I thought there might be a way through the report generator. Unless my client barks, I will leave it as is
vince