Skip to Content

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

Second part of formula not working

Good morning

I have this formula below

IF IsNull({GfCnSpSpBio.GfCnSpSpBio_IDKEY}) and {GfCnBio.GfCnBio_Key_Indicator} = "I" then

{GfCnBio.GfCnBio_Title_1} + " " + {GfCnBio.GfCnBio_Last_Name}

else 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}

This part of the formula in crystal reports is not working, the salutation just shows up as blank. Does it have to do with a JOIN with teh tables.

else IF ({GfCnBio.GfCnBio_Key_Indicator} = "O" //Organizations

AND IsNull({GfCnRelCt_1.GfCnRelCt_1_Title_1}) OR isNull({GfCnRelCt_1.GfCnRelCt_1_Last_Name}) )THEN

"Supporter"

ELSE

{GfCnRelCt_1.GfCnRelCt_1_Title_1} + " " + {GfCnRelCt_1.GfCnRelCt_1_First_Name} + " " +

{GfCnRelCt_1.GfCnRelCt_1_Last_Name} + ",";

I am not sure what i am doing wrong here.

Thanks

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