First create a temp table and place your Anderson, John . . . . . . . . . . . . . .(781)344-1222 in the rows.
Using a declare cursor command. In the dc I would use cval and use the sget the first (, then proceed with sput etc. to fill the vacant spaces with your . Replace the past value and .......... done. Using several combination will complete the job. Paul "my.02" 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" --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
