I am using jasper studio and I want to print a Group-wise sum in another group footer for better understanding take a look below.
Class Group Header: Class One
Student Group Header: Student One
Subject | Total Marks | Obtained Marks ABC | 100 | 50 PQR | 100 | 80 AER | 100 | 30
Student Group Footer: Student One Total Obtained Marks: 160
Student Group Header: Student Two
Subject | Total Marks | Obtained Marks ABC | 100 | 20 PQR | 100 | 10 AER | 100 | 30
Student Group Footer: Student Two Total Obtained Marks: 60
Here above I can print each student's obtained marks separately in the student group footer, but I want to print the same in the Class group footer which means I want output like below
Class Group Header: Class One
Student Group Header: Student One
Subject | Total Marks | Obtained Marks ABC | 100 | 50 PQR | 100 | 80 AER | 100 | 30
Student Group Header: Student Two
Subject | Total Marks | Obtained Marks ABC | 100 | 20 PQR | 100 | 10 AER | 100 | 30
Class Group Footer:
Student One Total Obtained Marks: 160
Student Two Total Obtained Marks: 60
How can I achieve this result? Thank you in advance :)