Display address in a letter format

[mitmat]

Hi,

Code below shows address in a row nicely but what I need to do is show it on separate rows and where value is Null to miss that line out?? Can it be done..

Appreciate any help






stringvar add1:=if (isnull({T_SH_ADDRESS.F_ADD_ADDR1}) OR {T_SH_ADDRESS.F_ADD_ADDR1}="&quot then "" else ({T_SH_ADDRESS.F_ADD_ADDR1}+", "
stringvar add2:=if (isnull({T_SH_ADDRESS.F_ADD_ADDR2}) OR {T_SH_ADDRESS.F_ADD_ADDR2}="&quot then "" else ({T_SH_ADDRESS.F_ADD_ADDR2}+", "
stringvar add3:=if (isnull({T_SH_ADDRESS.F_ADD_ADDR3}) OR {T_SH_ADDRESS.F_ADD_ADDR3}="&quot then "" else ({T_SH_ADDRESS.F_ADD_ADDR3}+", "
stringvar add4:=if (isnull({T_SH_ADDRESS.F_ADD_ADDR4}) OR {T_SH_ADDRESS.F_ADD_ADDR4}="&quot then "" else ({T_SH_ADDRESS.F_ADD_ADDR4}+", "
stringvar add5:=if (isnull({T_SH_ADDRESS.F_ADD_POSTCODE}) OR {T_SH_ADDRESS.F_ADD_POSTCODE}="&quot then "" else ({T_SH_ADDRESS.F_ADD_POSTCODE});

{T_SH_CUSTOMER.F_CUS_CUS_NAME} + ", " +ADD1 + ADD2 + ADD3 + ADD4 + ADD5;

 

[pgtek]

hi

try this
insert char(13) this will give you a carriage return
{T_SH_CUSTOMER.F_CUS_CUS_NAME} + char(13)+
ADD1+ char(13) +
ADD2 + char(13)+
ADD3 + char(13) +
ADD4 + char(13)+
ADD5

cheers

pgtek

 

[Naith]

I would vouch for pgtek's approach, with a small amendment:

[PS: Where pgtek says char(13), please note that he means Chr(13)]

{T_SH_CUSTOMER.F_CUS_CUS_NAME} + chr(13)+
(If Length(ADD1) > 0 Then ADD1 + chr(13) Else "&quot +
(If Length(ADD2) > 0 Then ADD2 + chr(13) Else "&quot +
(If Length(ADD3) > 0 Then ADD3 + chr(13) Else "&quot +
(If Length(ADD4) > 0 Then ADD4 + chr(13) Else "&quot +
(If Length(ADD5) > 0 Then ADD5 + chr(13) Else "&quot

Naith

 

[Ngolem]

this is the proper way to do it

//@address

whilePrintingRecords;

StringVar result := {T_SH_CUSTOMER.F_CUS_CUS_NAME};

if not isnull({T_SH_ADDRESS.F_ADD_ADDR1}) OR
length(trim({T_SH_ADDRESS.F_ADD_ADDR1})) <> 0 then
result := result + chr(13) + ({T_SH_ADDRESS.F_ADD_ADDR1}+&quot;,&quot;

if not isnull({T_SH_ADDRESS.F_ADD_ADDR2}) OR
length(trim({T_SH_ADDRESS.F_ADD_ADDR2})) <> 0 then
result := result + chr(13) + ({T_SH_ADDRESS.F_ADD_ADDR2}+&quot;,&quot;

if not isnull({T_SH_ADDRESS.F_ADD_ADDR4}) OR
length(trim({T_SH_ADDRESS.F_ADD_ADDR4})) <> 0 then
result := result + chr(13) + ({T_SH_ADDRESS.F_ADD_ADDR4}+&quot;,&quot;

if not isnull({T_SH_ADDRESS.F_ADD_POSTCODE}) OR
length(trim({T_SH_ADDRESS.F_ADD_POSTCODE})) <> 0 then
result := result + chr(13) + ({T_SH_ADDRESS.F_ADD_POSTCODE});

result;


It can be a little more complicated if you have something like this

City, State/Prov

since you don't necessarily add a carriage return, but you get the idea how to do it from the above

hope this helps

Jim Broadbent

 

[pgtek]

hi

OPSSSSSSSSSSSSSS
fat fingers lol lol
should be chr(13) not char(13)

pgtek

 

[lbass]

If this works with your total report, the simplest approach is to add each address field to its own separate detail section, and then go to format section and for each detail section, check &quot;suppress blank section.&quot;

-LB

 

[pgtek]

GEEEE!!!!!!!!

there's more than one way to skin a cat


pgtek