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 5:34AM
    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