In SSRS u can have the <b>multi-value and hidden</b> Report Parameter, which get values FromQuery..
Create a dataset.. (SampleDS)
Query: Select distinct ProductName from Tbl_Product
Create a Report Parameter Product.
select the option Multi-value and Hidden
<b>In the available value option </b>
select FromQuery -> Choose SampleDS as Dataset and Value &l abel as ProductName
Create Resultant Dataset (FinalDS)
Query: Select * from Tbl_Product where ProductName in (@Product)..
hope this would be a way..:-)
Last Wiki Answer Submitted: March 25, 2009 7:11 am by Coooollll30 pts.