How to convert this Formula Query

Сonversation on different topics
Post Reply
RajeshSaini
Posts: 2
Joined: Tue Jul 01, 2014 5:56 am

How to convert this Formula Query

Post 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) )
HighAley
Posts: 8431
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: How to convert this Formula Query

Post by HighAley »

Hello.

Here is a working expression:

Code: Select all

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