Click to See Complete Forum and Search --> : Adding some Values to Running Total in Crystal Report 8.5


hafizfarooq
September 10th, 2006, 08:11 AM
Hello
I m creating Account Ledger Report in Crystal Report 8.5.
I have put DATE , DESCRIPTION , DEBIT & CREDIT fields from Tbl_Ledger
and for balance i have created a Formula (RemBal) and write the code Tbl_Ledger.Debit - Tbl_Ledger.Credit

This (RemBal) has put it in Running Total.
I also have a formulafiled LASTBALANCE which value is = 500

I want to add that LastBalance value in First line of Running Total. but it effects on all lines.

How can i do this ?

Please help me

thanks in advance
Farooq

sraheem
September 11th, 2006, 01:07 AM
use formula for running total.
something like this for detail section

WhilePrintingRecords;
NumberVar A;
A := A + 1;

u can add if conditions, as u need.
To reset this running total add another formula in ur group header

WhilePrintingRecords;
numbervar A := 0;

hafizfarooq
September 12th, 2006, 08:48 AM
Thanks for ur reply.
I m sorry, i did not understand the solution. Please use my variables in ur formula. If u have any sample report for this, please send it to me. I shall be grateful to you.

Farooq
scobra98@yahoo.com

sraheem
September 13th, 2006, 02:44 AM
Attach ur report