[RBASE-L] - Re: Conditional Blank Lines in reports; bold included

[Doug Hamilton]

Minor clarification: use the STANDARD Rich Text Object, not the DB Rich Text as I incorrectly stated. (That explains why I couldn't find Edit and MailMerge when I was testing this a few minutes ago.) D Doug Hamilton wrote: David - I did a similar directory some time ago and Sami Aaron gave me some 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 to Stretch. To make the region box invisible, click the icon for the Line color and choose None. Next, place a Rich Text Object inside the region, and make it just tall enough 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 Shift Relative To and select "Region1". To make the region box invisible, click the icon for the Line color and choose None. Make Region2 as tall as you need to place the other columns or variables on your report. Using Sami's guide above, I created a view with all the raw data and used 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 from one 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 Keep Together, 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 Keep Together on Region1 didn't work until I added a breakpoint on the last name and marked the breakpoint Keep Break Together. The listings now remain 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: I am creating a report for a client who wants to print a membership list for a musician’s union.  The criteria are:   1.      4 column report 2.      Page headers and footers (conditional values for odd/even) 3.      Alphabetical listing of members including up to 8 fields 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 codes indicating what the member plays 4.      Street2, either phone field and email could 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 in bold type if they exist I know a label would suppress the blank lines and create columns, but it would not permit the page headers and footers desired, so a report is necessary   In DOS versions, you could get the lines suppressed with a set of variables like this:   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)   I remember seeing a way to do the same in Windows, but cannot locate it in Razzak’s sample applications on line, in From the Edge articles or in the sample database.   And then, we’ve got those bold fields in the middle of the pile….. Any ideas?   David Blocker "David Blocker davidbloc...@davidblocker.com Office: 781-344-1920 Cell: 339-206-0261"