Crystal Report alternative to string

Is there something to use besides a string variable to hold text?  I get a string can not be longer then 256(or 254) error.  Just wondering if there is some other option to try.

Thanks!
sborchersAsked:
Who is Participating?
 
mlmccCommented:
CR8.5 has a limit of 254 characters in a string.  CR9 and later do not have the limitation.

To have strings longer than 254 in Crystal formulas you will need to have several variables and maintain the length yourself.

mlmcc
0
 
peter57rCommented:
Which version of CR are you using?  And which type of database is your data coming from?

What exactly are you doing that leads to the problem?

(There is not a general constraint on the length of a text item in current versions of CR, but there can be specific issues in particular cases and in prior versions.)
0
 
MIKESoftware Solutions ConsultantCommented:
Do you have access to SQL....if so, use SQL to create the reporting logic and VARIABLES needed......and then load or enter the SQL Logic into the Crystal Report at the DATASOURCE "ADD COMMAND" prompt.

MIkeV
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
sborchersAuthor Commented:
CR 8.5

I'm declaring a stringvar in a formula field.  When I try and save more then 254 characters to that string it errors out.  The CR is attached to a SQL server, but the formula is done exclusively in CR, it has nothing to do with SQL.
0
 
peter57rCommented:
So it is an older version that is the issue.(max 254 chars per string)
I don't know of any way round the constraint within CR.
The approach that was often used to handle memo fields was to break it into multiple shorter fields.
I guess that is what you will have to look at here.

All later versions do not have this constraint.
0
 
mlmccCommented:
If it is a memo field (> 255 characters) you will have to do the splittingin the database or in the SQL command used for the report.

If you are building it in Crystal you can use an array of strings and output them one at a time when you need to.

mlmcc
0
 
sborchersAuthor Commented:
Thanks for the help, looks like I need to look at CR XI.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.