Formula for names 4

[Crystalamateur]

Hi there,

I am new to Crystal and am struggling with a formula, the formula is as follows:

trimleft ({title} + ' ' + {initials} + ' ' + {surname})

The problem is if there is a title but no initials (or visa versa) then the report has no data showing.

Any help/suggestions would be appreciated.

Thanks
Peter

 

[Madawc]

do a formula field for intials, if isnull({initials}) then "" else {initials}. Use this in place of {initials}.
Nulls stop any crystal formula, unless tested for.

Madawc Williams (East Anglia, UK)

 

[TheBlondOne]

Hi there,


whileprintingrecords;

stringvar title;
stringvar initial;
stringvar sname;
stringvar disp;

if isnull({Title.Field}) or {Title.Field} = "" then title:= "" else title:= {Title.Field} + " ";

if isnull({Initial.Field}) or {Initial.Field} = "" then Initial:= "" else Initial:= {Initial.Field};

if isnull({Sname.Field}) or {Sname.Field} = "" then sname:= "" else sname:= {Sname.Field};

disp:= title + initial + sname

HTH

 

[Crystalamateur]

Hi there, many thanks for your reply to my query.

Your suggestion is great.

many thanks
Peter