convert 1 to Y

Hi,
I have what is hopefully a simple question:
How do I convert a database value of 1 or 0 to a Y or N so it is displayed as such in the report?
I am using CRXI.
Thanks!
jbNot sure about XI but in 10 we go into options/fields then select boolean button, under boolean tab you can change the the text to Y/N.
GJ|||That would work, except that the database value is actually coming in as a 'number' type in crystal.|||Sorry, miss understood question. You could write a formula; This is assuming your vaules are either 1's or 0's.

If({table.field} = '0' Then 'N' Else 'Y'

GJ