Testing for NULL 1

[mattyboy2000]

I am using Crystal Reports for VB.NET and have alittle problem.

I am conditionally supressing two labels. One has a tick and the other is a cross. the code i am using is:

if {customer.ACCT_STAT} = 'S' then true else false
'Cross

if {customer.ACCT_STAT} <> 'S' then true else false
'Tick

the problem I have is that the Tick is still shown if the value in {customer.ACCT_STAT} is NULL. Is this a problem with CR coping with NULL or am I doing something stupid??

Matt

 

[Szyma]

Sorry,
I would never say CR is stupid.
CR handles .null. exactly and you should do the same.

if not isnull({customer.ACCT_STAT}) and {customer.ACCT_STAT} = 'S' then true else false
'Cross

if not isnull({customer.ACCT_STAT}) and {customer.ACCT_STAT} <> 'S' then true else false
'Tick

Good luck,
Ralph

 

[mattyboy2000]

Top man!!!!

I owe you a pint!

Matt

P.S. Crystal Reports ROCKS!