Expanding on that a little. In a label I define the first field (easy) ,and then using ifexists (or ifnull) you can build each variable to print, The first few aren't very hard, but the more you nest, it gets hard to keep it straight.
On Wednesday, April 6, 2016 at 2:59:02 PM UTC-5, bmilyard wrote: > > I’m printing a directory of names and addresses with cell phones and email > addresses. I’m printing in this format: > > Last Name, First Name > > Address, City, State, Zip > > Home Phone > > Primary Phone > > Secondary Cell > > Primary Email > > Secondary Email > > > > Some folks do not have all the phone or email addresses available so I > want to eliminate the blank lines. I found the ‘Creating Address Line > Compression’ description in the Help file but it does not work. I’ve > combined all phone and emails into one variable and placed the variable in > a Variable Memo control field then checked the ‘Suppress Empty Lines’ > option. > > > > Here’s my variable: > > > (HOMEPHONETEXT+(CHAR(013))+PRIMECELLTEXT+(CHAR(013))+SPOUSECELLTEXT+(CHAR(013))+PRIMEMAILTEXT+(CHAR(013))+SPOUSEEMAILTEXT+(CHAR(013))) > > > > I even tried for each phone and email but they still did not work. > > (HOMEPHONETEXT+(CHAR(013))) > > > > What am I missing? I still have not upgraded to version 10. > > -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/241dd4f1-29d8-4c09-bb4e-993701376e18%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
