public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CryReportHoatDong rpt = new CryReportHoatDong(); rpt.Site = this.Site; return(rpt); }
private void btIn_Click(object sender, EventArgs e) { if (rdInAll.Checked == true) { string select = "SELECT * FROM dbo.tbl_NhanVien INNER JOIN dbo.tbl_HoatDong ON dbo.tbl_NhanVien.Manv = dbo.tbl_HoatDong.Manv"; CryReportHoatDong inhd = new CryReportHoatDong(); inhd.SetDataSource(ketnoi.laydlbang(select)); crtInhdong.ReportSource = inhd; crtInhdong.Refresh(); } else { if (rdHdong.Checked == true) { string select = "SELECT * FROM dbo.tbl_NhanVien INNER JOIN dbo.tbl_HoatDong ON dbo.tbl_NhanVien.Manv = dbo.tbl_HoatDong.Manv where Mahdong='" + cbchon.SelectedValue.ToString() + "'"; CryReportHoatDong inhd = new CryReportHoatDong(); inhd.SetDataSource(ketnoi.laydlbang(select)); crtInhdong.ReportSource = inhd; crtInhdong.Refresh(); } else { if (rdInnv.Checked == true) { string select = "select * FROM dbo.tbl_NhanVien INNER JOIN dbo.tbl_HoatDong ON dbo.tbl_NhanVien.Manv = dbo.tbl_HoatDong.Manv where dbo.tbl_HoatDong.Manv='" + cbchon.SelectedValue.ToString() + "'"; CryReportHoatDong inhd = new CryReportHoatDong(); inhd.SetDataSource(ketnoi.laydlbang(select)); crtInhdong.ReportSource = inhd; crtInhdong.Refresh(); } else { MessageBox.Show("Bạn phải chọn mục để in", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } }