In this step by step SSRS tutorial I will show you how to create a drop down box parameter in SSRS based on dataset (sql query) and how to filter main dataset using your drop down box parameter. For the purpose of this SSRS tutorial I will use SQL Server reporting services 2008 R2 but this should work with SSRS 2008 and 2012. The steps should also be similar in SSRS 2005.
I have an existing report with a sparkline graph which shows me my website visits for the last 14 weeks. I would like to filter it by country using a drop down box parameter in SSRS.
First I need to create a new dataset Country that will contain two fields ID and Country, and will extract data from country table. I need ID for my main query so I can filter the data using Foreign Key (ID) and not actual country name which would require additional join. Country Field will be used to display the value in the drop down box (ID will be hidden and used behind the scenes).
I add new data set Country which will be used in Country Parameter
See screenshot below
To get full access to this page
Become a member or Sign in
Membership is just $3.99/month