conditional expression if name field is empty

[pawe84]

I have in my report a text field where the name and address is shown in this way:

$F{Customer Name 1} +"\n"+
$F{Customer Name  2} +"\n"+
$F{Address} +"\n"+"\n"+
$F{Country}

 

How I can remove a blank line when $F{Customer Name  2} is blank? Inside the database the field is not null it's just empty/blank.

I tried the following condition but it seems that it doesn't work.

In my report preview I still got the blank line if Customer Name 2 is blank.

 

$F{Customer Name 2} ==" "  ?
	 $F{Customer Name 1} +"\n"+
	 $F{Address} +"\n"+"\n"+
     $F{Country} 
	:
 	$F{Customer Name 1} +"\n"+
	$F{Customer Name  2} +"\n"+
	$F{Address} +"\n"+"\n"+
	$F{Country}

 

I already setup the text field "Remove Line When Blank" but this also doesn't work.

Even to check field is not null doesn't work

$F{Customer Name 2} == null  ?

Any ideas what I did wrong?

 

[shreekrishna.shankhwar]

Tried this way and use markup as styled 

$F{Customer Name 1}==null ? "" :  $F{Customer Name 1}+"\n"

[pawe84]

I solved it now.

At first I created two variables and then used the following condition:

!($F{Sell-to Customer Name 2} == null || $F{Sell-to Customer Name 2}.trim().isEmpty())?$V{addr_displ2} :$V{addr_displ1}