Error Mes: A string can be at most 254 characters long

[EngJoo]

Greetings,

i am write a formula like below:-

if isnull({employee_action.comment})
then "Action : Null"

else "Action : " + totext({employee_action.comment})

but when i run there report, i got the error message of "A String Can Be At Most 254 Characters Long"

i know there is a string concept caused the error but i dont know how to solve. Could any one of you point of my weakness or correct my formula please.

Thanks a lot a lot
EngJOo

 

[IdoMillet]

You are probably using a Crystal 8.5 version or earlier.

Those earlier versions of Crystal has a 254 limit on the size of strings. Consider limiting the size of the returned string using SQL.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com