473,703 Members | 2,356 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Crystal Report formula to keep running total/balance

228 New Member
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 2378

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

Similar topics

1
4157
by: PlumeProg | last post by:
Hello, I can't find a way to bind a dataset at runtime as a source for my report source. I looked into msdn and found some sample : ms- help://MS.VSCC/MS.MSDNVS/crystlmn/html/crtskaccessingsecure databases.htm ' Declare require variables. Dim logOnInfo As New TableLogOnInfo()
0
970
by: Learner | last post by:
Hi there, I am just trying to populate crystal report with customers data from Northwind database. The below is the code. It doesn't return any error and i can see the report in the front but the report is empty. It doesn't have the data in it. i am i missing some thing here? Please help thanks -L
0
1774
by: Reena83 | last post by:
Hi guys, I am having heaps of problems with crystal reports and vb6. Basically I did a sample project and that works fine. Where I have a print button and rptCRControl.ReportFileName = "BooksInCat.rpt" rptCRControl.SelectionFormula = "{tblCategories.CatNum}= " & mrsCategories!CatNum rptCRControl.Action = 1 Because we view by categories and each category details get printed separately. This was grouped by CatName.
0
867
by: misgina | last post by:
hello; i have dot net 2003 and crystal report that comes with it, but now i have installed crystal report xi release 2. how can i use the newly installed crystal report with my dot net 2003. can any one help me on this thanks on advance
1
1769
by: davidreid | last post by:
Hi, I created 2 seperate Crystal reports and each report performs its own calculations. However, I need to multiply the output of Report 1 with the output of Report 2. I created a new Crystal report and inserted Report 1 and Report 2 as sub-report 1 and sub-report 2 in my new Crystal report. The output of both sub-report 1 and sub-report 2 are numeric. I need to find out how I can multiply the output of sub-report 1 and sub-report 2 so...
0
873
by: kaushalbhavsar2002 | last post by:
Hello every one, I m designed and formatted crystal report when i m transfer to client machine the alignment was lost... so how can i lock all the field in crystal report, so i the problem will solve. thanks & regrads Kaushal Bhasar
0
1218
by: journeycross | last post by:
Hi, I'm trying to enter a formula to display a fixed value for each named category. I'm getting error messages when I try various configurations of this statement. Any idea why it is invalid? Thanks! IF {Prt.Prt_Participation}="Corporate Underwriter" THEN "$250,000" ELSE IF {Prt.Prt_Participation}="Organizational Underwriter" THEN "$80,000" ELSE IF {Prt.Prt_Participation}="Sponsor" THEN "$300,000" ELSE IF...
0
3148
by: gkinu | last post by:
Crystal Report for Visual Studio.NET 2003. I have a formula that brings an error " .. A number is required here ... ". See the code snippet below which i have simplified. In the actual formula, the function NthLargest is being accessed in a loop hence the need to have the first parameter being a variable (pos): numberVar pos := 1; NthLargest (pos, {Table1.score}); This will throw an error " .. A number is required here ... ". If i...
2
3077
by: wassssup | last post by:
hi all im using C# in vs2005 and i need to include a crystal report in my program. i have added a new item -> crystal report. then the screen appears where there are 5 section. i've added 4 text object in the 2nd section product, product code, price and quantity. what should i do next? in the windows from, i also have these 4 textbox. my idea is to extract these 4 fields from a database into the textbox, then from the textbox to the crystal...
0
1387
by: Limno | last post by:
Can anyone suggest me, How can i do this in crystal report, for i=1 to 5 { i=i+1; printf(i); } o/p must be
0
8674
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9265
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8971
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7878
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5923
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4435
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4690
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3127
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2463
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.