Auto filter of distinct values on columns in SQL Server Reporting Services?
Is there a way to have an auto filter of distinct values on columns in SQL Server Reporting Services?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 9, 2009 6:13 PM
UPDATED:
March 25, 2009 7:11 AM
Answer Wiki:
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..:-)
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
