Custom Function Integer to Text String

Hi All,

I have a report I am generating in Crystal Reports from Sql. One of the table columns returns the values 1, 2, 3, and 4 where 1=Major, 2=Minor, 3=Unassigned, and 4=Error

How do I convert the returned values in the column to the text values associated with them? Can someone please show me what the string/function would look like?

Thanks!
Drud1981Asked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
You can also use if-then or case logic

If {YourField} = 1 then
    "Major"
Else If {YourField} = 1 then
    "Minor"
Else If {YourField} = 1 then
    "Unassigned"
Else
    "Error"

Open in new window


mlmcc
0
 
mlmccCommented:
Try

Local StringVar Array  DispString := ["Major", "Minor", "Unassigned", "Error"];
DispString[{YourFIeld}]

Open in new window


mlmcc
0
 
Drud1981Author Commented:
Thank you! The first answer gave me an error that highlighted the first comma and told me the ) was missing.
0
 
mlmccCommented:
I just tried it and I don't get an error.

Good thing I added the other one

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.