I am using Crystal 9.0, Oracle DB.
I have interesting problem. When I just drop a field (number) from db it normally show 0 when it is no amount but if I take this field and create a formula:
if {FACTS_REPORTS_MAILOUT.RECEIPT_ADJ_TYPE} = "R" then
{FACTS_REPORTS_MAILOUT.AMOUNT}
and drop it on the report I receive null if it is no amount
Why???
I have interesting problem. When I just drop a field (number) from db it normally show 0 when it is no amount but if I take this field and create a formula:
if {FACTS_REPORTS_MAILOUT.RECEIPT_ADJ_TYPE} = "R" then
{FACTS_REPORTS_MAILOUT.AMOUNT}
and drop it on the report I receive null if it is no amount
Why???