Blank field gets omitted 1

[CRilliterate]

I ran into problem. I have records that are :

CusID LName CoNAme

001 Fran Doob
002 Cole Sop Integra
003 Tom Frok Tom Frok

If CoName is empty I need to display LName, if CoName and if Lname is the same I need to display CoName

Output is :
CusId (always)
CoName (If exists, if not supress blank field)
LName (If exists but if = to CoName - suppress balnk because CoName already displayed at line2)

So I wrote:

{@IND_Do_Not_Show}is a formula that determines if record id Individual record. It works.

Then on top of it I wrote:

If {@IND_Do_Not_Show}<>{Tbl.CoNAme}then {@IND_Do_Not_Show} else ""

which says 'if Lname is the same I need to display CoName'

but it only works if LName and CoName are populated. It doesn't display anything when CoNAme is blank...Help???

CusID LName CoNAme

001 Fran Doob



________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server

 

[synapsevampire]

Try:

if isnull({table.CoName})
or
trim({table.coName}) = "" then
{table.Lname}
else
{table.CoName}

-k

 

[CRilliterate]

Thanks!

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server