Larry Thanks for this VERY slick application of stored procedures!
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Saturday, August 21, 2004 12:48 PM Subject: [RBG7-L] - Re: Suppressing blank lines in mailing labels > > Thanks Razzak, I am familiar with the process of > > using IF statements to > > filter out the blank lines in reports and labels. > > What I meant to ask is.... > > Does version 7 label designer have a checkbox (like > > 6.5++) that will > > automatically suppress blank lines? > > John, what I generally end up doing is creating a > stored procedure: > > FormatAddress(pAddr1, pAddr2, pCity, pState, pZip) > RETURN NOTE > > or whatever arguments are appropriate for the project > I'm working on. I put my IF logic in there, and call > the procedure whenever I need an address. I use the > procedure in labels (naturally), but also forms and > reports where I want to show the mailing address. > > The advantage is that if I decide to change my address > formatting logic, I only do it in one place. > -- > Larry > >
