public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crptChiTieuTrongNgay rpt = new crptChiTieuTrongNgay(); rpt.Site = this.Site; return(rpt); }
public void BaoCaoChiTieuTrongNgay() { cmd.CommandText = "select pnh.MAPNH, nv.TENNV, 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=CONVERT(varchar, getdate(), 23)" + " group by pnh.MAPNH, nv.TENNV, ncc.TENNCC"; da.SelectCommand = cmd; DataTable dt = new DataTable("ChiTieuTrongNgay"); da.Fill(dt); crptChiTieuTrongNgay rp = new crptChiTieuTrongNgay(); rp.SetDataSource(dt); crystalReportViewer1.ReportSource = rp; }