Yep... I tested it and it works. Here's the output:
http://www.byerley.net/DBlocker.bmp
----- Original Message -----
From: <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, December 10, 2009 8:52 AM
Subject: [RBASE-L] - RE: Justifying both sides of a report field
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"
