Skip to Content
0
Former Member
Sep 19, 2008 at 08:51 AM

Null Values

46 Views

Hi All,

I am currently having an issue with null values. I wanted to change the blank label for the null group to something like <NULL> and the values for the null group to the right ones rather than 0.

To change the label for the null group I used:

if IsNull({Main.txtCategory2}) then

"<NULL>"

else

{Main.txtCategory2}

This worked fine. So now I just needed to change the 0's to the correct count

I found the option 'Convert Database NULL Values to Default' this then changed all the 0's to the correct numbers, but at the same time changed the label "<NULL>" to blank again.

My question is. How do I have the correct values on count for null fields but also change the blank label. I seem to be able to only have one without the other.

I hope this all makes sense!

Thanks,

Scott