Maximum length on a formula field?

[sasa888]

Hi, I am using crystal rpt and inserted a formula as a field. This field is a combination of 3 fields (City + ", " + State + " " + Zip Code). I keep getting a sql server error when I place this field inside the rpt, I am wondering if there is a limit on how large a character field can be, please help.

 

[FVTrainer]

If you are using CR 8.5 or earlier, then a formula cannot return more than 254 characters. In CR 9 that limit goes away (there is a limit, but I think its 64K worth of data, if I remember correctly).