Showing posts with label selected. Show all posts
Showing posts with label selected. Show all posts

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

Sunday, February 19, 2012

How to use "not in" operation

Dear friends, I was not able to find any perfect toolbox item to use "not in" operation on my selected columns, also how can we use multiple join conditions in the merge join item? Thanks,

Jwalant Natvarlal Soneji wrote:

Dear friends, I was not able to find any perfect toolbox item to use "not in" operation on my selected columns,

Do you want to know if a certain row is not in some other table? This should help:

Checking if a row exists and if it does, has it changed?

(http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx)

Jwalant Natvarlal Soneji wrote:

also how can we use multiple join conditions in the merge join item? Thanks,

Just join multiple columns together. There is nothing limiting you to just one join condition.

-Jamie