SSRS - How to Parameterizing the SQL Query

1. We need to create separated dataset to handle the pre defined list in that dataset we will use simple select statement to define the list : 

SELECT    Number  FROM         Table 1 WHERE    ORDER BY Number

1. In the main dataset when we create the Query in the we will filter the column with parameter e.g.  we put in the Filter column for Number  “= @SerialNumber”  this allows the user to specify a serial number at the time the report is run
2. please click on below  link  to access the original artical

http://www.dynamicssol.com/ShowArticle.aspx?ID=60