cancel
Showing results for 
Search instead for 
Did you mean: 

IsNull Function

Former Member
0 Kudos

I'm having wrong results using IsNull function in the selection formula of a report that I was requested to enhance, however, I've created a brand new report with the same criteria as a clone of the existing report, and the Isnull function is pulling the right results in the new report unlike in the existing one

I'm pretty sure that the two report are the same criteria, tables, fields, and everything, I've tried to look up any potential hidden conditions but got nothing

Any hint would be appreciated 

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

take the menu path:  File > Report Options

check the boxes for "Convert database NULL values to default" and "Convert other NULL values to default"

Former Member
0 Kudos

Thanks for your reply, but it didn't work in my scenario, I had to create the same report from the scratch and when I did so, it worked

Answers (0)