Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display total of a group in each record of the group 1

Status
Not open for further replies.

musini

Technical User
Jan 19, 2008
75
US
Hi All,

I have a group in the repot, based on that group I am displaying the details now i have to make the sum on a particular column which is in the details and reset the sum on change of group column value. AAll this is fine but the sum i am making should be displayed on each row of the details in the group onsted of the group footer.

ex:

group a1
abc 2 8
def 5 8
ghi 1 8
group a2
jkl 7 14
mno 6 14
pqr 1 14

in the above example 8 and 14 is the sum of col2 value for that group details. i want it not in the group fotter but in each record of the group.

Thanks,
M
 
Create a formula:

sum({table.col},{table.group})

Place this in the detail section.

-LB
 
Thanks L.B it works perfect. Thanks so much.

M
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top