Bill Thanksfor the idea!I actually spent 20minutes this morning with Doug Hamilton who linked to my desktop. Together wefound the culprit in my report ? a dumb mistake:in the rich text field there was an extraline below the field in the mail merge.But Doug was great in helping me isolate where the problem was and howto fix it!
Italso helped to: 1.Make sure there was only ONE field in each Region /Rich text field combination 2.The rich text field fit INSIDE (not same height butslightly smaller) the region 3.Each region and each rich text field was transparent. DavidBlocker "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----Original Message----- From: Bill Eyring [mailto:[email protected]] Sent: Saturday, November 28, 2009 01:01 PM To: 'RBASE-L Mailing List' Subject: [RBASE-L] - Tearing My Hair Out Over Report Suppressing Blank Values David,I've done this before but only for 4 lines. Maybe you can take what I'vedone and expand it to your 8 lines of data.Example: Variable Located in Report: If vCitySt3is null:Brown, Roger vName Brown,Roger 3 Main St. vStreet 3 Main St. Apt. 3 vCitySt3 Boston, MA02112 Boston, MA 02112 vCitySt4Variable List:==============Vname text = (lastname+','&firstname)Vstreet text = street in tablenameVstreet2 text= street2 in tablenameVstreet3 text= ' 'VCitySt = (city+','&state&zipcode) in tablenamevCitySt3 text= (ifnull(vstreet2,vcityst,vstreet2))vCitySt4 text= (IFNULL(VSTREET2,VSTREET3,VCITYST))Hope this helps.Bill Eyring--- RBASE-L================================================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)================================================TO SEE MESSAGE POSTING GUIDELINES:Send a plain text email to [email protected] the message SUBJECT, put just one word: INTRO================================================TO UNSUBSCRIBE: Send a plain text email to [email protected] the message SUBJECT, put just one word: UNSUBSCRIBE================================================TO SEARCH ARCHIVES:Send a plain text email to [email protected] 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.================================================
