OK, Lets see if I can explain this..
I have an Invoice report where I have the detail band is set for dynamic
height. In the detail band I have 2 lines. The first line has all the basic
table DB fields and the second line I want to print notes if there are any. If
the note field is empty, then nothing will display in line 2 and the detail
band will shrink to the one line. I have been able to successfully do this by
placing a DB memo object for the snote column and selecting stretch option.
Now I wanted to add to the right of this a variable label that would be set to
'Line Item Notes >>' if the note field was not null. so I defined a variable
(ifnull(snote,null,'Line Item Notes')) and placed a variable memo onto to
report next to the DB memo. Now no matter if both are null, the space they are
in gets added to the height of the band. If I remove the variable memo, when
the snote field is blank, the band shrinks to one line like I want it.
Example of what the report should do
500 Widgets A $1.00 $500
300 Widgets B $2.00 $600
Line Item Notes >> This was a substitution
200 Widgets C $1.00 $200
10 Widgets D $.50 $5.00
I have also tried defining the Variable to be (ifnull(snote,null,('Line Item
Notes'&snote))) and placing just the variable memo on the second line, but I
get the same problem of space. So it appears that a variable memo, when null,
does not allow the dynamic height to shrink into the space that it occupies. I
have also tried variable text with the same problem. Is there a work around
or something I am not setting correctly so that I can get the results I am
looking for ?
Any help is appreciated.. Thanks
-- Frank
-- Frank Taylor, Systems Network Administrator
-- F.J. O'Hara Corp, Boston, MA
-- [EMAIL PROTECTED] - 617-790-3093
