cancel
Showing results for 
Search instead for 
Did you mean: 

Need to combine 3 column

Former Member
0 Kudos

Hi experts,

I am new to crystal report.I have four column report in which for certain condition I need to combine three columns.

I used following formula I get result but value print like double.

Please find attachment.

if {column3}="-" then

stringVar x := {column2};

stringVar y := {column3};

y:=''";

x:= x & ' ' & y

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Ajinkya,

It looks like the formula is overlapping with another field on the same section.

Could you remove the other field and have just the formula field on the section?

-Abhilash

Former Member
0 Kudos

Hi Abhilash,

Thanks for your reply i did what you suggested but other values gone.

I think need for loop so that we check each row if it matches condition then print concatenate value otherwise normal.

Please find attachment.

Ajinkya

abhilash_kumar
Active Contributor
0 Kudos

Hi Ajinkya,

1) Insert a Details b section

2) Place the formula field in Details b and other columns in Details a

3) Go to the Section Expert > highlight Details a > click the formula button beside Suppress and use this code:

{column3} = '-'

4) Go to the Section Expert > highlight Details b > click the formula button beside Suppress and use this code:

{column3} <> '-'


-Abhilash

Former Member
0 Kudos

Hi Abhilash,

Its working. you are the man.

Thank you very very much.

Answers (0)