一、建立DataSet文件,加入相关联的两张表,注意里面有共同字段depid ,后期用于参数查找相应的报表
二、建立连张Report报表(Parent中加入dataTable绑定Dep 表 Child中加入DataTable绑定user表)
三、设置两个.rdlc文件的格式如下
RepParent.rdlc
RepChild.rdlc 中加入参数@depid
四、ReportView绑定RepParent
代码如下
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Microsoft.Reporting.WinForms;
namespace 钻取子报表
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
string sql = @"select depid,depname,parents from dep";
DataTable dt = DBUtil.getDataTable(sql);
ReportDataSource rds = new ReportDataSource("DataSet1", dt);
this.reportViewer1.LocalReport.DataSources.Clear(); //必须清空
this.reportViewer1.LocalReport.DataSources.Add(rds);
this.reportViewer1.LocalReport.Refresh();
this.reportViewer1.RefreshReport();
}
private void reportViewer1_Drillthrough(object sender, DrillthroughEventArgs e)
{
LocalReport lr = (LocalReport)e.Report; //此处为将触发的report转换成LocalReport
string depid = lr.GetParameters()[0].Values[0].ToString(); //此处方法的到的是一个数组,要得到depid
string sql = @"select userid,username,depid from users where depid='" + depid + "'";
DataTable dt = DBUtil.getDataTable(sql);
ReportDataSource rds = new ReportDataSource("DataSet1", dt);
lr.DataSources.Clear();
lr.DataSources.Add(rds);
lr.Refresh();
}
}
}