Continueing with my earlier post on the RDLC and Drill Through reports, in this article we'll be checking the second method of passing parameters through filtering of report items.

The steps till completing the design of the reports are still going to remain the same. So please refer,

 http://blogs.msdn.com/selvar/archive/2010/03/03/dynamically-passing-parameter-to-drillthrough-report-in-rdlc-part-1.aspx

We'll be doing the code change only in the DrillThrough event handler code. Look at the below lines of code.

protected void ReportViewer1_Drillthrough(object sender, Microsoft.Reporting.WebForms.DrillthroughEventArgs e)

//Get the instance of the Target report, in our case the JumpFilterReport.rdlc.

LocalReport report = (LocalReport)e.Report;

//Create the instance for the EmpDeptHistoryDataSet which will

//hold the EmployeeDepartmentHistory table details.

EmpDeptHistoryDataSet ds = new EmpDeptHistoryDataSet();

//Making sure the dataset doesn't contain any constraints.

ds.EnforceConstraints = false;

//Create a SQL Connection to the AdventureWorks database using Windows Authentication.

using (SqlConnection sqlconn = new SqlConnection("Data Source=.;Initial Catalog=Adventureworks;Integrated Security=SSPI"))

//Building the SQL query.

SqlDataAdapter adap = new SqlDataAdapter("select EmployeeID, DepartmentID, ShiftID from HumanResources.EmployeeDepartmentHistory", sqlconn);

//Executing the QUERY and filling the dataset with the Resultset.

adap.Fill(ds,"EmployeeDepartmentHistory");

report.DataSources.Add(new ReportDataSource("EmpDeptHistoryDataSet_EmployeeDepartmentHistory", ds.EmployeeDepartmentHistory));