Stop running sum(Over All) when customer change

  • Thread starter Thread starter Wahab
  • Start date Start date
W

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
 
Wahab said:
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?
Click to expand...


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.
 
Back
Top