private void button10_Click(object sender, EventArgs e)
{
try
{
if (cmbCustomerName.Text == "")
{
MessageBox.Show("Please select Customer name", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbCustomerName.Focus();
return;
}
Cursor = Cursors.WaitCursor;
timer1.Enabled = true;
rptSales rpt = new rptSales();
//The report you created.
cmd = new OleDbCommand();
OleDbDataAdapter myDA = new OleDbDataAdapter();
SIS_DBDataSet myDS = new SIS_DBDataSet();
//The DataSet you created.
con = new OleDbConnection(cs);
cmd.Connection = con;
cmd.CommandText = "SELECT Sales.InvoiceNo, Sales.InvoiceDate, Sales.CustomerID, Sales.SubTotal, Sales.VATPercentage, Sales.VATAmount, Sales.GrandTotal, Sales.TotalPayment,Sales.PaymentDue, Sales.Remarks, Customer.CustomerID AS Expr1, Customer.CustomerName, Customer.Address, Customer.Landmark, Customer.City, Customer.State, Customer.ZipCode, Customer.Phone, Customer.MobileNo, Customer.TIN, Customer.Email, Customer.Notes FROM (Sales INNER JOIN Customer ON Sales.CustomerID = Customer.CustomerID) where Customername='" + cmbCustomerName.Text + "' order by CustomerName,InvoiceDate";
cmd.CommandType = CommandType.Text;
myDA.SelectCommand = cmd;
myDA.Fill(myDS, "Sales");
myDA.Fill(myDS, "Customer");
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;
}