I am using CR 10 (Sp2) and I have come across a small problem that I am having trouble with, so I am hoping that someone may be able to help me.

 

The issue I am having is with a data field (varchar data type) with "Can Grow" set, that is starting the new line at the wrong place.  The data structure looks similar to this (what is returned is variable in length):

 

xxxxxxxxxxx xxxxxx-xxx.xxx.xxx

 

What is happening is that if the report returns a string that is too long for the field, where the break point is before the space, it breaks at the nearest non alpha character.  I.E.:

 

xxxxxxxxxxx xxxxxx-xxx.xxx.

xxx

 

What I would like it to do is break at the space character, I.E.:

 

 

My example above wasn't quite clear enough.  There could be multiple words with multiple spaces (not just the one as described).

 

In the end, what I ended up doing is as follows:

Local StringVar RevDescrip := StrReverse({table.field});

IF Length({table.field}) > 50
Then
StrReverse(Split (RevDescrip,' ',2)[1] & chr(10) & Split (RevDescrip,' ',2)[2] )
ELSE
{table.field};

 

I ended up using a chr(10) (line feed), as the way we output these didn't work with a carraige return.

 

Thanks!