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.text
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.text
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