|
-
Jun 26th, 2003, 09:35 AM
#1
Thread Starter
Member
Help Me
Hai !
I am working with Crystal Reports 8.5 ver.
i have designed a report from a query. in the report I wanted to have a formula field. I did it and it is working fine but... there is a problem with it .... if there is a value which is blank (null) then it is not returning any value... how to rectify this?
my query data will be as follows....
AccountName --- DebitAmount --- CreditAmount
----------------- ---------------- ------------------
RaviKumar-----------10,000.00------------2,000.00
Krishna----------------3,500.00-----------11,000.00
saradhi----------------5,000.00------------------------
Prasad----------------------------------------2,500.00
Raju--------------------4,000.00------------2,000.00
In crystal report.... i made formula field named.. BALANCE.
BALANCE =
if DebitAmount > = CreditAmount then
DebitAmount - CreditAmount
else
CreditAmount - DebitAmount
while using the above thing in CR.... i got the values of BALANCE column as
AccountName --- DebitAmount --- CreditAmount --- BALANCE
----------------- ---------------- ------------------ ---------------
RaviKumar----------10,000.00------------2,000.00----------8,000.00
Krishna---------------3,500.00-----------11,000.00----------7,500.00
saradhi---------------5,000.00----------------------------------------------
Prasad----------------------------------------2,500.00----------------------
Raju-------------------4,000.00-------------2,000.00----------2,000.00
[ Have u observed the above....? ]
for 3rd and 4th record there were no values are returned.....
Please solve my problem.....
Thanks in advance...
Last edited by satyarao; Jun 26th, 2003 at 09:43 AM.
satyarao
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|