partial results in Crystal Report 4.6

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!
LVL 2
ceroAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
TimCotteeConnect With a Mentor Commented:
Create the formula field as:

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

This will give a running total.
0
 
ceroAuthor Commented:
I will test.
Thank you.
0
All Courses

From novice to tech pro — start learning today.