Reporting Services :: Report Builder - How To Use Multiple-value Parameter In Dataset Control

I have used my parameter value in where clause of my dataset control SQL query. When I choose a single value in my multiple-value parameter then I get output as expected. Hovewer when I choose multuple values I get an arror:

Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
----------------------------
Query execution failed for dataset 'DATABASE'. (rsErrorExecutingCommand)
----------------------------
An error has occurred during report processing. (rsProcessingAborted)

I am convinced that it's a syntax problem. Is there a way I can change syntax of data output from query:

select @parameter

I need output to be like: value, value, value ... etc.

The dataset control query looks something like the following:

select
ID,
a,
b,
c,
d
from DATASET.dbo.Table
where ID in (select @parameter)

I have been searching through google for weeks to solve this and got this far and got stuck. Is it possible at all to achieve what I am looking for?