How set datafield position

Q:

I have made a report to print customer card but there is a problem,

I insert datafield in memo1 like this

[ZMySqlTable1."customer"]

[ZMySqlTable1."address"]

[ZMySqlTable1."address1"]

[ZMySqlTable1."city"]

after Printed....

//Datafield Customer Address 1 is available, cards look well

No. 110022

Alex Co.

Wisma 12345

Menalan street 2005

Jakarta

//Datafiled Customer Address 1 is not available and become blank, card look bad because of blank

No. 110023

Doni Co.

Montain Street 222

Bandung

how to hide the blank and make the position better.

example :

No. 110022

Alex Co.

Wisma 12345

Menalan street 2005

Jakarta

No. 110023

Doni Co.

Montain Street 222

Bandung

Thank youuuu...

A:

use complex expressions for the last 2 items in your memo by using

nested fr functions.

ie [IF(FIELDISNULL(fn), tv, fv)]

[IF(FIELDISNULL([ZMySqlTable1."address1"]), [ZMySqlTable1."city"]

, [ZMySqlTable1."address1"])]

[IF(FIELDISNULL([ZMySqlTable1."address1"]), '', [ZMySqlTable1."city"])]