If else syntax correct SAP Business One HANA Crystal report

[nikunjmehta2290]

Dear all,

I have set this query to suppress the header if it's false the condition into Crystal report. But the below query is not working.

If ({GSTTAX_ARINVOICE.EI_ACK_NO}) = "" then
    true
else if ({GSTTAX_ARINVOICE.EI_ACK_NO}) = "" and ({GSTTAX_ARINVOICE.BP GSTN}) = !"" then
    false
else 
    false;

How to pass twice times true condition in above syntax Crystal report.

Here , it's gives error like A number ,curreny amount, boolean, date time or string is expected here.

SAP Business One HANA

Kind Regards,

Nikunj

[DellSC]

<soapbox>Your expression needs to evaluate to true or false - this doesn't mean you need to specify true or false in an if statement</soapbox> This should work for you because it will return true if {GSTTAX_ARINVOICE.EI_ACK_NO} is empty, but only if {GSTTAX_ARINVOICE.BP GSTN} is not equal to "!". In all other cases it will return false.

{GSTTAX_ARINVOICE.EI_ACK_NO} = "" and {GSTTAX_ARINVOICE.BP GSTN} <> "!" 

-Dell

[ido_millet]

and ({GSTTAX_ARINVOICE.BP GSTN}) = !""

==>
and ({GSTTAX_ARINVOICE.BP GSTN}) = "!"