Solved

partial results in Crystal Report 4.6

Posted on 2000-03-05
2
231 Views
Last Modified: 2013-12-25
Hi,
I want to make a Report in Crystal Reports 4.6 like this:

Product_Id 00045
Moves:
  Date  In   Out   Partial R.
  12/02 10    0       10
  13/02  0    5        5
  14/02  0    4        1

Product_id  00046
Moves:
  Date  In   Out   Partial R.
  11/02 12    0       12
  14/02  0    3        9
  15/02  3    0       12

Well, the problem is: I don't know how to show  the partial Result column.

When I use the Previous function in a formula:
@fPartialResult = In - Out + Previous(@fPartialResult)
I get a error, the formula can't call itself.
If I use another formula for trick, the error , the formula can't call itself directly or indirectly appears.

I need HELP!
0
Comment
Question by:cero
2 Comments
 
LVL 43

Accepted Solution

by:
TimCottee earned 250 total points
Comment Utility
Create the formula field as:

WhilePrintingRecords;
numberVar Partial;
Partial := Partial + {Table.In} - {Table.Out};

This will give a running total.
0
 
LVL 2

Author Comment

by:cero
Comment Utility
I will test.
Thank you.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now