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.

I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-...