Splitting Records 1

[ganjass]

CR10
Progress

Hi ALL,

I have 2 tables A and B for a report. In Table A there is Acc No for primary key. In table B There is an array field that holds various values. There is One array field for every AccNo. The table joins have to be left outers. I want to split the array field, which is easy enough, and display All the deatails associated with each AccNo eg

AccNo X Array Field
1234 Y [12344,2345,5678,890]

I want to display

1234 Y 12344
1234 Y 2345
1234 Y 5678
1234 Y 890

and for every field that has values in the array field.

thanks in advance

 

[IdoMillet]

What is the maximum number of entries you expect to have in the array for a given record?

- Ido





CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[ganjass]

roughly speaking no more than 5

cheers

 

[bdreed35]

Here is a formula that you can use in your detail section:

stringVar part1 := {table.accno} & chr(9) & {table.Y_value} & chr(9);
stringVar array list := split({table.array_field},",");
numberVar i;

for i := 1 to ubound(list) do
    (list[i] := part1 + list[i]);

join(list,chr(13));

Place in your detail section;
Right click the formula and choose format field.
Under the Common tab, select Can Grow property.

~Brian