How to set Null parameter in crystal report?

[Former Member]

Hi,

I am using crystal report 11 along with visual studio 2010. I want to display all the record having column value null. The database query for better understanding is given below.

select * from itemMaster where oid=null;

Now I want get the records from above query in crystal reports. For that I have created crystal reports and created the parameter but I don't know how to specify oid=null condition.

Thanks in advance,

Mahesh

[Former Member · Accepted solution]

if IsNull({itemMaster.oid) then

  true

else

  false;