Creating a SQL Server Reporting Services (SSRS) report that contains a Parameter Query

In many reporting situations users need to restrict the data visible in a report. For example filtering a master report with a drop-down list box so that only information for a specific month or product is shown. This video demonstrates how to do this using SQL Server Reporting Services (SSRS). This can be achieved by integrating a Parameter Query into a report. The process is simple and can be done using the following 4 steps. These are 1) Create a standard SSRS report (with a shared data source & dataset). 2) Add a "=@Name" clause into the underlying SQL statement in the report. 3) Create list of records to be used in a parameter list box (from a second dataset). 4)Link the Parameter list to the main report.

Category:

Education

Tags:

• SSRS
• SQL Server Reporting Services
• Parameter query