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