in RB7, create your label, Place a variable Memo field on it. Add / Edit the following variables:
Label : TestAddress 1 : TEXT : D : vCr = ((char(13))+(char(10))) 2 : TEXT : D : vAddress = (mainname + .vcr + (ifnull(address1,'', (address1 + .vcr))) + (ifnull(address2,'', (address2 + .vcr))) + city + ', ' + statename + (ifnull(ZipCode,'', ' ' + ZipCode))) associate the variable memo to vAddress. the above assumes MainName, City, and StateName CANNOT be null. ----- Original Message ----- From: "Bernard Lis" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Sunday, September 18, 2005 9:45 AM Subject: [RBG7-L] - Re: Supressing blank lines in labels > Doug, > > Locate ln3 and ln4 on your label > create the var csz = (city + ',' & state) > cusad2 is the 2nd address line in your customer table (which may be null) > > ln3 = (ifeq(cusad2,null,.csz,cusad2)) > ln4 = (ifeq(cusad2,null,' ',.csz)) > > Bernie Lis > ----- Original Message ----- > From: "Doug Hamilton" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Saturday, September 17, 2005 11:50 PM > Subject: [RBG7-L] - Supressing blank lines in labels > > >>I want to supress blank lines in labels - typically AddrLine2 is null and >>would like to move the City/State/Zip line up when that is the case. R:Base >>Help and FTE 11/03 have solutions using code and Mike B posted a stored >>procedure in Feb 04. But I thought since then I'd seen a posting about >>feature in Labels that would automatically close blank lines but can't recall >>it or find an example in ConComp. >> >> I'd apreciate any help. >> >> Tnx, Doug >> >> --- RBG7-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] >> In the message SUBJECT, put just one word: INTRO >> ================================================ >> TO UNSUBSCRIBE: Send a plain text email to [email protected] >> In the message SUBJECT, put just one word: UNSUBSCRIBE >> ================================================ >> 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. >> ================================================ >> >
