I am trying to created a Calculated Column and having nothing but trouble. The column gets the record key and associateds the key with an appropriate group. I created a report with just the key and the calculated column (CODE_TYPE). When I run the report it bombs to the debugger with the following message:

ENG0010 $CODE_TYPE, line 1. Variable has not been assigned a value.

I have tried everything I can think of to find the problem. I thought it was the data but that wasn't the problem. I have to assume it's in the program:

key={KEY}

Begin Case

Case GE "0000" and key LE "0999"

ans=Diagnostic"

Case GE "1000" and key LE "1999"

ans=Preventive"

Case GE "2000" and key LE "2999"

ans=Restorative"

Case GE "3000" and key LE "3999"

ans=Endodontics"

Case GE "4000" and key LE "4999"

ans=Periodontics"

Case GE "5000" and key LE "5899"

ans=Prosthodontics-Removeable"

Case GE "5900" and key LE "5999"

ans=Maxillofacial Prosthetics"

Case GE "6000" and key LE "6199"

ans=Implant Services"

Case GE "6200" and key LE "6999"

ans=Prosthodontics-Fixed"

Case GE "7000" and key LE "7900"

ans=Oral and Maxillofacial Surgery"

Case GE "8000" and key LE "8999"

ans=Orthodontics"

Case GE "9000" and key LE "9999"

ans=Adjunctive General Services"

End Case

@ANS=ans

Any ideas what the problem could be?

Richard Richter

shouldnt your case statements be

Case key GE "0000" and key le "0999"

(i.e the 1st booleen is wrong)

also add

Case 1

ans=key

your key value must be outside of your range of 0000 to 9999

Rich

Richard -

in the lines: key={KEY}

Begin Case

Case GE "0000" and key LE "0999"

Case WHAT? is Greater than or equal to 0000? I think you need the word KEY before the GE in all your cases…

Mike

View this thread on the Works forum...