public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptVatInvoice rpt = new rptVatInvoice();
rpt.Site = this.Site;
return(rpt);
}
public void print()
{
DialogResult result1 = MessageBox.Show("Do you want to print this Invoice?", "Account Management",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result1 == DialogResult.Yes)
{
try
{
CrystalReport.rptVatInvoice rpt = new CrystalReport.rptVatInvoice();
//The report you created.
cmd = new OleDbCommand();
OleDbDataAdapter myDA = new OleDbDataAdapter();
DataSet myDS = new DataSet();
//The DataSet you created.
con = new OleDbConnection(lblpath.Text);
cmd.Connection = con;
cmd.CommandText = "SELECT SALEMASTERID,SALEDATE,SALETYPE,CREDITDATE,ACCOUNTID,ACCOUNTNAME,GRANDTOTAL,TAX,DISCOUNT,TOTAL,LRNO,TRANSPORTCOMPANY,EXTRA,EXTRA1,EXTRA2,EXTRA3,EXTRA4,PAID,PAYMENTDUE from SaleMaster WHERE SALEMASTERID=" + txtinvoiceno.Text + "";
cmd.CommandType = CommandType.Text;
myDA.SelectCommand = cmd;
myDA.Fill(myDS, "SaleMaster");
cmd.CommandText = "SELECT Company.COMPANYNAME,Company.ADDRESS,Company.PHONENO,Company.EMAIL,Company.WEB,Company.TINNO,Company.CSTNO,Company.EXTRA1,Company.EXTRA2 FROM Company ";
cmd.CommandType = CommandType.Text;
myDA.SelectCommand = cmd;
myDA.Fill(myDS, "Company");
cmd.CommandText = "SELECT SALEDETAILID,SALEMASTERID,ITEMID,SERIALNO,MODELNO,ITEMNAME,QTY,RATE,UNITID,UNITNAME,BASICAMOUNT,NETAMOUNT,TAXID,TAXNAME,TAXAMOUNT,DISCOUNTPER,DISCOUNT,AMOUNT,SLNO,EXTRA,EXTRA1,EXTRA2,EXTRA3,EXTRA4 FROM SaleDetail WHERE SALEMASTERID=" + txtinvoiceno.Text + "";
cmd.CommandType = CommandType.Text;
myDA.SelectCommand = cmd;
myDA.Fill(myDS, "SaleDetail");
con.Close();
rpt.SetDataSource(myDS);
frmReport frm = new frmReport();
frm.crystalReportViewer1.ReportSource = rpt;
frm.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
