Change 1=Yes,0=No for each record based on a field

[crazycat503]

I have a crystal report with a field that stores 1 or 0. During run time, i want to replace 1=yes,0=no. I cant access the field text box (in the details section named instore1) at all like we do in vb (textbox1.text="Yes")...how can i achieve that?

[jggtz]

Insert a new formula field
Name it like you want
Place it in the detail section
Use the next code if your field is string type (if it isn't then remove delimiters from "1")

If {Tablex.Fieldx} = "1" Then "Yes" Else "No"

Only change Tablex.Fieldx for the real names