Crystal 10 numbers to text

[SA812]

I have a check box field i'm trying to get into a report. If the check box is checked it stores the #1 in the database if not it stores a 0. I have the following formula in "Format Formula"

If {_tsrPartnerCustom.Buderus} = 1 Then
Formula = "YES"
Else
Formula = "NO"
End If

It shows a yes in the report when there is a one, but it won't show NO when there is a zero..

Thanks for you help

Steve

 

[lbass]

That suggests you have some nulls or some other value. Try the following (using Crystal syntax):

if isnull({_tsrPartnerCustom.Buderus}) then
"Null" else
if {_tsrPartnerCustom.Buderus} = 1 Then
"YES" else
if {_tsrPartnerCustom.Buderus} = 0 then
"NO" else
"Other"

If you want nulls to appear as "No's", then use:

if isnull({_tsrPartnerCustom.Buderus}) or
{_tsrPartnerCustom.Buderus} = 0 then
"No" else
if {_tsrPartnerCustom.Buderus} = 1 Then
"YES" else
"Other"

-LB