[RDLC]MasterDetail報表(Subreport)(Web Form)

2015-01-15

4040
0

摘要:[RDLC]MasterDetail報表, subreport

首先在.aspx拉出scriptmanager + report viewer, 設定好報表路徑以及子報表事件


<asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <rsweb:ReportViewer ID="ReportViewer1" runat="server" Height="100%" Width="100%"
        AsyncRendering="False" SizeToReportContent="True">
        <LocalReport ReportPath="Reports/rptOrders.rdlc" OnSubreportProcessing="ReportViewer1_SubreportProcessing"></LocalReport>
    </rsweb:ReportViewer>

然後在.aspx.cs加入主報表以及子報表的SQL, 子報表的資料一定要自己想辦法在

SQL中過濾，不然保證效能超慢慢慢......


protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                ReportViewer1.ProcessingMode = ProcessingMode.Local;
                //ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/rptOrders.rdlc");

                string strSQL = "";
                strSQL = strSQL + "select top 3 * from Orders " + "\n";
                
                SqlCommand cmd = new SqlCommand();
                cmd.CommandText = strSQL;
                DataTable dt = Common.GetDataTable(cmd);


                ReportDataSource datasource = new ReportDataSource("dsOrders", dt);
                ReportViewer1.LocalReport.DataSources.Clear();
                ReportViewer1.LocalReport.DataSources.Add(datasource);
                ReportViewer1.LocalReport.Refresh();
            }
        }

        protected void ReportViewer1_SubreportProcessing(object sender, SubreportProcessingEventArgs e)
        {
            //DataSet dataSet = new DataSet();
            //dataSet.ReadXml(MapPath("Employee.xml"));
            //由於開網頁很慢
            //想改善performance的話，要自己去過濾合理範圍內的OrderID
            //ex:如果main report查詢條件是某天OrderDate,那麼subReport的sql要自己去過濾出適當的
            //(OrderDetails inner join Orders).OrderDate = "ooxx"
            string strSQL = "";
            strSQL = strSQL + "SELECT  [Order Details].* " + "\n";
            strSQL = strSQL + "FROM [Order Details] " + "\n";
            //strSQL = strSQL + "where OrderID = @OId" + "\n";
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = strSQL;
            DataTable dt = Common.GetDataTable(cmd);

            ReportDataSource dataSource = new ReportDataSource("dsOrderDetails", dt);
            e.DataSources.Add(dataSource);
        }

子報表的部分：除了拉好簡單幾個欄位以外，