When viewed and printed through the designer, they work just fine.  However when they are published to users through Crystal Server the fields which were clipped expand to the width size of the data contained and therefore overlap neighboring fields.

 

I have not set the fields to grow.  Should I make the fields formula fields and have them only display the first 10 characters? Or is there a better way. Thanks for any insight that you can offer =)

 

James ODonnell

I would concur with Lockwelle.

I recently had the same experience and was a bit bothered by it. I had not noticed it before bit cannot say it was not happening.

It seems that there should be a setting for this somewhere but I have yet to find it. If you do come across please post.

 

Right click the field, click format field, go to the paragraph tab and in the text interpretation pull down choose the RTF Text option.

 

For whatever reason your fields will now clip correctly.  If for some reason you have a field that isn't formated as a text field but is clipping incorrectly you can use:

 

ToText({table.field})

 

Credit to tsttntice on the asp.net forums for answering the question for someone else =)

 

James O