How set datafield position

dannyong1999dannyong1999
edited 6:24PM in FastReport 2.xx VCL
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...

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 6:24PM
    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"])]

    ;)

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 2.xx VCLComment As ...

© Vanilla Keystone Theme 2024