public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
crpt_BC_HoatDongDoan rpt = new crpt_BC_HoatDongDoan();
rpt.Site = this.Site;
return(rpt);
}
public UC_BC_HDDoan()
{
InitializeComponent();
Report.crpt_BC_HoatDongDoan rpt = new Report.crpt_BC_HoatDongDoan();
rpt.SetParameterValue("fromDate", DateTime.Now.ToString());
crpt_BC_HDDoan.ReportSource = rpt;
}
private void buttonX2_Click(object sender, EventArgs e)
{
Report.crpt_BC_HoatDongDoan rpt = new Report.crpt_BC_HoatDongDoan();
rpt.SetParameterValue("fromDate", dtiptungay.Value.ToString());
conn.Open();
SqlDataAdapter dap = new SqlDataAdapter("SELECT Id,TenHoatDong,CONVERT(varchar,ThoiGian,103) as ThoiGian,MaCB,KetQua FROM tbl_THONGTINHOATDONGDOAN where ThoiGian between '" + dtiptungay.Value + "' and '" + dtipdenngay.Value + "'", conn);
DataSet ds = new DataSet();
dap.Fill(ds);
rpt.SetDataSource(ds.Tables[0]);
crpt_BC_HDDoan.ReportSource = rpt;
crpt_BC_HDDoan.Refresh();
conn.Close();
}
