Using dropdown parameters in SSRS report

Question

I can see the text box for my data set that having the

"select col1 from table name " as query. I want to populate dropdown instead of text box. I have created the parameter for it . what to do?

Answer 1

In short

1. Right click the parameter

2. Select "Available Values" section

3. Click the "Get values from a query" option

4. Select the appropriate dataset and fields

Answer 2

My solution:

1. Right click the parameter under the "Report Data" and select "Parameter Properties"

2. Select "Available Values" section

3. Click the "Get values from a query" option

4a. Select the appropriate query to use

4b. Select the Value that you want the main query to use to generate the data

4c. Select the Label that will show in the drop down box that the User sees and selects a option from