how can i get the detail field from group footer.
i want to sum all this detail amt to footer.
can i refer to detail field like this report.detail.field{report_name} in formula field in footer????
i have main table m which contain one ID one amount
another table detail d which contain item for this ID.
after joining table m and d there is many amount field duplicate.
in detail
-------------------------
ID item amount
001 A 300
001 B 300
001 C 300
now i have adjust the amount in detail because there is many duplicate amount within ID.(i have adjusted in formula for the amount in detail section)
after adjust detail
--------------------------
ID item amount
001 A 300
001 B 0
001 C 0
but footer i sum the amount field as belows:
footer:
-----------
totol: 900 (<-- should be 300)
now i would like to get the detail amount so that the total should be 300+0+0= 300
how can i do this????
Edited by n__n - 14 Jun 2010 at 1:28am
IP Logged
