水晶报表的简单使用

      刚开始用C#的时候就用到了水晶报表(当时用的是vs2003自带的),碰到了很多问题,后来慢慢的解决了,事隔2年,现在回想起来发现全忘记了,哎,所以决定自己再做个简单的小例子,复习下,顺便把操作过程简单的记录下,免得以后又忘记了
      因为vs2003自带的crystalreport没有打印功能(WEB版的),所以现在用crystalreport10.0 DEVE版,安装顺序是先安装vs2003,再安装crystalreport10.0.
      1、首先在项目中添加一个crystalreport，这样就会产生两个文件：CrystalReport1.rpt和CrystalReport1Service.asmx
      2、在项目中添加两个数据集DataSet1.xsd和DataSet2.xsd，分别作为主报表和子报表的数据源
      3、接下来就是报表设计了，其他细节就不说了，只是说下怎么把主报表和子报表关联起来，右键子报表选择“Change Subreport Links....",下面怎么做应该一看就知道了。
      4、下面就是配置报表了：
            一、构造数据源以及报表文件RPT文件位置

private void Button1_Click(object sender, System.EventArgs e)
        {
            获得报表数据源#region 获得报表数据源
            DataTable dtSource = null;            //主报表数据源
            DataTable dtprintInfor = null;        //子报表数据源
            DataSet ds = new DataSet();            //报表数据源
            string childReport = "true";        //是否有子报表
            string reportPath = "";                //RPT文件路径

            dtSource = new DataTable();
            dtSource.Columns.Add("MODELID");
            dtSource.Columns.Add("TEXT");
            dtSource.Columns.Add("SORTID");
            dtSource.Columns.Add("INUSE");
            dtSource.Columns.Add("REMARKS");
            dtSource.Columns.Add("SYSTEMID");
            DataRow dr = null;
            for ( int i=0;i<10;i++)
            {
                dr = dtSource.NewRow();
                dr["MODELID"] = "MODELID" + i;
                dr["TEXT"] = "TEXT" + i;
                dr["SORTID"] = "SORTID" + i;
                dr["INUSE"] = "INUSE" + i;
                dr["REMARKS"] = "REMARKS" + i;
                dr["SYSTEMID"] = "1";
                dtSource.Rows.Add(dr);
            }
            for ( int i=0;i<10;i++)
            {
                dr = dtSource.NewRow();
                dr["MODELID"] = "MODELID" + i;
                dr["TEXT"] = "TEXT" + i;
                dr["SORTID"] = "SORTID" + i;
                dr["INUSE"] = "INUSE" + i;
                dr["REMARKS"] = "REMARKS" + i;
                dr["SYSTEMID"] = "2";
                dtSource.Rows.Add(dr);
            }

            dtprintInfor = new DataTable();
            dtprintInfor.Columns.Add("SYSTEMID");
            dtprintInfor.Columns.Add("TEXT");
            dtprintInfor.Columns.Add("SORTID");
            dtprintInfor.Columns.Add("INUSE");
            dtprintInfor.Columns.Add("REMARKS");
            
            dr = dtprintInfor.NewRow();
            dr["TEXT"] = "TEXT";
            dr["SORTID"] = "SORTID";
            dr["INUSE"] = "INUSE";
            dr["REMARKS"] = "REMARKS";
            dr["SYSTEMID"] = "1";
            dtprintInfor.Rows.Add(dr);
            
            dr = dtprintInfor.NewRow();
            dr["TEXT"] = "TEXT1";
            dr["SORTID"] = "SORTID1";
            dr["INUSE"] = "INUSE1";
            dr["REMARKS"] = "REMARKS1";
            dr["SYSTEMID"] = "2";
            dtprintInfor.Rows.Add(dr);
            
            DataTable dt = new DataTable("MODEL_INFO");
            DataTable dtD = new DataTable("MODEL_DETAIL");
            dt = dtSource.Copy();
            dtD = dtprintInfor.Copy();
            ds.Tables.Add(dt);
            ds.Tables.Add(dtD);
            ds.AcceptChanges();
            reportPath = "CrystalReport1.rpt";

            Session["rptsrc"] = dt;
            Session["rptName"] = reportPath;
            //Session["childReport"] = childReport;
            Session["childReport"] = "true";
            Page.Response.Redirect("reportForm.aspx");
            #endregion
        }

            二、数据源绑定：

