NULL FIELDS

erkeperkep
edited May 2006 in FastReport 2.xx VCL
I HAVE A QUERY
COLUMN_A***************COLUMN_B
ASDASDA***************ASDADAS
ASDASDASD***********#######
########************ASDASDAS
ASDASDASD************#######
ASDASD***************#######
ASDASD***************#######
#####****************WERWER
#####****************RWERWERWER

# ARE NULL FIELDS

IF COLUMN_A OR COLUMN_B IS NULL .I DONT WANT TO PRINT THAT COLUMN
BUT I WANT TO DO THIS WITH WITH FAST REPORT.
HOW CAN I DO THAT WITH A MASTER_DETAIL_BAND.?
THANKS.

Comments

  • technisofttechnisoft
    edited 10:59AM
    Use:
    [IF([FieldIsNull('qryAudit."FIELDNAME"')], '', [qryAudit."FIELDNAME"])]

    You should be able to modify above for band.visible := blah, etc.

    Note the extra single quotes in the argument for FieldIsNull()

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