MySqlConnection conn = new MySqlConnection("server=127.0.0.1;database=platform;uid=root;pwd=root;charset=gb2312"); MyReportData Mydata = new MyReportData(); DataSetByTime Mydata1 = new DataSetByTime(); DataScoreInfo Mydata2 = new DataScoreInfo(); MySqlDataAdapter da; MySqlDataAdapter da1; member member = new member(); private void frmPrint_Load(object sender, EventArgs e) { //显示报表内容 //int MemberId = Program.Num_id; int MemberId = 1; da = new MySqlDataAdapter("select a.MemberId as MemberId,MemberName,Score,Type from member as a left join memscore as b on a.memberid = b.memberid where a.memberid =" + MemberId + "", conn); da.Fill(Mydata, "MyReportDataTable"); da1 = new MySqlDataAdapter("select * from assessmentinfo where MemberId=" + MemberId + "", conn); da1.Fill(Mydata2, "DataScoreInfo"); crystalReport11.Load(Application.StartupPath + "CrystalReport1.rpt"); crystalReport11.SetDataSource(Mydata); crystalReport11.Subreports[0].SetDataSource(Mydata2);//将记录集传给子报表 crystalReportViewer1.ReportSource = crystalReport11; crystalReportViewer1.ShowPrintButton = false; }
CrystalReportSource1.ReportDocument.Load(Server.MapPath("CrystalReport.rpt"));
CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables["sql"]);
CrystalReportSource1.DataBind();
CrystalReportViewer1.ReportSource = CrystalReportSource1;
CrystalReportViewer1.DataBind();参考
MySqlConnection conn = new MySqlConnection("server=127.0.0.1;database=platform;uid=root;pwd=root;charset=gb2312");
MyReportData Mydata = new MyReportData();
DataSetByTime Mydata1 = new DataSetByTime();
DataScoreInfo Mydata2 = new DataScoreInfo();
MySqlDataAdapter da;
MySqlDataAdapter da1;
member member = new member();
private void frmPrint_Load(object sender, EventArgs e)
{
//显示报表内容
//int MemberId = Program.Num_id;
int MemberId = 1;
da = new MySqlDataAdapter("select a.MemberId as MemberId,MemberName,Score,Type from member as a left join memscore as b on a.memberid = b.memberid where a.memberid =" + MemberId + "", conn);
da.Fill(Mydata, "MyReportDataTable"); da1 = new MySqlDataAdapter("select * from assessmentinfo where MemberId=" + MemberId + "", conn);
da1.Fill(Mydata2, "DataScoreInfo"); crystalReport11.Load(Application.StartupPath + "CrystalReport1.rpt");
crystalReport11.SetDataSource(Mydata);
crystalReport11.Subreports[0].SetDataSource(Mydata2);//将记录集传给子报表 crystalReportViewer1.ReportSource = crystalReport11;
crystalReportViewer1.ShowPrintButton = false; }