Archived discussions are read-only. Learn more about SAP Q&A

Select Expert using ISNULL

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


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!



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question