combineing two names 1

[raghu55]

hello,

I have a fieldnames like
raghu(last name),
reddy(first name),
sunki(middle name)


i have to combine these fields to get (raghu reddy sunki)
as under my name in report.

 

[synapsevampire]

Try a formula containing:

whileprintingrecords;
stringvar Name:="";
if not(isnull({table.first}))
and
trim({table.first}) <> "" then
Name:=trim({table.first});
if not(isnull({table.middle}))
and
trim({table.middle}) <> "" then
Name:=Name&" "&trim({table.middle});
if not(isnull({table.last}))
and
trim({table.last}) <> "" then
Name:=Name&" "&trim({table.last});
name

-k

 

[raghu55]

hello
its working.But i want to display as shown below,




(LASTNAME) (FIRSTNAME) (MIDLLENAME)
raghu sunki reddy
radhika swamyka daday


thatmeans when refresh the report i have to see
exact formatting.how can i get

 

[lbass]

You could achieve this display by placing the fields directly on the report, without a formula. Or maybe there is some requirement you are not conveying?

-LB

 

[raghu55]

hello
thanks
its working.