public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crptJournalVoucher rpt = new crptJournalVoucher(); rpt.Site = this.Site; return(rpt); }
/// <summary> /// Function to print JournalVoucher in curresponding Crystal report /// </summary> /// <param name="dsJournalVoucher"></param> internal void JournalVoucherPrinting(DataSet dsJournalVoucher) { try { crptJournalVoucher crptJournalVoucher = new crptJournalVoucher(); decimal decTotalAmount = 0; foreach (DataTable dtbl in dsJournalVoucher.Tables) { if (dtbl.TableName == "Table") { crptJournalVoucher.Database.Tables["dtblCompany"].SetDataSource(dtbl); } else if (dtbl.TableName == "Table1") { foreach (DataRow drow in dtbl.Rows) { DataColumn dtClmn = new DataColumn("Amount In Words"); dtbl.Columns.Add(dtClmn); if (drow["totalAmount"].ToString() != string.Empty) { decTotalAmount = Convert.ToDecimal(drow["totalAmount"].ToString()); drow["Amount In Words"] = new NumToText().AmountWords(decTotalAmount, PublicVariables._decCurrencyId); } crptJournalVoucher.Database.Tables["dtblJournalMaster"].SetDataSource(dtbl); } } else if (dtbl.TableName == "Table2") { DataColumn dtClmn = new DataColumn("CreditOrDebit"); dtbl.Columns.Add(dtClmn); DataColumn dtClmn1 = new DataColumn("Amount"); dtbl.Columns.Add(dtClmn1); foreach (DataRow drow in dtbl.Rows) { if (drow["chequeNo"].ToString() == string.Empty) { drow["chequeDate"] = string.Empty; } if (Convert.ToDecimal(drow["debit"].ToString()) == 0) { drow["Amount"] = Convert.ToDecimal(drow["credit"].ToString()); drow["CreditOrDebit"] = "Cr"; } else { drow["Amount"] = Convert.ToDecimal(drow["debit"].ToString()); drow["CreditOrDebit"] = "Dr"; } } crptJournalVoucher.Database.Tables["dtblJournalDetails"].SetDataSource(dtbl); } } this.crptViewer.ReportSource = crptJournalVoucher; SettingsSP spSettings = new SettingsSP(); if (spSettings.SettingsStatusCheck("DirectPrint") == "No") { base.Show(); this.BringToFront(); } else { crptJournalVoucher.PrintToPrinter(1, false, 0, 0); } } catch (Exception ex) { MessageBox.Show("CRV7" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crptJournalVoucher rpt = new crptJournalVoucher(); rpt.Site = this.Site; return rpt; }