?
Solved

Error occurs when use Make array operator in formula

Posted on 2005-04-29
4
Medium Priority
?
307 Views
Last Modified: 2011-03-09
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
0
Comment
Question by:lana123
1 Comment
 
LVL 3

Accepted Solution

by:
DataSenser earned 1000 total points
ID: 13897663
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question