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]

Just to throw my $.02 in, I never turn on the report option to change null values to default. it vastly complecates any other forumla you might want to write in the report, and can cause performance issues under certian circumstances.

I use 'default values for null' in the formula workshop for the select expert, or explicitly in formulas where I need that functionality.

Also, just a picky point, but asing "isnull() = true" is redundant. if the field is null, isnull evaluates to true, and then you're asking if true = true. If it isn't null you're asking if false=true which is clearly false. In cases such as these isnull() alone will suffice.

[Former Member]

I ran across this while searching a solution for a simular problem i was having. When i used a select Formula

isnull({table.feild}) it was clearing my entire report of informaiton. I had used this on previous versions of Oracle and Crystal. I just recently was moved to Crystal 11 and I believe Oracle 11. The solution it turned out was the "=true" thus "isnull({table.feild}) = true"...... i don't know what is different but this was the only way I could get the desired effect of selecting the null records. Go figure

Edited by: Kschuett on Feb 10, 2012 12:18 AM