If then Else formula generating error in a subreport

[Suzette]

I wish to use the following formula in a subreport:

If {Opportunity_User_Field_Data.char_value} = "0" then "No" else
if {Opportunity_User_Field_Data.char_value} = "1" then "Yes"

However, when I try to save this formula in the subreport, I am getting the following error message:

a statement is expected here _then "No"

Any ideas? This formula seems to work fine in the main report.

 

[kenhamady]

Is this field available in the subreport?
What if you make the formula just the field, all by itself? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[080898pll]

If {Opportunity_User_Field_Data.char_value} = "0" then "No" else "Yes"