Replace column text?

[VBjunkie]

I'm poplulating a crystal report from a sql stored procedure. One of the columns is displaying True or false. How would I format the column to dispay yes if true and no if false. Can I do IIF('column', true, 'yes') or something like that in crystal?

[Crooze]

You can create a formula field in Crystal to this. Give it try.

[mabbas110]

Create a formula and place is it where u display. Write the code liek this if for example ur field is field1

if {field1}='true' then 'yes' else 'no'

[mabbas110]

Please rate it if it had helped you out.