Preview Content - log in or become a member

SSRS Parameter Basics

Video



Are you a member? Log In

or check membership plans

Plans:
Bronze
Silver
Gold
6 Courses
T-SQL (3), SSRS (1), SSIS(1), Excel (1)
Watch Video
75 Mini Courses
T-SQL (34), SSRS (7), SSIS(16), + more
300+ videos and 300+ Articles
38
(part of
Courses)
Progress Tracking
21 Interview Q&As pages
T-SQL (8), SSRS (3), SSIS(4), Other (6)
Forum
11 Webinar Recordings
T-SQL (1), SSRS (9), Career(1)
1 DIY Project (beta)
70-461 Tests
Watch Video
60 days, 100% Money Back Guarantee
Instant Activation
Duration:
(one off payment,
not a subscription)
Bronze
Silver
Gold
1 month $19
sign up
$24
sign up
$29
sign up
3 months 33% off
(2 months + 1 free)
$39
sign up
$50
sign up
$60
sign up
6 months 40% off
(3.6 months + 2.4 free)
$68
sign up
$86
sign up
$104
sign up
1 year 50% off
(6 months + 6 free)
$114
sign up
$144
sign up
$174
sign up
2 years 60% off
(9.6 months + 14.4 free)
$182
sign up
$230
sign up
$278
sign up
lifetime >60% off
(12.5 months + a lot for free)
$239
sign up
$302
sign up
$365
sign up



Article

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

 



Are you a member? Log In

or check membership plans

Plans:
Bronze
Silver
Gold
6 Courses
T-SQL (3), SSRS (1), SSIS(1), Excel (1)
Watch Video
75 Mini Courses
T-SQL (34), SSRS (7), SSIS(16), + more
300+ videos and 300+ Articles
38
(part of
Courses)
Progress Tracking
21 Interview Q&As pages
T-SQL (8), SSRS (3), SSIS(4), Other (6)
Forum
11 Webinar Recordings
T-SQL (1), SSRS (9), Career(1)
1 DIY Project (beta)
70-461 Tests
Watch Video
60 days, 100% Money Back Guarantee
Instant Activation
Duration:
(one off payment,
not a subscription)
Bronze
Silver
Gold
1 month $19
sign up
$24
sign up
$29
sign up
3 months 33% off
(2 months + 1 free)
$39
sign up
$50
sign up
$60
sign up
6 months 40% off
(3.6 months + 2.4 free)
$68
sign up
$86
sign up
$104
sign up
1 year 50% off
(6 months + 6 free)
$114
sign up
$144
sign up
$174
sign up
2 years 60% off
(9.6 months + 14.4 free)
$182
sign up
$230
sign up
$278
sign up
lifetime >60% off
(12.5 months + a lot for free)
$239
sign up
$302
sign up
$365
sign up


Did you find this page useful?
+2  |  -0
(2 Votes)
Live Chat (Log in)