Borders Not Showing on Null Value Fields

[imterpsfan3]

The borders I select for a field do not display when there is a null value or empty value in a field. This happens despite the fact I have explicitly mapped the field to have borders. How can I correct this behavior? Thanks

 

[lbass]

That is the correct behavior for a null field. You might want to go to report options->and check "convert null values to default". If the default is 0, you can suppress if zero. This should allow you to use the borders.

-LB

 

[imterpsfan3]

For some reason that is grayed out or disabled. Do you know why that might be?

The other problem I'm having is with the object size and position. Despite what I might enter for X or width, Crystal likes to change the value after I hit ok. I have several fields I'm trying to line up and it's constantly changed heights, widths, x values on me.

 

[lbass]

I don't know. Are you using a stored procedure? Maybe try converting the field to a default in a formula as in:

if isnull({table.field}) then "" else {table.field} //if it is a string

Use zero if it is a number or date(0,0,0) for a date. For a number you can then format it to suppress if zero.

-LB

 

[imterpsfan3]

I'll give that a whirl. As for the sizing of objects, I think I have figured that out by using the guidelines. Maybe there is a better way. I'd rather just be able to manually set the coordinates.

 

[IanWaterman]

With regards object sizing and using borders I have found that its best to build your grid using text boxes. These are usually more stable. You can then just insert the field into the text box and it then does not matter if the field is null too.

YOu can also use Paragraph tab on the Text format and indent the field by the same amount each time.

Ian