i am using vb6 and crystal report 10 with sqlserver 2000
i made a formulal field in crystal report 10 where i had a table
name sales , it has two numeric fields credit and debit and
give theme a code
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
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
in some report i want to add number from query and in some reports i want to add number from the textbox in form.
how to solve this
thanks
i made a formulal field in crystal report 10 where i had a table
name sales , it has two numeric fields credit and debit and
give theme a code
Code:
(slaes.credit)-(sales.debit) +200
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
Code:
(slaes.credit)-(sales.debit) + form1.text1.text
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
in some report i want to add number from query and in some reports i want to add number from the textbox in form.
how to solve this
thanks
Comment