DearMike and Bob Youknow, it’s the SIMPLE things in 7.6 I keep overlooking.I’m looking for complex expressions, and thiswas so simple!Worked like a charm andthe client loved the reports (delivered last Thursday).Bob, it turned out the client decided to showblank phones and emails as “not published” so I didn’t have to worry about thenulls. I’ll save your idea for the time he changes his mind.
Manythanks. DavidBlocker "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Thursday, December 10, 2009 09:05 AM To: 'RBASE-L Mailing List' Subject: [RBASE-L] - RE: Justifying both sides of a report field p { margin: 0; }I left out an important part! For the email, you need to assign an ID to the email object and on the before generate eep, test if data exists. If not then, turn the object as NOT VISIBLE by using the property command. This will cause the band to expand or shrink as desired. -Bob ----- Original Message ----- From: "ttc inc" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, December 10, 2009 7:52:07 AM GMT -06:00 US/Canada Central Subject: [RBASE-L] - RE: Justifying both sides of a report field p { margin: 0; }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: [email protected] [mailto:[email protected]] 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 [email protected] Bones, Ellen . . . . . . . . . . . . . . . . (617)211-1222 Carter, Andrew. . . . . . . . . . . . . . .(617)111-1111 [email protected] 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 [email protected] Office: 781-344-1920 Cell: 339-206-0261"
