SSRS + SQL Server parameters

I have a select statement...here is very simplified version.


Select
value1
value2
value3
value4
value5

from table

---these values are bits


I need to be able to have a dropdown in SSRS that uses the friendly value of each of these values in one dropdown.  so the dropdown might be

label1 of value1
label 2 of value 2
lable 3 of value3

etc.


Then my parameter passed would be one or more of these values in the select.

Since they are not pivoted and in one column Im not sure how to do this.

im guessing I need a cte of these values..  There are about 20 to be exact.
So that means 20 items in the dropdown..and 20 columns in the select

Please help.
LVL 11
Robb HillSenior .Net DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
try this step=-by-step example

Adding Drop-Down Parameter List in SSRS by  Michael Orther
http://sqlblog.net/2014/04/10/dropdownparam/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nishant joshiTechnology Development ConsultantCommented:
Hi Hill,

Where are you storing Lable & Values? Is it in SQL Database table?

If you are using the database table for value and label, You can add a dataset to SSRS report and go to create the parameter.

In Create the parameter, Go to available value and select created the dataset - Label, and Value as well.

Thanks,
0
Robb HillSenior .Net DeveloperAuthor Commented:
The issue here is that I need to have a paremter that will search against something I think needs to pivot...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.