I created a dataset within RS for the parameter query and

used your where clause. In report parameters, for Available values, selected from query and selected the dataset for...