SSRS Parameter Basics

Preview Content - log in or Join KEBI Academy
Want full access? log in or become a member
Access this page and all 75+ courses
$9.95/month
Checkout
learn more

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 access? log in or become a member
Access this page and all 75+ courses
$9.95/month
Checkout
learn more
Did you find this page useful? +2  |  -0
(2 Votes)