469,902 Members | 1,948 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,902 developers. It's quick & easy.

Crystal Report formula to keep running total/balance

228 100+
I am using CR for VS 2010. Basically, i need such report:

GIVER ITEM QUANTITY BALANCE
UNDP DELL 10 10

SAMI 2 8 (means sami took 2 pcs, so 8 remain now)
DANIEL 3 5 (means daniel took 3 from the 8 remaining so now we have 5)

UNAIDS DELL 8 13 (13 is now the 8 given plus the 5 remaining on top)

BERHE 2 11

....

My initial try was to create a formula that sums up total taken in a specific batch. that is like 2+3, 2 in above example. That worked fine thru grouping.

The problem is i cant add that balance to the next batch. i.e. the 8 dell from unaids to the 5 remaining dell from previous. The first balance is always same as its quantity which i get easily thru RecordNumber=1 then same

But for the next batch, i need to get the balance from previous batch, add it to the current batch'es quantity then go on calculating. My failure is saving the previous batch's balance and adding it.

Any idea?
Dec 24 '12 #1
0 2183

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by PlumeProg | last post: by
reply views Thread by Learner | last post: by
reply views Thread by misgina | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.