I know this should be posted in Reporting servicess section no one replied there, So I am posting it here...!!!! Hi Friends, I have created a consolidated report which gives budget of a program on the basis of fiscal years(Right now report displays all years). Now I have a new requirement of adding a drop down box with available fiscal years. Once the year is selected the report should populate values for that peticular year only. I have figured out the way to use available values and report parameter to get the drop down.. But this drop down show duplicates as they come from the query that way. And how do I filter out the report based on the value selected? This report uses a Query to pull data from the database. Thanks a Bunch!!! Gopal Gopal

Hello Gopal, I think you do not have big chances to get your answer here, but I will try to help you before your post gets moved back to the SSRS Forum. A discovery phase now: What is your query that drives the drop-down; and What is the SSRS version you are using? As an attempt to help you ASAP, I am also shooting in the dark with providing the following links that I think can guide you to the solution with filtering the report (it is based on DataSets): http://www.mssqltips.com/tip.asp?tip=1897 and http://arcanecode.com/2010/07/12/adding-filter-parameters-to-sql-server-2008-reporting-services-reports/ Arthur My Blog