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.