Does anyone know how to replace DB NULL values with text in a report? Right now if the field is NULL the label is just blank. Thank you in advance for your reply.
Toad for Data Analysts ver. 2.7.0.348
Does anyone know how to replace DB NULL values with text in a report? Right now if the field is NULL the label is just blank. Thank you in advance for your reply.
Toad for Data Analysts ver. 2.7.0.348
How about handling this in SQL? Most languages have a NVL function.
Debbie
Thank you for the reply. I ended up adding a calculated field with the following formula.
Iif(IsNullOrEmpty([FIELD1]),‘Null’,[FIELD1]).
Although, I would say the NVL way is much easier and a better solution.