<div>
The issue here is that I need to have a paremter that will search against something I think needs to pivot...
</div>

The issue here is that I need to have a paremter that will search against something I think needs to pivot...

<div>
<div class="content wysiwyg-content">
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. &nbsp;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.. &nbsp;There are about 20 to be exact. 
So that means 20 items in the dropdown..and 20 columns in the select 
 
Please help.
</div>
</div>

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.

SSRS + SQL Server parameters

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.