How to concatenate more than 2 columns of a table in crystal report

[Former Member]

I need to concatenate more than 3 columns. All are strings columns.Able to concatenate 2 columns but not more than 3.

[Former Member]

Hello Swati,

I believe your third variable is of different Data Type So please follow below steps

{Table1.Field1}&" "&{Table1.Field2}&" "&ToText({Table1.Field3})

Hopefully this should solve your issue.

Regards

Niraj

[Former Member]

Thanks Niraj.

[Former Member]

Hello,

You Can create formula for this and write below command

{YourDataSource.Field1} & " " & {YourDataSource.Field2}

-Bhavesh Samant

[Former Member]

Thanks Bhavesh.It helped a lot.

[abhilash_kumar]

Hi Swati,

Do you receive any errors?

While in the formula editor, look for an option on the top that reads 'Exceptions for Nulls'; change that to 'Default Values for Nulls'.

-Abhilash

[Former Member]

Thanks Abhilash.I got the answer.