RTF fields are being truncated in crystal report

[Former Member]

Hello,

I have a problem in many reports, which a note text field is set in the file interpretation to RTF text and the field is being truncated.

is there a way to fix this?

regards,

[former_member205840]

Hi Tony,

Is Can Grow checked for this field ?

Also if you remove RTF text interpretation, do you see any special characters ? or is that not truncating results.

Best way to handle this is get text into database column and display in the report.

Thanks,

Sastry

[Former Member]

Hello Sastry,

yes the field is set to "Can Grow", and if I remove the test interpretation, I can see the special characters.

regards

Tony

[former_member205840]

Hi Tony,

Is the text size is more than 64kb ?  Crystal can't handle text size more than 65534 characters or 64kb.

This is a known issue.

You need to use left(), right() functions then split into multipul variables then disply it.

Ex:

Stringvar f1;

stringvar f2;

if len({textfield}) >65500 Then

f1:=left({textfield},65500);

f2:=right({textfield}, (len({textfield})-65500))

f1&f2;

Thanks,

Sastry

[Former Member]

Hello,

thank you for your reply,

I tried the formula but it's giving me an error on the last statement:

f1&f2;  (the remaining text does not appear to be par of the formula)

thank you

Tony

[former_member205840]

can you try this

Stringvar f1;

if len({@text}) >65500 Then

f1:=left({@text},65500) & right({@text}, (len({@text})-6500))

Else

f1:={@text}

[Former Member]

the formula works,

but the field is still truncated.

regards,

[former_member183750]

What version of CR are you using? Please be precise. In the designer, see Help | About and report that value.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter

[Former Member]

version 12.1.0.882

thanks

Tony

[former_member183750]

Please see if updating to the latest Service pack will help:

Downloads for SAP Crystal Reports and others

- Ludek