I am using wpreporter to generate sum value of one column, it works well when using one group in the report. but now i want to use wpreporter to generate report of master-detail structure. it can sum value of master records, but it can't sum value of detail values of one master record. here is an example, the expecting result is following:
but now i get the result is:
Code
master 1 1001
detail 1 2
1 3
1 4
sum 17
master 2 1002
detail 2 1
2 3
2 4
sum 17
grand sum 2003
Alles anzeigen
the problem is the sum of detail values are sum of all the detail records,but i want is the sum of detail records of same master record.
did i describe my question clearly?
please help me