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_thongKeSanPhamNhapTHeoNgayVaNhanVien"; //cmd.Parameters.AddWithValue("@ngayBatDau", DateTime.Parse(txtNgayBatDau.Text)); //cmd.Parameters.AddWithValue("@ngayKetThuc", DateTime.Parse(txtNgayKetThuc.Text)); cmd.Parameters.AddWithValue("@ngayBatDau", DateTime.ParseExact(txtNgayBatDau.Text, "dd/MM/yyyy", null)); cmd.Parameters.AddWithValue("@ngayKetThuc", DateTime.ParseExact(txtNgayKetThuc.Text, "dd/MM/yyyy", null)); SqlDataAdapter dap = new SqlDataAdapter(cmd); DataTable data = new DataTable(); dap.Fill(data); BaoCaoNhapHangTheoNhanVienVaThoiGian report = new BaoCaoNhapHangTheoNhanVienVaThoiGian(); report.SetDataSource(data); crystalReportViewer1.ReportSource = report; } } } catch (Exception ex) { } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { BaoCaoNhapHangTheoNhanVienVaThoiGian rpt = new BaoCaoNhapHangTheoNhanVienVaThoiGian(); rpt.Site = this.Site; return(rpt); }