How to hide textmemo if don't have value (empty)

Hi,

I put some textmemo (with value from database) in summary band, it's like this:

Sub total : 5.000
50% off : 2.500
Tax : 250
Form A : 250
Grand Total : 3.000

how to make like this in that summary band:

1. if value 50 % off is zero (0) then the summary band to be like this :

Sub total : 5.000
Tax : 250
Form A : 250
Grand Total : 5.500

2. if the value of tax is zero then the summary band to be like this :

Sub total : 5.000
50% off : 2.500
Form A : 250
Grand Total : 2.750

3. if form A are zero then the summary band to be like this :

Sub total : 5.000
50% off : 2.500
Tax : 250
Grand Total : 2.750

4. if the value of tax and form A are zero then the summary band to be like this :

Sub total : 5.000
50% off : 2.500
Grand Total : 2.500

Thank you
YUDI

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 6:27PM
    simple approach is to use 1 memo set band to stretch, memo to stretch and stretchmode to suit.
    use the memo.Lines.Add()method to populate the memo by
    writing code in the obp event of the band or the memo.
    ie
    if (expression) then memo1.lines.add('string');
    the string can contain text + expressions
    ie memo1.lines.add('50% off : [dataset."fieldname"]')

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.