[水晶报表问题]循环多次取DataSet给rpt,在WEB页面中分多张报表显示是否可以?

maozai88 2012-05-01 03:11:42

如题. 想把多次取到的DataSet循环显示在WEB业页面上.目前按如下代码执行,就只能显示最后一个DataSet的表内容.

            SqlConnection myConnection = new SqlConnection(connectionString);

            myConnection.Open();

            



            for (int i = 0; i < aryto.Split('|').Length - 1; i++)

            {

                DataSet myDataSet = new DataSet();

                DataTable tt = new DataTable("tt");

                myDataSet.Tables.Add("tt");

                DataTable ToHead = new DataTable("ToHead");

                myDataSet.Tables.Add("ToHead");

                systransnum = aryto.Split('|')[i].ToString();



                string mySqlString = "select D.comsrtnm as ownsrtnm,A.DONUM, A.SYSTRANSNUM, B.consigneename as consigneesrtnm,B.address1,case B.transitlocal when '' then '直送' else (select localname from M_TRANSLOCAL E where E.localid = B.transitlocal) end as transitflg,B.descity,sum(C.qty * C.weightperunit) as toweight,sum(C.qty * C.volumeperunit) as tovolume,sum(C.qty) as toquan from T_TRANSORDER_D A inner join T_DELIVERYORDER_H B on A.DONUM COLLATE Chinese_PRC_CI_AS = B.orderkey COLLATE Chinese_PRC_CI_AS inner join SYS_COMPANY D on B.owncd = D.comcd left outer join T_DELIVERYORDER_D C on B.sysno = C.sysdonum where A.systransnum= '" + systransnum + "' and B.local='" + localid + "' group by A.DONUM, A.SYSTRANSNUM, B.consigneename,B.address1,B.descity, B.transitlocal, D.comsrtnm order by B.address1,B.descity,B.transitlocal";

                SqlDataAdapter myAdapter = new SqlDataAdapter(mySqlString, myConnection);

                myAdapter.Fill(myDataSet, "tt");



                string mySqlString2 = "select A.SYSTRANSNUM,A.TRANSNUM,CONVERT(VARCHAR(15),GETDATE(),23) LOADDATE,A.TRANSTP as TRANSTPNM,A.TRANSCOMNM,A.PLATENO,A.CD1,A.TEL1,A.NT,A.QUAN,A.WEIGHT,A.VOLUME,B.LENGTH from T_TRANSORDER_H A,M_VEHICLE B where A.vehicleno=B.vehicleno and  A.systransnum= '" + systransnum + "'";

                myAdapter = new SqlDataAdapter(mySqlString2, myConnection);

                myAdapter.Fill(myDataSet, "ToHead");



                CrystalReportSource1.ReportDocument.Load(Server.MapPath("CrystalReport1.rpt"));

                CrystalReportSource1.ReportDocument.Database.Tables["tt"].SetDataSource(myDataSet.Tables["tt"]);

                CrystalReportSource1.ReportDocument.Database.Tables["ToHead"].SetDataSource(myDataSet.Tables["ToHead"]);

                CrystalReportSource1.DataBind();



                CrystalReportViewer1.ReportSource = CrystalReportSource1;

                CrystalReportViewer1.ShowFirstPage();

                CrystalReportViewer1.ShowLastPage();

                CrystalReportViewer1.SeparatePages = true;

                CrystalReportViewer1.DataBind();



            }          

           

            myConnection.Close();