Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Arrays in Crystal 10 - exceeding 1000 elements

Posted on 2011-03-04
Medium Priority
525 Views
Hi All:

I have a form with an Array that stores a Site Ledgend for an Invoice - some of the customers have more than 1000 sites - is there any workaround for this?  The formula is producing an error and the form will not print.

Thank you!

________________________
First Formula:

whileprintingrecords;

Global Stringvar Array Site;
ReDim Site[1];

""
_______________________________________________
Second Formula:  (this one is causing the error when the customer has more than 1000 sites)

whileprintingrecords;

Global StringVar Array Site;
Global StringVar strResult;
Global NumberVar arrayUpBound;

if {@xSiteDetails} <> "" then
(
arrayUpBound := UBound(Site) + 1;
ReDim Preserve Site[arrayUpBound];
Site [arrayUpBound] := {@xSiteDetails};
strResult := "1" ;
)

else

(
strResult := "0" ;
);
strResult

_____________________

xSiteDetail formula:

left({CL_23CRWInvoiceDetail.ForeignSiteCode} + space(10),10) & "  "&
left({CL_23CRWInvoiceDetail.ForeignSiteDescription} + space(25),25) & "   "&
left({CL_23CRWInvoiceDetail.ForeignSiteAddress1} + space(30),30) & "     "&
left({CL_23CRWInvoiceDetail.ForeignSiteCity} + space(20),20) & "     " &
{CL_23CRWInvoiceDetail.ForeignSiteState}

__________________________

Third Formula:  (This one is used to display the Sites legend)

whileprintingrecords;

Global StringVar Array Site;
Join(Site,chr(10))

_____________________________
0
Question by:eleale
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions

LVL 77

Accepted Solution

peter57r earned 668 total points
ID: 35038878
I'm afraid there is no good news.
There is no setting that you can adjust.

If you can possibly split the data so that you could use a subform for part of the report , that could be the one less difficult option.
Otherwise you into a major development job  to see if you can use multiple arrays to hold the values and process them sensibly.
0

LVL 101

Assisted Solution

mlmcc earned 668 total points
ID: 35039203
I agree.  I looked but I don't see anything in the registry that controls that.  There are other limits that can be overidden or changed through the registry

mlmcc
0

LVL 26

Assisted Solution

Kurt Reinhardt earned 664 total points
ID: 35039384
Since the result of the array is to simply display the legend, could you possibly use a subreport to pull in the list of values to be displayed?

~Kurt
0

Author Closing Comment

ID: 35039672
Thank you!
0

Author Comment

ID: 35039681
I can't use a sub-report for 2 reasons on this form - one is performance and the other is custom programming to email the form.

Thank you for your help!  Back to the Programmers.

E.
0

## Featured Post

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
###### Suggested Courses
Course of the Month8 days, 9 hours left to enroll

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

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