Can't get rid of text wrap

[janemaritz]

I am using a text field in my report that includes two data fields. I do not want the text to wrap; i.e. if the data fields have more characters than I've allowed for the text field, then the end characters should be cut off.

I have unchecked 'Can Grow' for the text field. However, I am still having a problem with one record; the data is wrapping and priting in the same spot as the data for the next record.

When I preview the report, it is not doing this; it only is visible when I print.

Has anyone else run into this? If so, how did you resolve it?

Thanks!

Jane

 

[Ngolem]

the solution is to determine the number of Characters that yo want Max and using a formula limit the result to that many characters

@LimitStringSize

Left(Table.longstring,(number of chars you want));



Jim Broadbent

 

[Madawc]

Ngolem's solution will work fine, but it limits you to a fixed number of characters, rather than the number than could be shown in the report space. Since most of us use fonts that are not proportionate, this varies.

In Crystal 8.5, an alternative solution is to select [Format Field], [Customise] and check [Allow Field Clipping]. This ought to cause the field data to be truncated.

Madawc Williams
East Anglia
Great Britain

 

[Ngolem]

by trial and error you can find the optimum length

the danger of setting field clipping is that it applies to ALL FIELDS not just the one you want...so beware if adapt this approach

Jim Broadbent

 

[Madawc]

In Crystal 8.5, Field Clipping can be set specifically for individual numeric fields. But not at all for alpha, I was wrong about that.

What's a bit puzzling is that the printed report is not matching the preview. Normally it does.

Madawc Williams
East Anglia
Great Britain

 

[janemaritz]

Thanks.

What I ended up doing was checking 'Can Grow' for the text box and then entering a Maximum Number of Lines as '1'. For some reason, that worked, though unchecking the 'Can Grow' didn't work.

 

[Ngolem]

Interesting...didn't know you can do that

Jim Broadbent