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