concatenate with null values

[Willie78]

Hi everybody

I have 3 simple if statement that say
if a field = 1 then concatenate a few fields.

This is displayed in the details section. The purpose of this is to display different address in different columns.

My problem is that ifa field that is in the concatenate
formula isnull then the formula will display nothing.

I have got around this by declaring each address field like so

stringVar busname :=if not isnull({Sample.BusinessName}) then {Sample_Data_txt.Person_BusinessName}&chr(13) else "";

from these result i have then done

busname&add1

etc

This works but seems long winded. Is there a better way i could do this?

Cheers

Wills

 

[fsreport]

hi
i think you shoul place is null first
stringVar busname :=if isnull({Sample.BusinessName}) then
"" else
{Sample_Data_txt.Person_BusinessName}&chr(13);



fsreport

 

[mgpeters]

That's what I'd do too. Check your fields first with the ISNULL function