try
            {
                string reportMethod = "ReportViewer";                                //定义导出方式
                if (System.Configuration.ConfigurationSettings.AppSettings["reportMethod"]!=null )
                {
                    if(System.Configuration.ConfigurationSettings.AppSettings["reportMethod"].ToString()!="")
                    {
                        reportMethod = System.Configuration.ConfigurationSettings.AppSettings["reportMethod"].ToString();    //通过配置来获取导出方式
                    }
                }
                if(reportMethod != "ReportViewer" &&  reportMethod != "pdf" )
                    reportMethod = "ReportViewer";
                string filtPath = this.MapPath("../") + Session["rptName"].ToString();    //获取RPT文件的绝对路径
                oRpt.Load( this.MapPath("../") + (string)Session["rptName"]);                //加载RPT文件
                oRpt.SetDataSource(Session["rptsrc"]);                                    //加载数据源

                子报表#region 子报表
                string haveChildReport = "false";                                        //定义是否有子报表
                if ( Session["childReport"] != null && Session["childReport"].ToString()!= "")
                {
                    haveChildReport = Session["childReport"].ToString();
                }
                if ( haveChildReport == "true")
                {
                    CrystalDecisions.CrystalReports.Engine.Sections crSections = oRpt.ReportDefinition.Sections;    //获得子报表集
                    foreach(Section crSection in crSections)
                    {
                        ReportObjects crReportObjects = crSection.ReportObjects;
                        //loop through all the report objects to find all the subreports
                        foreach(ReportObject crReportObject in crReportObjects)
                        {
                            if (crReportObject.Kind == ReportObjectKind.SubreportObject)
                            {
                                //you will need to typecast the reportobject to a subreport 
                                //object once you find it
                                SubreportObject crSubreportObject = (SubreportObject)crReportObject;

                                //open the subreport object
                                ReportDocument crSubReportDoc = crSubreportObject.OpenSubreport(crSubreportObject.SubreportName);
                                //Once the correct subreport has been located pass it the 
                                //appropriate dataset
                                //crSubReportDoc.Database.Tables[0].SetDataSource(ds);
                                crSubReportDoc.SetDataSource(Session["rptsrc"]);
                            }
                        }
                    }
                }
                #endregion
                if(reportMethod == "ReportViewer" )
                {
                    CrystalReportViewer1.ReportSource = oRpt;
                }
                else if (reportMethod == "pdf")
                {
                    导出到PDF文件#region 导出到PDF文件
                    DateTime now= DateTime.Now;

                    //定义文件名
                    string fileName= now.Year.ToString() + now.Month.ToString() + now.Day.ToString() + now.Hour.ToString() + now.Minute.ToString() + now.Second.ToString() ;
                    System.Random rnd = new Random();
                    fileName += rnd.Next(100000);
                    fileName = this.MapPath(".") + @"\report\SIM\" + fileName + ".pdf";

                    if (!System.IO.File.Exists(fileName))
                    {
                        System.IO.FileStream fs = System.IO.File.Create(fileName);
                        fs.Close();
                    }
                    
                    DiskFileDestinationOptions objFile=new DiskFileDestinationOptions(); 
                    oRpt.ExportOptions.ExportDestinationType=ExportDestinationType.DiskFile; 
                    oRpt.ExportOptions.ExportFormatType=ExportFormatType.PortableDocFormat;
                    
                    objFile.DiskFileName=fileName;                            //指定导出文件
                    //oRpt.ExportOptions.ExportDestinationOptions = objFile;
                    oRpt.ExportOptions.DestinationOptions = objFile;
                    
                    oRpt.Export(); 


                    Response.ClearContent();
                    Response.ClearHeaders();

                    Response.ContentType = "application/pdf";
                    Response.WriteFile(fileName);
                    Response.Flush();
                    Response.Close();
                    
                    System.IO.File.Delete(fileName);
                    Response.End();

                    #endregion
                }
            }
            catch(Exception ex)
            {
                throw ex;
            } 

这样就可以了，可能有点乱，不过没心思整理了