Dave,
I have done something similar and it seems to work great, without a lot of hassle. However, my situation may be different or I may not be understanding the problem as well! First to do the "dots", I simply place a line of dots completely across the page using a LABEL object. No calculating is needed for each record. Place the NAME object on top of the "Dot" Label (left side of page), make it auto size, left justified and NOT TRANSPARENT. Place the Phone object on top of the "Dot" Label (right side of page), make it auto size, right justified and NOT Transparent. As the report prints, the dots will be covered up as the various name and phone number objects change in length because they are not transparent. The two fields should easily justify right and left as they are separate fields. If no phone exists, the dots would run to the edge of the page. Not sure if this is what you want? If not you, there would be ways using the PROPERTY command to manipulate. Place your email object below the name and make it auto size and blank when zero. Make the detail band dynamic height. I believe this will take care of the email situation of sometimes existing and others not. The data band should expand or retract depending on if the email exists or not. Hope this helps, but again, I may not be understanding the question! -Bob From: rbase -l@ rbase .com [ mailto : rbase -l@ rbase .com] On Behalf Of David Blocker Sent: Wednesday, December 09, 2009 9:39 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Justifying both sides of a report field I?m creating a report which lists Name and phone number on one line, separated by a line of dots: Anderson, John . . . . . . . . . . . . . .(781)344-1222 Bones, Ellen . . . . . . . . . . . . . . . . (617)211-1222 The line should be JUSTIFIED ? i.e., left side and right sides line up. I? ve created an expression which fills the space between the name and number with dots, but R:Base won?t let me justify the field on the report, even if it's all combined into a column in a table. I? ve tried using DB Text and Rich Text, but the justify option on the top of the screen is grayed out. Without using the justify, the right sides don?t line up To complicate matters, the phone number might be null AND below the name and number, the client wants to print the email address, which also might be null. Blank lines should be suppressed: Anderson, John . . . . . . . . . . . . . .(781)344-1222 andersonj @comcast.net Bones, Ellen . . . . . . . . . . . . . . . . (617)211-1222 Carter, Andrew. . . . . . . . . . . . . . .(617)111-1111 acarter @ verizon .net Because of the potential blank lines, the best way to create the report is using rich text fields, with mailmerge items in each one, and each rich text inside a region. But? I can?t justify a rich text field. Ideas? David "David Blocker davidblocker @ davidblocker .com Office: 781-344-1920 Cell: 339-206-0261"
