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?
Printable View
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?
You can create a formula field in Crystal to this. Give it try.
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'
Please rate it if it had helped you out.