Error occurs when use Make array operator in formula

Hi,people.
I want all values in Field1 appear in my report and I'm using this formula for it:

Join(makearray({View1.Field1}), ", ")

I'm getting the error message:  A string array is required here.

I work with Crystal 10 and Oracle 9.2

I'll appreciate any answer

Thanks,

  Lana
lana123Asked:
Who is Participating?
 
DataSenserConnect With a Mentor Commented:
Are you declaring the array anywhere?  I think it would work if you created to formulas - one to populate the array and one to display the value.  Place the Populate Array formula in the detail section (suppress it if you don't want it displayed).

Populate_Array:

Global StringVar Array myArray;
Redim Preserve myArray [recordnumber];
myArray[recordnumber]:= {View1.Field1}

Display_Array:

WhilePrintingRecords;
Global StringVar Array myArray;
Join(myArray, ", ")

HTH,
DS
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.