Memo field inserted into a Text Object doesnt word wrap

[glennjh66]

Hi All,

New to these forums. Great repository of info here. I know enough about crystal reports to be dangerous. I'm having an issue with a field from an SQL database which is a memo field.

I have inserted this into the report within a text object. So it appears like so inside the text box. {MemoField}

The issue I am having is that the text from the memo field is running over the edge of report and not displaying. So the report displays half words on the right hand side.

I have tried using different fonts and font sizes to no effect. I have also tried different settings when formatting the text box against the indentation settings for Right again to no effect.

Any ideas?

Thanks
Glenn

 

[lbass]

If you select the text box, so that the border shows up, do you see it running off the side of the report? If so, grab the right border and drag it so that it coincides with the right hand margin.

-LB

 

[briangriffin]

This works fine for me in CR2008; I'm testing with a varchar(MAX) field in SQL Server. However, that has an 8000 character limitation, I believe memo fields typically can go to 32k.

Are you saying that the wrap works correctly when you just place the memo field on the report, but doesn't wrap when you drop it in a text box?

Do you have 'Can Grow' checked in the Format Field dialog, with a value of 0 (no limit)?

If so, the first thing I would try is creating a formula:

left(memofield,1000)

Replace the text field with the formula - if it works, start incrementing the value by 1000 until it breaks. Do not put it inside a text box yet.

Sometimes you have to split memo fields into multiple formulas and then join them, but testing with a smaller value might isolate the problem a little better.

 

[glennjh66]

Hi,

Thanks for the information. The issue was formatting. The memo field is actually an RTF file import into a quoting program to allow additional quote notes to be added to the end of the quote.

Apart from the RFT file import you can also enter the data directly into the quoting application which appears as this memo field in the report. It seems that Word Doc formatting is maintained, which messes with the text object in crystal, if it is copied from Word and pasted directly into the application. Putting the data into the RFT file first (which removes much of the Word formatting) then importing into the application fixed the issue.

Thanks again for the feedback

Glenn

 

[glennjh66]

@briangriffin

I did attempt your suggestion, but it looks like the developers have code that wants this data inside a text object without any other parameters.

Thanks again.