Concatenate fields 3

[ekta22]

Hi,

I have 5 fields on my report out of which 3 are formula fields. How can I concatenate them into one field? Also how can I hide a field on a report?

Thanks,

Ekta

 

[lbass]

Sorry, the accumulation code got lost there. The formula should look like:

if isnull({pPC60403.FFA_REMOTE_BASE_IDENT}) or {pPC60403.FFA_REMOTE_BASE_IDENT} = "" then
n := n + space(3)
else
n := n + ({pPC60403.FFA_REMOTE_BASE_IDENT}) + space(3-length({pPC60403.FFA_REMOTE_BASE_IDENT}));

Note the "n +" after each ":=".

You should also begin the formula with the following so that the accumulation starts anew with each record:

stringvar n := "";

-LB

 

[ekta22]

Thanks guys. This works just fine. Thanks for all your help.