I am going through employee records from a temporary database table. The detail records on the report are suppressed. I have a field called 'match' in each detail record. I have a group for each employee. At the group level I have an average of the 'match' field. So far, everything works just great.

At the report footer I want a total of those group averages. I cannot, for the life of me find a way to do that! I can't sum it. I tried using formulas and when I get to X := X + @averagefield, I am told the field cannot be summed.

I am very close to saying screw Crystal and write something in my VB code to move the average and emp# to a temporary table and link to that on the report. I am sure there is a way to do this, I just don't know how.

PS. It is Crystal Reports 9.2.3