public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crRevenue rpt = new crRevenue(); rpt.Site = this.Site; return(rpt); }
private void btnFilter_Click(object sender, EventArgs e) { SqlConnection sqlConnection = new SqlConnection(Properties.Settings.Default.QLSieuThiMiniConnectionString); string query = "select * from tbl_DetailedBill, tbl_Product, tbl_Bill where tbl_Bill.BillID = tbl_DetailedBill.IDBill and tbl_DetailedBill.IDProduct = tbl_Product.ProductID"; if (txtYear.Text.Trim().Length > 0) { query += " and tbl_Bill.BilledDate/10000 = " + txtYear.Text; } if (txtMonth.Text.Trim().Length > 0) { query += " and (tbl_Bill.BilledDate/100)%100 = " + txtMonth.Text; } if (txtMonth.Text.Trim().Length > 0) { query += " and tbl_Bill.BilledDate%100 = " + txtDay.Text; } SqlDataAdapter da = new SqlDataAdapter(query, sqlConnection); DataTable dt = new DataTable(); da.Fill(dt); crRevenue rpt = new crRevenue(); rpt.SetDataSource(dt.DefaultView); crystalReportViewer1.ReportSource = rpt; }