public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { QuickReceipt rpt = new QuickReceipt(); rpt.Site = this.Site; return(rpt); }
public void print() { DialogResult result1 = MessageBox.Show("Do you want to print this Receipt?", "Account Management", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result1 == DialogResult.Yes) { try { CrystalReport.QuickReceipt rpt = new CrystalReport.QuickReceipt(); //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 LEDGERPOSTINGID,LDATE,ACCOUNTID,ACCOUNTNAME,VOUCHERTYPE,VOCHERNO,CREDIT,EXTRA,EXTRA1,EXTRA2,EXTRA3,EXTRA4 FROM LedgerPosting WHERE LEDGERPOSTINGID =" + SDID + ""; cmd.CommandType = CommandType.Text; myDA.SelectCommand = cmd; myDA.Fill(myDS, "LedgerPosting"); 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"); 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); } } }