Hi,

I'm having trouble applying conditional formatting based on a blank number field and would really appreciate a bit of help..

We have a product which is classed as gambling, so my report needs to highlight sales where the customer's date of birth makes them under 18, or they haven't supplied a date of birth. I have a DOB field, which is in date format, and an Age formula which is calculated using this formula:

datediff('yyyy',{Command.DOB},Today)-(if datepart('y',Today)>datepart('y',{Command.DOB}) then 0 else 1)

I want the box in which the customer's age appears to be highlighted red when the age isn't 18 plus, and I can get this to work no problem for ages under 18 but I can't get it to work for an empty field.

I've tried:

{@Age}="" - but it complained about ="" that it had to be a number
isnull({@Age}) - doesn't apply the formatting to empty fields
cstr({@Age})="" - doesn't apply the formattiong
len(trim(cstr({@Age})))=0 - still doesn't apply the formatting

So then I tried reversing the formula, colouring the cell red and putting in the formatting to make the background white where {@Age}>=18, and this also clears the formatting from empty {@Age} values so they're not red.

I'm really out of ideas now, does anyone else have any suggestions? It's not a null field, just empty, I think "" would work for a string field but not for a number, and for some reason even converting it to a string doesn't work..

Jenny

hmm...I would have thought that in the formatting the cell, in the color tab, you could check the font color and use the background color.

also that:
if isnull({table.field}) then
crRed
else
crWhite

would have thought that would have worked....
been wrong before.