水晶报表

来源：互联网发布：天下三女神捏脸数据编辑：程序博客网时间：2024/04/28 13:34

1 加载报表

ReportDocument rptExpensiveProducts = new ReportDocument();

rptExpensiveProducts.Load(@"../../CrystalReport1.rpt");

crystalReportViewer1.ReportSource = rptExpensiveProducts;
crystalReportViewer1.Zoom(5);

利用数据集添冲报表样式后在代码中填充数据集

            DataSet ds = new DataSet();
            using (SqlConnection con = new SqlConnection(SqlHepler.CONN_STRING))
            {
                con.Open();
                using (SqlCommand cmd = con.CreateCommand())
                {
                        SqlDataAdapter sda = new SqlDataAdapter("select * from womenCheckInfo",con);
                        sda.Fill(ds,"check");

                        //指定具体报表
                        CrystalReport3 s = new CrystalReport3();
                        s.SetDataSource(ds.Tables[0]);
                        crystalReportViewer1.ReportSource = s;
                        crystalReportViewer1.Zoom(2);

                }
            }

2 在程序中更改报表中字段的显示文本

CrystalReport3 s = new CrystalReport3();

                        s.SetDataSource(ds.Tables[0]);
                        //按名称获取 ReportObject，将其转换为 TextObject，并返回此对象。
                        getTextObject = (TextObject)s.ReportDefinition.ReportObjects["Text1"];

                        getTextObject.Text = "更改后的信息";