Web Elements error

[Former Member]

Hi All,

I am getting the following errors while creating the web elements report:

1. "A string can be at most 65534 characters long "

I am getting this error in Bulider function. In builder I am using 5 web elements. Out of which for startdate and enddate earlier I have used 'WESelectDate', now the users wanted calendar pop up so i replaced it with 'WECalendarPopUp'. After changing i am getting this error in builder of 65534.

I have seen the user guide and in that explanation given is that i need to minimize the data returned by the formula. How can I divide the Builder function. Please suggest.

2. 'An array's dimension must be between 1 and 1000'

Also, in my one WEMultiSelect I have 1562 values and it gives me the above error . As soon as I take top 999 records in the SQL and pass that to Web element it does not give me that error. But users want the whole list. Please suggest how can i get the whole list in WEMultiSelect of 1562 records.

Thanks in Advance!

Shalini

[JWiseman · Accepted solution]

hello Shal,

as for the first error, are you putting all of your controls in one formula? if so, use 1 separate formula for each control. then when you create your builder formula you would do something like this as an example

stringvar allelements:=

{@WESelectMultiCascade for countries} + {@WESelectMultiCascade for regions} +

{@WESelectMultiCascade for cities} + {@WESelectMultiCascade for customers} +

{@WESelectCascade for product types} + {@WESelectCascade for product names} +

{@WESubmitLinkSelect};

WEBuilder(allelements, 3)

as for the second error there is not much you can do about that except for splitting up your cascades into separate controls. for example if you are using customers do a separate control for A to F, G to L, M to Z as an example. you would have to have different control names and different prompt names in order to do this.

i hope that this helps,

jamie

[vitaly_izmaylov]

Hi Shalini,

I think both error you are getting are common for Crystal Reports Design. As the error is common there is a common solution/workaround. For example, if there is no way to limit the number of arrayu2019s members, then use a chain of arrays. The following formula demonstrates a simple scenario for chain array to workaround 1000 array members limitation.

Stringvar Array Sample1;

Stringvar Array Sample2;

Numbervar a:=a+1;

If a<1000 then

(Redim Preserve Sample1[a];

Sample1[a]:= Else ( Numbervar c:=c+1; Redim Preserve Sample2[c]; Sample2[c]:=;

)

...

I believe the similar idea could be used to split a string in two or more pieces.

Regards,

Vitaly