Suppress Page header when field is contain NULL value into crystal report

[nikunjmehta2290]

Dear all,

How can we suppress the one field which has datatype type VARCHAR.

I am trying below mentioned but it's gives me error like .... ) missing.

• ISNULL(EI_ACK_NO <> "")

The ) missing error comes.

SAP Business One HANA

Kind Regards,

Nikunj

[ido_millet · Accepted solution]

IsNull() accepts only one argument.
It looks like you simply need:

NOT IsNull(<your field>)

[yogananda]

nik2290

The correct syntax would be:

ISNULL(EI_ACK_NO, '') <> ''

[nikunjmehta2290]

The ) missing error comes while executing ISNULL(EI_ACK_NO, '') <> ''

[SonTran]

Hi,

Try this

ISNULL(EI_ACK_NO)

[nikunjmehta2290]

The ) missing error comes while executing ISNULL(EI_ACK_NO) this command into during Suppress.

[nikunjmehta2290]

It is also not the suppress header when I have passed this parameter into crystal report.

[nikunjmehta2290]

I have found the correct syntax is as mentioned below.

If ({GSTTAX_ARINVOICE.EI_ACK_NO}) = "" then

true;