private void btnBaoCao_Click(object sender, EventArgs e) { try { using (SqlConnection cnn = new SqlConnection(constr)) { using (SqlCommand cmd = cnn.CreateCommand()) { cnn.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_danhSachPhanCongCanBoTheoNgay"; cmd.Parameters.AddWithValue("@ngay", DateTime.Parse(mtbNgay.Text)); // cmd.Parameters.AddWithValue("@ngayKetThuc", DateTime.Parse(txtNgayKetThuc.Text)); SqlDataAdapter dap = new SqlDataAdapter(cmd); DataTable data = new DataTable(); dap.Fill(data); BCphanCongTheoNgay report = new BCphanCongTheoNgay(); report.SetDataSource(data); crystalReportViewer1.ReportSource = report; } } } catch (Exception exx) { Debug.WriteLine(exx.Message); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { BCphanCongTheoNgay rpt = new BCphanCongTheoNgay(); rpt.Site = this.Site; return(rpt); }