ComboBox Parameter Problem

[David]

I have a couple of parameterd on my report which have about 9500 string items in them.

I use a Telerik.Reporting.SqlDataSource to fill these up and i am displaying the report in the silvelright report viewer.

The problem is that when you drop down the combo box it take about 20-30 sec for it to happen and also once done it very sluggish scrolling up and down.

Does any one know how to fix this?

Thanks

[Peter]

Hello Jonathan,

You have quite extraordinary scenario and it's expected the ComboBox to slow down with that many items. However it seems difficult to search in a ComboBox that contains 9500 items to find the one the user is interested in. Thus instead of populating all of the values in a single ComboBox using Cascading Parameters to narrow down the search criteria is recommended.

All the best,
Peter
the Telerik team

[David]

Yeah i do understand this is a bit weird.

The problem is that since this built appon a database that i have no control over there isnt any other fields to filter appon. 

I have throw this many at a combo box at your normal silverlight controls and it works perfecly.

[Peter]

Hi Jonathan,

The report parameter area in the Silverlight report viewer is utilizing our Silverlight controls including the ComboBox.  However the report viewer's combobox is retrieving the items through a WCF service and this could cause a slow down depending on the environment. If you want to avoid report viewer's combobox our suggestion is to set the report parameter's visibility to false, add a ComboBox to the page and set the report parameter as elaborated in Programmatic Initialization of Report Parameter Values in Telerik Reporting Silverlight Viewer blog.

All the best,
Peter
the Telerik team