Biegral Blog

一、建立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();
        }
    }
}