public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
DateReport rpt = new DateReport();
rpt.Site = this.Site;
return(rpt);
}
public void btReportDate_Click(object sender, EventArgs e)
{
DSReport dsr = new DSReport();
DateReport rpt = new DateReport();
string Sql = " select * from v_ReportSellingByDay where cast(DateCome as Date) between '" + dtp.Value.ToString("yyyy/MM/dd") + "' and '" + DateTimePicker1.Value.ToString("yyyy/MM/dd") + "'";
var da = new SqlDataAdapter(Sql, ConstVar.connect.DatabaseConnection(ConstVar.constr));
da.Fill(dsr, "DTDateReport");
// rpt.SetParameterValue("test", "hello")
if (dsr.Tables["DTDateReport"].Rows.Count == 0)
{
MessageBox.Show("ບໍ່ມີຂໍ້ມູນນຳເຂົ້າວັນທີ: " + dtp.Value.ToString("yyyy/MM/dd"));
}
else
{
rpt.SetDataSource(dsr);
frm_MainReportChoosing.Default.CrystalReportViewer1.ReportSource = rpt;
frm_MainReportChoosing.Default.Show(this);
}
}
