display total amount to every g/laccount no to specified date in last of report or footer proplem

hi guys i make report as title daily receipt report this report consist of two tables
G/L Account
G/L Entry
this report as following
posted date g/l account no document no amount
15/03/2012 12 15 150
15/03/2012 12 16 200
15/03/2012 12 17 200
15/03/2012 13 18 300
15/03/2012 13 19 400
i make this report but what i need is to display total for every group to g/l account no to specified date in footer section or last of report but not after every group as following
:
15/03/2012 12 15 150
15/03/2012 12 16 200
15/03/2012 12 17 200
15/03/2012 13 18 300
15/03/2012 13 19 400
12 550
13 700

meaning make group to g/l account no to specified date to amount and display the amount in last of report

how i make this as above i make this before by group footer but it display after every group but not suitable solution for me.
please help me
thanks

Create a key on Posting Date ,GL Account No in G/L Entry table and create report from report wizard.

So you are back again [:)]

http://dynamicsuser.net/forums/p/51410/267424.aspx#267424

Mohana,

You are right He is back again with same question [:^)]

respect all guys in this forum but really until now no any one give me practical solution to this problem but if i take any solution to this problem why i ask again some person give me some solution i applied but not reach the result meaning it is not true

i m sorry to ask again

I respect all guys in this forum but really no any one give me solution to this problem some person give me solution i test and try but not applied meaning it is not true

if any one know practical solution to this problem please help me

i m sorry to ask again

thanks

We can give you the logic not code…

if you read all your posts you will get somany logic’s…you are failing to implement them…

what can we do?

I would suggest that create a key on G/L Entry table and create report through Report Wizard where you can spcified the grouping.

and then modify according to you requirement i.e aftwerwards you can add G/L account table in datatitems. Then set relation between them.