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); } }