public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CrystalReport_0 rpt = new CrystalReport_0(); rpt.Site = this.Site; return(rpt); }
private void fReport_Load(object sender, EventArgs e) { String sql = ""; if(status == null) { sql = "select * from dbo.viewRepostBill where bill_id = " + bill; CrystalReport1 crystalReport = new CrystalReport1(); crystalReport.SetDataSource(conn.getTable(sql)); crystalReportViewer1.ReportSource = crystalReport; } else { if(status == "0") { sql = "select* from viewtblBill where sTrangthai = 1"; }else if( status == "1") { sql = "select * from viewtblBill where dThoigianthanhtoan between '" + date1 + "' and '" + date2 + "'"; }else if(status == "2") { sql = "select* from viewtblBill where sTrangthai = 1 and DAY(GETDATE()) = DAY(dThoigianthanhtoan) and MONTH(GETDATE()) = MONTH(dThoigianthanhtoan)" + "and YEAR(GETDATE()) = YEAR(dThoigianthanhtoan)"; } CrystalReport_0 crystalReport_0 = new CrystalReport_0(); crystalReport_0.SetDataSource(conn.getTable(sql)); crystalReportViewer1.ReportSource = crystalReport_0; } }