Kenny: Not sure I understand. Are you placing the results of this statement in a variable on the report and printing the variable in a Variable Memo field? If so, it seems the variable will be printed in one long string. How does the line feed work? I'm still confused.
Bill ________________________________ From: [email protected] <[email protected]> on behalf of [email protected] <[email protected]> Sent: Wednesday, April 6, 2016 5:52 PM To: RBASE-L Subject: [RBASE-L] - Re: Compress Print Lines on Report Try something like this: (IFEXISTS(coname2, coname2,(IFNULL(coname2,(IFEXISTS(coname3,coname3,' ')),' ')))) 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]<mailto:[email protected]>. To post to this group, send email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/948c5680-d9f9-4f88-9bb5-2eeaaf304b83%40googlegroups.com<https://groups.google.com/d/msgid/rbase-l/948c5680-d9f9-4f88-9bb5-2eeaaf304b83%40googlegroups.com?utm_medium=email&utm_source=footer>. For more options, visit https://groups.google.com/d/optout. -- 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/BN4PR14MB0593AB19367DF51690E08393CB900%40BN4PR14MB0593.namprd14.prod.outlook.com. For more options, visit https://groups.google.com/d/optout.
