public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { InHD rpt = new InHD(); rpt.Site = this.Site; return(rpt); }
private void FrmRP_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); classKetNoi kn = new classKetNoi(); dt = kn.laybang("SELECT DONHANG.MaHD, KHACHHANG.TenKH, KHACHHANG.MaKH, KHACHHANG.SoDT, SANPHAM.TenSP, SANPHAM.DonVi, SANPHAM.DonGia, CTHD.SoLuong, CTHD.SoLuong * SANPHAM.DonGia AS ThanhTien, DONHANG.NgayLap FROM DONHANG INNER JOIN CTHD ON DONHANG.MaHD = CTHD.MaHD INNER JOIN KHACHHANG ON DONHANG.MaKH = KHACHHANG.MaKH INNER JOIN SANPHAM ON CTHD.MaSP = SANPHAM.MaSP where DONHANG.MaHD='" + MaHD + "'"); InHD RP = new InHD(); RP.SetDataSource(dt); crystalReportViewer1.ReportSource = RP; }