Frank: To suppress the box, select the region and the click on the down arrow right next to the "line color" icon (looks like a yellow brush) and select "no line" Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Betaserver Sent: Thursday, March 03, 2005 8:53 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Reports - Dynamic Height help David, Thanks for the detailed step by step.. I followed them exactly, but I was still not able to get it to take up the space of the region when the dbmemo and var memo fields were null. Also the region creates a box (lines visible) on the report, how do you surpress that ? -- 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
<<attachment: winmail.dat>>
