Mar 8, 2011 #1 taree Technical User May 31, 2008 316 US 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
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
Mar 8, 2011 #2 Madawc Programmer Sep 5, 2002 7,628 GB You're using SQL syntax for Crystal. Try Code: 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 Upvote 0 Downvote
You're using SQL syntax for Crystal. Try Code: 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
Mar 8, 2011 Thread starter #3 taree Technical User May 31, 2008 316 US thank you. that is very helpful Upvote 0 Downvote