Wednesday, March 7, 2012

How to use combo box for a parameter on reporting services?

I have created a reporting services report based on data elements from an Analysis Services cube. I have selected one of the data element as the parameter on the report. The default for the selection list of the parameter is a drop down box. My users didn't like to go through a long list of values in the drop down box to find a specific value. How can I convert the drop down box to a combo box so that my users can search for a specific value and therefore shorten the selection list.

Any help is greatly appreciated!!!

Mitch

Hello. Combo boxes are not a part of SSRS2000/2005.

Your best choice to simplify parameter search is to build cascading parameters.

Here is a link to an article of how to do this with SSAS-cubes

http://www.databasejournal.com/features/mssql/article.php/3653271

HTH

Thomas Ivarsson

No comments:

Post a Comment