Chapter 7
Creating a Drill-Through Report
Section 2
Adding a Parameter to a Query
The child report needs to display only the data associated with the item in the parent report. Report parameters can be used in the report query's WHERE clause. In SQL Server Reporting Services, a report parameter is a separate entity from a query parameter. - In the Dataset Properties window, add a query parameter and map it to the report parameter - Use the query parameter in the report query's WHERE clause - Preview the report to ensure one row is displaying in the child report