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