I think you can make this work if you prepend the label in the field itself and
use a variable
memo.
SET VAR rShowMemo = (IFNULL(snote,NULL,("Line Item Notes:" & snote)))
--- Betaserver <[EMAIL PROTECTED]> wrote:
> 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
>
>
=====
Albert Berry
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]
