private void button11_Click(object sender, EventArgs e) { try{ Cursor = Cursors.WaitCursor; timer1.Enabled = true; rptSales rpt = new rptSales(); //The report you created. cmd = new SqlCommand(); SqlDataAdapter myDA = new SqlDataAdapter(); RMS_DBDataSet myDS = new RMS_DBDataSet(); //The DataSet you created. con = new SqlConnection(cs.DBConn); cmd.Connection = con; cmd.CommandText = "SELECT * from Invoice_Info where InvoiceDate Between @d1 and @d2 and PaymentDue > 0 order by InvoiceDate "; cmd.Parameters.Add("@d1", SqlDbType.DateTime, 30, "InvoiceDate").Value = DateTimePicker2.Value.Date; cmd.Parameters.Add("@d2", SqlDbType.DateTime, 30, "InvoiceDate").Value = DateTimePicker1.Value.Date; cmd.CommandType = CommandType.Text; myDA.SelectCommand = cmd; myDA.Fill(myDS, "Invoice_Info"); rpt.SetDataSource(myDS); frmSalesReport frm = new frmSalesReport(); frm.crystalReportViewer1.ReportSource = rpt; frm.Visible = true; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptSales rpt = new rptSales(); rpt.Site = this.Site; return rpt; }