Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding values

Status
Not open for further replies.

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
 
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


[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]
 
thank you. that is very helpful
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top