Friday, February 24, 2012

Allowing users to type in characters in a drop down list?

is this even possible in reporting services? I already deployed reports for our client using Reporting Services 2000, one of their complaints was that the dropdownlist of the reports contains a very long list of data, this list cannot be shorten since all data are required. Is there a way to let the users type in characters, not only one character to find the exact data they want. The data in the drop down list are needed because these data are parameters.

Are there any web based reporting tools which can provide this kind of requirement?

Reporting Services utilises standard HTML controls (apart from multi-value parameters). The only typing supported in a html drop-down is by first letter.

You could come up with a 2 dependant parameter approach, where users type into a textbox and the dropdown list filters based on the pattern typen into the textbox. This however would not happen as they type, they would need to leave focus from the textbox which would then postback and do the filtering server-side.

The only other option is to code your own parameter UI.

No comments:

Post a Comment