private void button1_Click(object sender, EventArgs e) { try { con.Open(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("execute salesDateRangeBal @fdate,@tdate", con); da.SelectCommand.Parameters.AddWithValue("@fdate", textBox1.Text); da.SelectCommand.Parameters.AddWithValue("@tdate", textBox2.Text); DataTable dt = new DataTable(); da.Fill(dt); saleReportDateRange myreport = new saleReportDateRange(); myreport.SetDataSource(dt); SaleReportView srv = new SaleReportView(); srv.crystalReportViewer1.ReportSource = myreport; srv.Show(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "errorr!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { con.Close(); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { saleReportDateRange rpt = new saleReportDateRange(); rpt.Site = this.Site; return rpt; }