Create a Drillthrough (RDLC) Report with Parameters using ReportViewer (SSRS Tutorial)
Topic Status: Some information in this topic is pre-release and subject to change in future releases. Pre-release information describes new features or changes to existing features in Microsoft SQL Server 2014.
A drillthrough report is a report that a user opens by clicking 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, in local mode reporting.
Lesson 1: Create a new Web site
Lesson 2: Define a data connection and DataTable by adding a DataSet (for parent report)
Lesson 3: Design the parent report using the Report Wizard
Lesson 4: Define a data connection and DataTable by adding a DataSet (for child report)
Lesson 5: Design the child report using the Report Wizard
Lesson 6: Add a ReportViewer control to the application
Lesson 7: Add Drillthrough action on Parent report
Lesson 8: Implement the Query
Lesson 9: Build and run the application
To use this walkthrough, you must have access to the AdventureWorks2008 sample database. The query used in this walkthrough will also work with AdventureWorks2012 database. For more information about how to get the AdventureWorks2008 sample database, see Walkthrough: Installing the AdventureWorks Database for Microsoft Visual Studio 2010.
Use Visual Studio 2010, or Visual Studio 2012, and the ASP.NET Web Site template to create an ASP.NET Web page 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#.