Thanks to Doug, Larry and Karen (and indirectly Sami) for pointing mein the right direction. I'll let you all know how it turns out. Themany Rich Text objects and regions sounds like the way to go, givenwhat the client wants.
David "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----Original Message----- From: Doug Hamilton [mailto:[email protected]] Sent: Tuesday, November 24, 2009 10:18 AM To: 'RBASE-L Mailing List' Subject: [RBASE-L] - Re: Conditional Blank Lines in reports; bold included Also, within each Rich Text Object, you can have multiple mailmergefields, each with its own properties: <FamilyName>, <Adults> would print: Hamilton, Doug D Doug Hamilton wrote: David - I did a similar directory some time ago and Sami Aaron gave mesome great tips that got me started. Here's her email from a few years ago: In the report itself, first place a region in the detail section. Right-click on the region and in the region properties, set it toStretch. To make the region box invisible, click the icon for the Line color andchoose None.Next, place a Rich Text Object inside the region, and make it just tallenough for one row of data. Right-click on the Rich Text Object and choose Stretch. Right-click again on the Rich Text Object and choose MailMerge. Right-click again and choose Edit. In the Edit Window, Choose the Edit Menu and then Insert Fields -choose Person1. Press ENTER to go to the next line in the text box and Edit / Insert Fields and choose Person2. Click the "x" to close the Rich Text window.Next, place a second region just below the first region. Right-click on the region and in the region properties, click ShiftRelative To and select "Region1". To make the region box invisible, click the icon for the Line color andchoose None. Make Region2 as tall as you need to place the other columns or variableson your report. Using Sami's guide above, I created a view with all the raw data andused DB objects in the report. Locate the regions in order down the report and let RBase number them -it makes it a lot easier when identifying the "Shift Relative To..." Here's my followup to Sami with some more info: I just created a member directory report. Each listing may have fromone to five lines (lastname/firstname, children's names, addr1, addr2 & CSZ). It works great! Each line is a rich text object in its own region that stretches and shifts relative to the preceding region - no more creating a variable and concatenating the fields and making them wrap etc...All the regions are located in a parent region that is checked KeepTogether, Stretch, Transparent and Visible. Report pseudo code is:|Region1 (parent region - KeepTogether)-|| region2 rich text object1 || region3 rto2 || region4 rto3 || region5 rto4 || region6 rto5 ||---------------------------------------|The intent is to have a listing not straddle two pages, but the KeepTogether on Region1 didn't work until I added a breakpoint on the lastname and marked the breakpoint Keep Break Together. The listings nowremain on one page and they are sorted by last name, which is what I wanted. The Rich Text Object will allow you to modify font as you desire -Bold, size, color...imagine the possibilities! Hope this helps David. Thanks again Sami. Doug David Blocker wrote: Iam creating a report for a client who wants to print a membership listfor amusician’s union.The criteria are: 1.4 column report 2.Page headers and footers (conditionalvalues forodd/even) 3.Alphabetical listing of membersincludingup to 8fields of data, 1 per line: Lastname, First Street Street2 City,State,Zip HomePhone WorkPhone Email (IF a field permitting publishing of email = Y) A string of up to 10 instrument codesindicating what the member plays 4.Street2, either phone field and emailcould all be NULL 5.Suppress blank lines if a field is NULL 6.Name always exists and should be bold 7.Phone numbers and email should be inboldtype if they exist Iknow a label would suppress the blank lines and create columns, but itwouldnot permit the page headers and footers desired, so a report isnecessary InDOS versions, you could get the lines suppressed with a set ofvariables likethis: 1: TEXT: D : rName = (LName+","&FN) 2:TEXT: D : rCSC =(City+","&State&Zp) 3:TEXT: D : rEmail =(IFEQ(EmailPub,"Y",Email,NULL)) 4:TEXT: D : rInstList =(INSTR1&INSTR2&INSTR3&INSTR4&INSTR5&INSTR6&INSTR7&INSTR8&INSTR9&INSTR10) 5:TEXT: D : rLine1 =(LJS(.rName,50)+Street) 6 :TEXT: D : rLine2 =(LJS(.rLine1,100)+Inco) 7:TEXT: D : rLine3 =(LJS(.rLine2,150)+rCSC) 8:TEXT: D : rLine4 =(LJS(.rLine4,200)+HomePh) 9:TEXT: D : rLine5 =(LJS(.rline4,250)+Workph) 10:TEXT: D : rLine6 = (LJS(.rLine5,300)+rEmail) 11:TEXT: D : rLine7 =(LJS(.rline6,350)+.rInstList) Iremember seeing a way to do the same in Windows, but cannot locate itin Razzak’ssample applications on line, in From the Edge articles or in the sampledatabase.And then, we’ve got thosebold fields in the middle of the pile….. Any ideas? DavidBlocker "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261"
