Finally Figured it out. Using David's instructions worked when I changed my Variable definition from (ifnull(snote,null,'Line Item Notes')) to (ifnull(snote,' ','Line Item Notes')) It appears that the NUll value -0- was being evaluated as characters so it gave it the space. By changing the Variable to space (or I could have changed my definition of null to ' ' before going into the report) this made the region be empty and thus the dynamic height changed. With this and Javier's tip on removing the box, it does exactly what I wanted. Thanks to everyone for the help
-- 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 David M. Blocker Sent: Wednesday, March 02, 2005 5:09 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Reports - Dynamic Height help Frank I have a report that is NOT exactly the same, but might help. Like you, I have a comments field that might be null and might not be, and unlike you I was trying to place a horizontal line under the comments. I'll share waht I did and see if you can extrapolate to make it fit your situation. My report looks like this: COMMENTS (label) Comments (DBMEMO) ------------------------------- (line object) Here's the solution. 1. Placed a region around the COMMENTS label and dbmemo area. Region attributes are: Stretch, Transparent and visible checked 2. Comments label: transparent and visible 3. Comments DB memo: stretch, transparent, visible and autodisplay 4. Place a SECOND region around the line object. 5. Region 2 attributes are: Transparent, Visible, and stretch relative to Region1 6. Line attributes are: single, shift with parent and visible The difference of course is that you want your field NEXT to the stretching field and I wanted my below. I also ALWAYS wanted the line, you DON'T want the label if the note field is null Take from this what you can. In the meantime, I have it on reliable authority that the next beta of 7.5 may have a new feature that will make this a piece of cake.... David David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Betaserver" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, March 02, 2005 4:23 PM 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
