Getting null fields in crystal reports

Question

I have a customer name with first name, last name, middle name. I want to concatenate these fields. When I concatenate these fields I am getting some of the fields as null cause as it contains at least one null value field. I have tried with this formula.

{FIRST_NAME}&","&{MIDDLE_NAME}&","&{LAST_NAME}

Ex: I have first name, last name but middle name is null then I am getting entire field as null. Please help me how to resolve this.

Answer 1

You'll probably want to wrap each field with a formula to adjust for nulls:

// {@FIRST_NAME}
If Isnull({table.FIRST_NAME}) Then "" Else {table.FIRST_NAME}

Then create a formula to concatenate them

// {@FULL_NAME}
{@FIRST_NAME} + "," + {@MIDDLE_NAME} + "," + {@LAST_NAME}