Error Concatenating fields

[DonSaluga]

Hi,
I'm trying to concatenate 4 database fields (Data1 Data2...) into one formula field for a report. Each field is varchar 255. Data1 cannot be null, but the others can. I wrote this formula and it works until it hits a large record and I get the following error: A string can be at most 254 characters. I thought you can make a formula field much larger than that.

My formula is as follows:
Mid({b32_data_link_bk.data1}, 32, 219)+
if isnull({b32_data_link_bk.data2})
then "" else
trimright({b32_data_link_bk.data2}) +
if isnull({b32_data_link_bk.data3})
then "" else
trimright({b32_data_link_bk.data3}) +
if isnull({b32_data_link_bk.data4})
then "" else
trimright({b32_data_link_bk.data4})


I've used Auto grow in format but that doesn't help.
Any suggestions to make it work? Thanks.

Don Saluga
Database Manager
Vector Security

 

[dgillz]

This has always been an issue. Any formula that produces an output of more than 255 characters will return an error.

In CR v9 this is now 64,000 characters. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[synapsevampire]

Create 2 formulas and drop them into one text field, or just drop all 4 fields into a text field (you can drag and drop them in).

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com