CR XI - Concatenate more than two fields problem

[ReportDr00]

Hello

I have four string field that i am trying to concatenate and it is not giving any value after doing so. No errors when saving it, but no result when displaying it.
My formula is

Field1 & Field2 & Field3 & Field4

I also tried using WhilePrintingRecords. If i remove Field3 and Field4 then it works just fine.

This is really getting me frustrated. I even converted all fields to ToText but still no result.

Any ideas would be greatly appreciated

 

[lbass]

You are probably encountering nulls. Set up a formula like this:

(
if isnull(field1) then
"" else
field1
) +
(
if isnull(field2) then
"" else
field2
) +
(
if isnull(field3) then
"" else
field3
) +
(
if isnull(field4) then
"" else
field4
)

An alternative approach would be to go to file->report options and check "convert nulls to default values".

-LB

 

[ReportDr00]

Thanks, That worked.

Regards

Armani