Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need help with Crystal Report Formula

IF {GfCnSpSpBio.GfCnSpSpBio_Spouse_ID} > 0 and {GfCnBio.GfCnBio_Key_Indicator} = "I"

Then

{GfCnBio.GfCnBio_Title_1} + " & " + {GfCnSpSpBio.GfCnSpSpBio_Title_1} + {GfCnBio.GfCnBio_Last_Name}

else if {GfCnBio.GfCnBio_Key_Indicator} = "I" Then

{GfCnBio.GfCnBio_Title_1} + {GfCnBio.GfCnBio_Last_Name};

I am trying to code a salutation. If the person is a individual and does nto have a spouse just put in Mr.Jackson. if the person has a spouse put in

Mr & Mrs Jackson. When put this in my report. I get a record with an individual who is not married and it still shows up as

&Stirr.

I am not sure what i am doing wrong in this code.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question