472,103 Members | 1,086 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,103 software developers and data experts.

Crystal Report formula to keep running total/balance

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


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 2261

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.