public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crp_bc_pn rpt = new crp_bc_pn(); rpt.Site = this.Site; return(rpt); }
public frm_bc_pn() { InitializeComponent(); crp_bc_pn sv = new crp_bc_pn(); DateTime nnhs = DateTime.Today; String ngaynhs = String.Format("{0:MM/dd/yyyy}", nnhs); String sql = "Select khachhang.tenkh, maphieu, serisp, tensp, nhanvien.tennv,yeucaukh, ngaynhanhs, ngayhentra, ghichu From phieunhan join nhanvien On phieunhan.manv=nhanvien.manv join khachhang on phieunhan.makh=khachhang.makh where ngaynhanhs='" + ngaynhs + "'"; if (lib.reDataSet(sql).Tables[0].Rows.Count == 0) { MessageBox.Show("No data", "Reporting", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } sv.SetDataSource(lib.reDataSet(sql).Tables[0]); crystalReportViewer1.ReportSource = sv; }