Stop running sum(Over All) when customer change

[Wahab]

Dear All

I hv report based on tblTransaction which contains many customers with their
transactions by date wise. I grouped report on CustomerID sub Group by
Fromat(trnDate,â€MMM-YYâ€) to get monthly transactions for each customer. I
made calculated field to obtained closing balance with running sum over Group.
I want to make the Running sum – over all but when customers is changing it
must stop and start again, by default it will give running sum of all the
customer, exactly this I don’t want. Any idea to stopped or make running sum
based on customer when month is changing it should carry on so I will get
uptodate balance of each customer?
Thanks in advance

 

[Marshall Barton]

I hv report based on tblTransaction which contains many customers with their
transactions by date wise. I grouped report on CustomerID sub Group by
Fromat(trnDate,”MMM-YY”) to get monthly transactions for each customer. I
made calculated field to obtained closing balance with running sum over Group.
I want to make the Running sum – over all but when customers is changing it
must stop and start again, by default it will give running sum of all the
customer, exactly this I don’t want. Any idea to stopped or make running sum
based on customer when month is changing it should carry on so I will get
uptodate balance of each customer?

You need two RunningSun text boxes. Add a text box to the
month group footer section. Set its expression to
={first run sum text box}
and set its RuningSum property to Over Gtoup. Because it is
in a group footer section it will keep going until the next
higher level group changes.

 

[Wahab]

Thanks Mr. Marshall,
It's very easy.
Once again thanks.