We help IT Professionals succeed at work.

Crystal Reports - Problem with Max String Length in formula

miketakasaki
miketakasaki asked
on
1,399 Views
Last Modified: 2012-08-14
I'm using 8.5.
The report is using a formula to format a string that exceeds 254 characters and therefore truncates. How do I get the formula to return more than 254 and get it display on the report?
Thanks
Comment
Watch Question

Commented:
You're limited in string length by the version of Crystal.  What you can do is to have more than one formula - the first returns 254 characters, the next returns 254 more, etc.  Position as many as necessary to get the full results.

Commented:
or you could upgrade. i think from cr 9 on you can use 64,000 chars.
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Yes CR9 can handle longer strings.  The formula frodoman is using must be either in the database or an external dll.  Crystal 8.5 cannot use a string that is longer than 254 in a formula.

mlmcc
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.