String Variable

[korata]

How can I avoid an error of a string can be at most 254 character long.I have over a 1000 records that i am storing on the string variable for later use.should i change the varible form string to some other variable?

 

[synapsevampire]

Keep in mind that the version of your software is critical when requesting assistance.

The only way to beat this in CR 8.5 or below is to break up the variable into multiple 254 char chunks, or upgrade.

Not being able to see your formula doesn't help either.

You may even be able to break it up on the database itself prior to bringing it in to Crystal, again, since you don't share technical information, one can't advise.

Try posting more than a sentence, such as:

Crystal version
Database/connectivity used
Example data
Expected output

To break it, use LEN() checks against the variable and add to the next stringvar for greater than 254.

Then just drop them all into a text object to display them as one.

k