Getting error in formula, a constant expression is required here.
Please Help.


IIF ({UpLoad_Report_EOM;1.bornum} = 13797 or {UpLoad_Report_EOM;1.bornum} = 56700 or
    {UpLoad_Report_EOM;1.bornum} = 52635 or {UpLoad_Report_EOM;1.bornum} =52674 or
    {UpLoad_Report_EOM;1.bornum} = 57831 or {UpLoad_Report_EOM;1.bornum} = 54056 or
    {UpLoad_Report_EOM;1.bornum} = 52761 or {UpLoad_Report_EOM;1.bornum} = 44852 or
    {UpLoad_Report_EOM;1.bornum} = 21013 or {UpLoad_Report_EOM;1.bornum} = 21183 or
    {UpLoad_Report_EOM;1.bornum} = 52569 or {UpLoad_Report_EOM;1.bornum} = 52361 or
    {UpLoad_Report_EOM;1.bornum} = 20841 or {UpLoad_Report_EOM;1.bornum} = 13893 or  
    {UpLoad_Report_EOM;1.bornum} = 57684 or {UpLoad_Report_EOM;1.bornum} = 24208,
"YES","NO" )

Edited by vpriyanka2001 - 09 Oct 2009 at 8:37am

Yes Bornum is integer


Edited by vpriyanka2001 - 05 Oct 2009 at 8:00am

I'll second Jyothi - use an 'IN'

//Crystal Syntax
IF {UpLoad_Report_EOM;1.bornum} IN [13797,56700,etc] then 'Yes' Else 'No'

can you check datatype of this field in SP?
It should work fine if its a integer.


Jyothi