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?
 
Eugene ZCommented:
try this step=-by-step example

Adding Drop-Down Parameter List in SSRS by  Michael Orther
http://sqlblog.net/2014/04/10/dropdownparam/
0
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.