CR XI R2 - Display Array elements in group

[ReportDr00]

Hello,

I have a field with pipe delimited and i am splitting it into array to loop through them.

I need to display each element on one line on the group level.

The group i have is ID group. ID is of table patient and Address is also of table patient which pipe delimited. for each ID i wanted to display all Addresses of the patient on one line each.

For example

ID Address1
Address2
Address3
i cant figure out how to display each array elements on new line.
i appreciate your feedback

 

[lbass]

Try this instead of the array:

replace({table.field},"|",chr(13))

Then format the field to "can grow". This will give the appearance of several lines.

If you really need the results in separate detail sections for some reason, then use formulas like this, one for each address:

//{@address3}:
stringvar array x := split({table.field},"|");
if ubound(x) >= 3 then
x[3]

-LB