Adding values

[taree]

I get an error is not null supported. can someone help

(if {U_order.order_status}='denied'
AND
{U_order.DATE_stored_RELEASED} is NOT NULL )
then 1
else 0

 

[Madawc]

You're using SQL syntax for Crystal. Try

if {U_order.order_status}='denied'
AND
not IsNull({U_order.DATE_stored_RELEASED})
then 1
else 0

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[taree]

thank you. that is very helpful