Skip to Content
0
Former Member
Oct 28, 2009 at 12:26 PM

Null Value in Crystal reports

122 Views

Dear all,

I have a SQL report created in SAP, which has "where " condition to only show records having null in a field.

i.e.

Select Field1, Field2, Field3

from T0

where Field1 is null

The query works fine in SAP and SQL server management studio.

I am trying to create the report in Crystal reporter, but the syntax of Null is not accepted.

I have tested that

Field1=""

Isnull(Field1)=True

Isempty(Field1)=True

Those records with no value in the field just didn't display ...

What is the right Syntax to use?

Many thanks

Yang