Create drillthrough (RDLC) reports with parameters - ReportViewer

A drillthrough report is a report that a user opens by selecting a link within another report. Drillthrough reports commonly contain details about an item that is contained in an original summary report. This tutorial will walk you through the following lessons of creating a drillthrough report with parameters and a query, in local mode reporting.

Requirements

The Transact-SQL code samples in this article use the AdventureWorks2022 or AdventureWorksDW2022 sample database, which you can download from the Microsoft SQL Server Samples and Community Projects home page.

This walkthrough assumes that you are familiar with Transaction-SQL queries and ADO.NET DataSet and DataTable objects.

Use Visual Studio 2015, and the ASP.NET Web Application, to create an ASP.NET webpage with a ReportViewer control. The control is configured to view a report that you create. For this walkthrough, you create the application in Microsoft Visual C#.

Tasks

Lesson 1: Create a new web site
Lesson 2: Define a data connection and data table for parent report
Lesson 3: Design the parent report by using the Report Wizard
Lesson 4: Define a data connection and data table for child report
Lesson 5: Design the child report by using the Report Wizard
Lesson 6: Add a ReportViewer control to the application
Lesson 7: Add drillthrough action on parent report
Lesson 8: Create a data filter
Lesson 9: Build and run the application