Returning values stored in arrays 1

[mgpeters]

Using CR/CE 10, Oracle via direct connect.

I have a subreport that has 3 stringvar arrays populated with data. They will have varying ranges (# of elements). Each one is SHARED and has a cooresponding SHARED NUMBERVAR containing the number of elements in the array.

Example data:

Array1 Array2 Array3
A AAA WEF
BES Q K
ewr e12k
sews
fse

I want to report out the data from these 3 arrays so that it looks something like this...

A
BES
ewr
sews
fse
AAA
Q
WEF
K
e12k

Any suggestions on how to do this?

Thanks,
M

 

[synapsevampire]

Sicne you are simply dumping them with a carriage return between each element of the arrays, try:

whileprintingrecords;
shared stringvar array1;
shared stringvar array2;
shared stringvar array3;
join(array1,chr(13)) & join(array2,chr(13)) & join(array3,chr(13))

btw, you don't need to store the number in a sahred vairable, you can always use ubound(array1) to determine the same thing.

-k

 

[mgpeters]

Thx - that worked!