I have a select statement...here is very simplified version.
---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
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