public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crptChiTieuTrongKhoan rpt = new crptChiTieuTrongKhoan(); rpt.Site = this.Site; return(rpt); }
public void BaoCaoChiTieuTrongKhoan(DateTime tuNgay, DateTime denNgay) { cmd.CommandText = "select pnh.MAPNH, nv.TENNV, pnh.NGAYLAP, ncc.TENNCC, Sum(ct.SL*ct.GIA) as TONGTIEN" + " from PHIEU_NHAP_HANG pnh, CHI_TIET_PHIEU_NHAP_HANG ct, NHAN_VIEN nv, NHA_CUNG_CAP ncc" + " where pnh.MAPNH=ct.MAPNH and pnh.MANVLAP=nv.MANV and pnh.MANCC=ncc.MANCC and pnh.NGAYLAP>='" + string.Format("{0:yyyy-MM-dd HH:mm:ss}", tuNgay) + "' and pnh.NGAYLAP<='" + string.Format("{0:yyyy-MM-dd HH:mm:ss}", denNgay) + "'" + " group by pnh.MAPNH, nv.TENNV, pnh.NGAYLAP, ncc.TENNCC"; da.SelectCommand = cmd; DataTable dt = new DataTable("ChiTieuTrongKhoan"); da.Fill(dt); crptChiTieuTrongKhoan rp = new crptChiTieuTrongKhoan(); rp.SetDataSource(dt); crystalReportViewer1.ReportSource = rp; }