Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need to combine 3 column

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.

a.png (31066 B)
replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question