Null Values

[Former Member]

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

[Former Member]

Someting very odd is happening...

If I were in your possition, my next step would be to create some debug formulas to figure out what's going on, and how to catch it.

Create a formula for each of the test conditions, and see how they evaluate. For all of these formulas, ensure that inthe formula editor you have 'default values for nulls' selected in the top right, rather than 'exceptions for nulls' or you won't get the results you need:

These are all seperate Formulas :

isnull(your field)

len(your field) < 1

len(your field)

<your field> = ""

then put each of those formulas into the group headder where the empty value is appearing and see what you get.