String field issue

[dev1212]

I have a field {AllBoxDet} that has the details of all the boxes.
The value would be like, "Prod/Manf/Supp/Groc", "Guc/MXD/AAX/CDX

On the report i need to have each boxes in different columns like,

Branch Box1 Box2 Box3 Box4
1 Prod Manf Supp Groc
2 Guc MXD AAX CDX


I need an approach/formula to do this.

Thanks

 

[lbass]

Set up four formulas like this:

//{@1st element}:
stringvar array x := split({allboxdet},"/");
if ubound(x) >= 1 then
x[1]

//{@2nd element}:
stringvar array x := split({allboxdet},"/");
if ubound(x) >= 2 then
x[2]

//etc.

-LB

 

[dev1212]

This works fine lbass, thanks.. sorry for replying so late..
I have a question, is the use of arrays reduce the performance of reports..? In other words will this slow down the report..?

Thanks

 

[lbass]

I don't think it should have much effect the way you are using them.

-LB

 

[dev1212]

OK, thats what i wanted to know

Thanks