Running Toal Problem

[hafizfarooq]

Hello,

I m using Crystal Report 9.
I want to make Account Ledger Report.
I have developed it using 3 formulas. (1) Initialize (2) Evaluate (3) LastBal

In Initialize i wrote:

whileprintingrecords;
numbervar RunningTotal;
runningtotal :={@LastBal};

In Evaluate i wrote:

whileprintingrecords;
numbervar runningtotal;
runningtotal := runningtotal + tonumber({Tbl_Ac_Ledger.Dr_Amt}-{Tbl_Ac_Ledger.Cr_Amt});

In LastBal i wrote:
0

I used LastBal for getting data from VB.

I have placed Initialize in Page Header and Evaluate in Details.

All working good. but the problem is that when report goes to 2nd page. Initialize got 0 and thats why calculate wrong because of the last balance of 1st page.

i want that when go to page 2 initialize automaticallly get the last balance of first page.

Please help me
Farooq

[mabbas110]

ok , well please if u can use the running total field provided by crystal report itself. it work correctly , still if u find the same problem then let me know.