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