Export (0) Print
Expand All
3 out of 3 rated this helpful - Rate this topic

Create a Drillthrough (RDLC) Report with Parameters using ReportViewer (SSRS Tutorial)

SQL Server 2012

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 and a query, in local mode reporting.

For an example of the drillthrough report with a query-based filter, download the Drillthrough Report Sample from CodePlex. For a description of the sample, see Drillthrough Report Sample.

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.

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

Use Visual Studio 2010, or Visual Studio 2012, and the ASP.NET website template 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#.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.