on 10-23-2015 9:09 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.