In this tutorial I will show you how to create a simple parameter in SSRS report and use it to filter your data. In this tutorial I will SSRS 2008 R2 and it should be the same in SSRS 2008 and SSRS 2012.
Below you can see the table which shows twelve months average temperature in Majorca. Let's say there is a requirement to show only one month at a time using parameter.
In my design view you can see I already have a dataset and a report table. In order to add a paramater to the report I open "Report Data" pane, right click parameters folder and click add parameter.
See Screenshot below
Want full article?
With KEBI Academy Membership you get:
Join KEBI Academy
- 350+ BI Lessons
- Progress Tracking
- Live Webinars
- and more!