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"])]
|
本类阅读TOP10