[转载]asp.net实现通用水晶报表 - 虾米瓦格 - 博客园

/// <summary>
        /// 获取配置文件的配置信息配置报表
        /// </summary>
        public void GetData()
        {

            string Path = "";
            string reportPath = "";
            string tablename = "";//表名称
            string OrderKey = "";//排序的字段
            string Order = "";//按什么排序
            string title = "";//报表标题
            bool Separate = true;//显示页是分页还是连接
            string serch = "";//筛选条件
            Path = Server.MapPath("Config/ReportConfig.xml");
            reportPath = Server.MapPath("CrystalReport3.rpt");

            #region 获取配置文件的信息
            XmlDocument document = new XmlDocument();
            document.Load(Path);
            XmlNodeList NodeList = document.GetElementsByTagName("TableName");
            if (NodeList != null && NodeList.Count > 0)
            {
                tablename = NodeList[0].InnerText;
                title = NodeList[0].Attributes["Title"].Value;
            }
            else
            {
                return;
            }
            NodeList = document.GetElementsByTagName("OrderBy");
            if (NodeList != null && NodeList.Count > 0)
            {
                OrderKey = NodeList[0].InnerText;
                Order = NodeList[0].Attributes["Order"].Value;
            }
            else
            {
                return;
            }
            NodeList = document.GetElementsByTagName("Field");
            string fields = "";
            if (NodeList != null && NodeList.Count > 0)
            {
                foreach (XmlNode node in NodeList)
                {
                    if (node.InnerText != "")
                    {                       
                        fields += node.InnerText + ",";
                    }
                }
            }
            else
            {
                return;
            }
            #endregion
            if (fields.Length > 0)
            {
                fields = fields.Substring(0, fields.Length - 1);
                string sql = "select " + fields + " from " + tablename + " " + serch + " order by " + OrderKey + " " + Order;
                DataSet ds = new Maticsoft.BLL.CommonClass().Query(sql);

                if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                {
                    ReportDocument myReport = new ReportDocument();
                    myReport.Load(reportPath);
                    DataTable dtx1 = new clsDyCrystalReportCore().dtx(ds.Tables[0]);
                    int left = 100;
                    #region 设置每列显示的数据和宽度
                    for (int i = 0; i < NodeList.Count; i++)
                    {
                        //设置公式字段对应的数据库字段
                        myReport.DataDefinition.FormulaFields["colu" + (i + 1).ToString()].Text = "{CryReport.colu" + (i + 1) + "}";
                        //设置公式字段的文本
                        myReport.DataDefinition.FormulaFields["mt" + (i + 1).ToString()].Text = "\"" + NodeList[i].Attributes["ChinesName"].Value + "\"";
                        //设置宽度和左边偏移量
                        FieldObject fo;
                        fo = (FieldObject)myReport.ReportDefinition.ReportObjects["colu" + (i + 1)];
                        //fo.Height = 567 * 3;                 
                        int width = int.Parse(NodeList[i].Attributes["Width"].Value);
                        fo.Width = width;
                        fo.Left = left;
                        fo.Top = 30;
                        fo = (FieldObject)myReport.ReportDefinition.ReportObjects["mt" + (i + 1)];
                        //fo.Height = 567 * 3;
                        fo.Width = width;
                        fo.Left = left;
                        fo.Top = 760;
                        left += width+100;

                    }
                    #endregion
                    HideColu(NodeList.Count, myReport);
                    myReport.DataDefinition.FormulaFields["title"].Text = "\"" + title + "\"";
                    //myReport.Database.Tables[0].ApplyLogOnInfo(GetConnectionInfo());//设置报表数据库连接信息
                    myReport.SetDataSource(dtx1);
                    CrystalReportViewer1.SeparatePages = Separate;
                    CrystalReportViewer1.ReportSource = myReport;
                    CrystalReportViewer1.DataBind();
                    CrystalReportViewer1.RefreshReport();
                }
            }

        }                

 class clsDyCrystalReportCore
    {
        /// <summary>
        /// 将传入的datatable转换成报表模板所需要的datatable
        /// 数据全部转换为string
        /// </summary>
        /// <param name="dt">来源表</param>
        /// <returns>报表模板所需要的datatable</returns>

        public DataTable dtx(DataTable dt)
        {
            DataSet1.CryReportDataTable dtx1 = new DataSet1.CryReportDataTable();

            object[] obj = new object[dt.Columns.Count];
            //特别注意：所选择的表的列的数目需<=Bigtable的字段数目
            //请自行填写保护代码
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                dtx1.Rows.Add(dtx1.NewRow());

                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    dtx1.Rows[i][j] = dt.Rows[i][j].ToString();
                }
            }
            return dtx1;
        }

    }