Hi.

I have a report with two subgroups: 

SB1   Teacher
SB2   Subject

I also have a subreport which is linked by Subject to the main report.  I the subreport, I have a calculated field showing the average grade of students in the subject - avgrd.  The subreport is in GH2.

In GF2, avgrd is showing correctly.

I want to show a variable in GF1 that will calculate the average grade of all students under the same teacher by adding all the avgrd returned from the subreport and displayed in GF2 / the number of subjects handled by that teacher.

I was able to summarize the above by using a local variable and another shared variable.  In the main report using a variable that contains the following:

whileprintingrecords;
SHARED Numbervar avgrd;
SHARED Numbervar tavrg;
Local Numbervar a;
a:= avgrd;
tavrg:= tavrg + a;
avgrd

THEN, in GF1, I placed a variable with the following formula:

whileprintingrecords;
SHARED Numbervar tavrg;
tavrg

My problem now is that tavrg does not reset for every change in the teacher group.

Ideas please?   Thank you.
 


Edited by ramon010 - 19 Nov 2011 at 3:37pm

in the group header place a formula like: