how to calculate data at run time in crystal report 10

[muddasirmunir]

how can we calculate data at run time in crystal report 10
i had made three fields in my database name
debit,credit , balance
debit and credit shows data directly from database now i want
a third field balance which is not stored in database and it has
to show the debit -credit values in report after each recodd
like
de cr balance
10 0 10
0 10 0
20 0 20
how can i do this.

second i also want previous balacne at the top which is the
sum of all the debit-sum of all the credit before that date
i know the query about this but how can i show it only one at
the beginnig of the report and add that value in first record in
the balance field

thanks in advance

[debasisdas]

Try to add a SQL Expression field to the report. That can easily solve your problem.

[QVeen72]

Hi,

In CR Designer, Add a Formula say MyBal:

{MyTableName.Debit}-{MyTableName.Credit}
 

And then Place it in the Detail Section of the Report , hide this formula and Add a Running Total for this Formula..

Regards
Veena

[muddasirmunir]

this code only add or subtract the debit and credit field at the
current line ok
now i also want to add in it the balance of the previous line
of the report
how cant i take the value of the previous line just above any line
of recorset .
if you can explain i will be thank ful

Hi,

In CR Designer, Add a Formula say MyBal:

{MyTableName.Debit}-{MyTableName.Credit}
 

And then Place it in the Detail Section of the Report , hide this formula and Add a Running Total for this Formula..

Regards
Veena

[muddasirmunir]

thanks Veena,
for solving my problem.

[muddasirmunir]

hi all

now i am facing anothe problem in it , as long as balance is concrned
running field sovle my proble now what i want to add a spcific number
it may be 0 or from query sum(debit)-sum(credit) to the firslt
record of the runnig total

[QVeen72]

Hi,

Write another Formula say :

If RecordNumber =1 Then
  200
Else
'Your old Formula
 

Regards
Veena

[muddasirmunir]

now , there is another porblem i am facing
i made a formulal field and give theme a code

(slaes.credit)-(sales.debit) +200

and then made a runnnig total of formula field
its work fine

but i know want not to add 200 to it but want to add the resulte
of the following querey

"select sum(credit) - sum( debit) where date < userinput"
or
the number which is is any form for this i use the following formula

(slaes.credit)-(sales.debit) + form1.text1.tex t
but its shows an error

i want answer of how inseted of 200 we give number given by the query
and
how to add number which is in form1.text1.tex t
how to solve this
thanks

Hi,

Write another Formula say :

If RecordNumber =1 Then
200
Else
'Your old Formula
 

Regards
Veena

[QVeen72]

Hi,

Create One more formula say F_OpBal
Initially assign Zero to this formula.
and pass the Textbox value From VB6..

and in CR, use this :

(slaes.credit)-(sales.debit) + {@F_OpBal}
 

Regards
Veena