Page 1 of 1

How to convert this Formula Query

Posted: Tue Jul 01, 2014 6:00 am
by RajeshSaini
( if {CfgAddress.Address1} <> "" then
{CfgAddress.Address1} + ChrW (13) ) +
( if {CfgAddress.Address2} <> "" then
{CfgAddress.Address2} + ChrW (13) ) +
( if {CfgAddress.Address3} <> "" then
{CfgAddress.Address3} + ChrW (13) )

Re: How to convert this Formula Query

Posted: Tue Jul 01, 2014 11:00 am
by HighAley
Hello.

Here is a working expression:

Code: Select all

{Variable1+(!string.IsNullOrEmpty(Variable1) ? "\r" : "")+
 Variable2+(!string.IsNullOrEmpty(Variable2) ? "\r" : "")+
 Variable3}
Thank you.