Skip to Content
author's profile photo Former Member
Former Member

Web Elements error

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Sep 08, 2009 at 05:14 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 26, 2009 at 03:11 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.