public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { RpThang rpt = new RpThang(); rpt.Site = this.Site; return(rpt); }
private void btnxuatthang_Click(object sender, EventArgs e) { string Thang = txtThang.Value.Date.ToString("MM"); string Nam = txtThang.Value.Date.ToString("yyyy"); string sql = "SELECT HOADON.MAKH,SOHD,HOTEN,BIENSO,NGHD,TONGGIA FROM KHACHHANG,HOADON WHERE KHACHHANG.MAKH = HOADON.MAKH AND NGHD IS NOT NULL " + " AND YEAR(NGHD) = '" + Nam + "' AND MONTH(NGHD) ='" + Thang + "'"; DataTable dt = new DataTable(); RpThang BC = new RpThang(); dt = sp_BUS.Display(sql); BC.SetDataSource(dt); crystalReportViewer1.ReportSource = BC; crystalReportViewer1.Refresh(); }