public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crptDoanhThuTrongNgay rpt = new crptDoanhThuTrongNgay(); rpt.Site = this.Site; return(rpt); }
public void BaoCaoDoanhThuTrongNgay() { //HoaDonBUS hdBUS=new HoaDonBUS(); //List<HoaDonDTO> ListHDTrongNgay = hdBUS.LoadDsHDTrongNgay(); cmd.CommandText = "select hd.MAHD, nv.TENNV, b.TENBAN, Sum(ct.SL*ct.GIABAN) as TONGTIEN" + " from HOA_DON hd, CHI_TIET_HOA_DON ct, NHAN_VIEN nv, BAN b" + " where hd.MAHD=ct.MAHD and hd.MANVLAP=nv.MANV and hd.SOBAN=b.SOBAN and hd.TRANGTHAI=1 and hd.NGAYLAP=CONVERT(varchar, getdate(), 23)" + " group by hd.MAHD, nv.TENNV, b.TENBAN"; da.SelectCommand = cmd; DataTable dt = new DataTable("DoanhThuTrongNgay"); da.Fill(dt); crptDoanhThuTrongNgay rp = new crptDoanhThuTrongNgay(); rp.SetDataSource(dt); crystalReportViewer1.ReportSource = rp; }