I am testing a field to determine if it is NULL or not. Below is an inline if statement
that does this. I also have a select statement that should create a group for NULL
value in this field and print "00 Null Value" in the group header. In both cases
the value for this condition is NOT printed when it evaluates to true. Does anyone
know way this happens? What is the work around?
IIF (isnull({BUDGET_COMMITMENTS.CODE_B}),"NULL" ,{BUDGET_COMMITMENTS.CODE_B} )
Select {BUDGET_COMMITMENTS.CODE_B} [1 to 13]
Case CStr(IsNULL({BUDGET_COMMITMENTS.CODE_B})):
"00 Null Value"
Case "100", "150" :
"10 Operations"
Case "200" :
"20 Direct Expenses"
Case "210" :
"21 Sales Promotion"
Case "220" :
"22 Sales Administration"
Case "230" :
"23 Marketing"
Case "240" :
"24 Business Development"
Case "300" :
"30 Administrative Expenses"
Case "350" :
"35 ERP Implementation Expenses"
Case "400" :
"40 Growth Expenses/Research & Development"
Case "500" :
"50 Quality"
Case "600" :
"60 Regulatory"
Default :
"Undefined Group";