1。首先在项目里构造一个强类型的 dataset 放在app_code 文件夹下。
2。创建报表文件。选取第1步中的dataset作为数据源 .设计好报表
3.在页面里写代码 .把数据推入到dataset里。绑定报表查看控件
相关页面代码如下:
using CrystalDecisions.CrystalReports.Engine;
private ReportDocument customerReport;
protected void Page_Load(object sender, EventArgs e)
{
string reportPath;
customerReport = new ReportDocument();
reportPath = Server.MapPath("CrystalReport2.rpt");
customerReport.Load(reportPath);
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection("Data Source=server;Initial Catalog=TEST;User ID=sa;Password=jack2007");
// conn.Open();
SqlDataAdapter sdr = new SqlDataAdapter("select * from user_name", conn);
sdr.Fill(ds,"user");
customerReport.SetDataSource(ds);
this.CrystalReportViewer1.ReportSource = customerReport;
}