Dawn, How do you set the region to shift with the parent and stretch ? As soon as I select Stretch, the shift with parent goes shaded (unselectable)
-- Frank -- Frank Taylor, Systems Network Administrator -- F.J. O'Hara Corp, Boston, MA -- [EMAIL PROTECTED] - 617-790-3093 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Dawn Oakes Sent: Wednesday, March 02, 2005 5:06 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Reports - Dynamic Height help Frank Try putting your variable memo (ifnull(snote,null,('Line Item Notes'&snote))) in a region, setting the memo to stretch and shift with parent. I tried that here on one of my reports and it worked - though it's not in the detail band - I'm not sure that will make a difference. Dawn -----Original Message----- From: Betaserver [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 02, 2005 4:24 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Reports - Dynamic Height help 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
