In SSRS you can have the multi-value and hidden Report Parameter, which get values FromQuery..
Create a dataset.. (SampleDS)
Select distinct ProductName from Tbl_Product
Create a Report Parameter Product.
select the option Multi-value and Hidden
In the available value option
select FromQuery ->
Choose SampleDS as Dataset and Value &l abel as ProductName
Create Resultant Dataset (FinalDS)
Select * from Tbl_Product where ProductName in (@Product)
hope this would be a way..:-)