Select Case 1

[YANKRAY]

Crystal Reports 10.0.

When using Select Case logic, how do you indicate a null value Case?

Thanks,
Ray

 

[lbass]

One way is to use the null check first, as in:

if isnull({table.field}) then "Null" else
select {table.field}
case "123" : "Old"
case "456" : "New"
default : "Other"

-LB