Limitation of WeBuilder?

[Former Member]

My first report has some 8 dropdownlists for the user.Each dropdown list contains minimum 500 items to choose from.User has to select 1 or more values from each dropdown and send it to the second report.

My first report itself fails to compile highlighting the error in webuilder function "A string cane be atmost 65534 characters long".

Is it a limitation in WEbuilder?Or Am I doing something wrong?

[JWiseman · Accepted solution]

there are 2 limits that affect webelements usage and they are limits imposed by crystal reports.

1) 64k limit

there is a 64k limit in the output of any crystal formula. to minimize the occurance of this error, have each webelements control in a separate formula...e.g. one formula holds the dropdown menu. one formula holds the submit button. one formula holds the webuilder function.

2) 1000 values in arrays

nothing you can do about this one except try to ensure that there are no duplicates in the values that you are using in your controls.

jw