Skip to Content
avatar image
Former Member

Crystal Report Formula

Hi I have this formula below and i keep getting

A BOOLEAN is required here.

please help

IF {GfCnBio.GfCnBio_Key_Indicator} = "I" THEN //Individual

{GfCnBio.GfCnBioTitle_1} + {GfCnBio.GfCnBio_Last_Name}_

Or {GfCnBio.GfCnBio_Title_1} + {GfCnBio.GfCnBio_Last_Name} + " & " + {GfCnSpSpBio.GfCnSpSpBio_Title_1} + {GfCnBio.GfCnBio_Last_Name}//{GfCnAdrSal.GfCnAdrSal_Salutation} + ","

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} + ",";

Edited by: Divyesh Khatri on Sep 4, 2008 8:24 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 05, 2008 at 10:02 AM

    Divyesh,

    Looks like this is related to Crystal reports - please post the same in the Crystal reports forum to get more relevant answers.

    Arun

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 17, 2008 at 05:39 PM

    Thank you

    Add comment
    10|10000 characters needed characters exceeded