Using Report Parameters in SQL Server Reporting Services


You can download the sample SSRS project. There are three reports attached to the project. The following are the details of those reports.

Report Name



Report with three parameters and data

Passing Parameters for Navigation Report.rdl

Passing parameters for hyperlink navigation

Passing Parameters for SubReport.rdl

Passing parameters for subreport


Parameters are very important feature in SSRS. Even though it is simple, there are many features that users do not use. This article has tried to cover most of the features about parameters of SSRS. If you need any further details, have questions or need further clarification, mail me at I look forward to hearing from you.

Pages: 1 2 3 4


2 Responses to “Using Report Parameters in SQL Server Reporting Services”

  1. I wa searching some good article for Parameters and tried to understand the use of it on MSDN ,but could not get it corrctly .After seeing your article It is easy for me to use the parameters .Thanks
    for the nice example

  2. Wonderful Article. Its been a few years since I’ve done any SSRS and needed a refresh class.

    Thank you

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |