Skip to Content
0
Former Member
Mar 17, 2009 at 04:55 PM

Borders for fields with null values

650 Views

I'm using CR XI and having problems formatting a field so that it will have a border around the field even though the field is empty.

If I just format the field and add a single line border around it, it looks correct when there's a value in the field but when the field is empty, it doesn't display any border.

I tried adding a formula that's similar to:

If customer <> "" then

crSingleLine

else

crSingleLine

(I know, written poorly and overkill)

But that didn't help.

Although, I suppose I could make a slew of formula fields which would contain a space instead of a null value for all fields and display the formula fields instead, that seems like a lot of work. I'm hoping there's something stupid I'm missing.

Any thoughts?

And if possible, is there a default at the Report level as to how to treat null values?