sborchers
asked on
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!
Thanks!
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
MIkeV
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
Thanks for the help, looks like I need to look at CR XI.
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.)