Select Expert using ISNULL

[Former Member]

I am using Crystal Reports XI and I have a table that has customer names with "NULL" values. I am wanting to print all of those records in the table with the NULL value. Can someone help me with this issue.

Thanks Jim

[Former Member · Accepted solution]

HI Jim,

1) Goto > Report Options >Check the option "Convert Database Null Values to default".

And also check the option " Convert the other values to default".

2) Now goto > Record Selection Formula > Select "Default Values for null". and write the below formula

isnull(Database_Field)= true.

Hope this helps!

Regards,

Vinay