public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crIPOCustMoneyLedger rpt = new crIPOCustMoneyLedger(); rpt.Site = this.Site; return(rpt); }
public void ShowCustMoneyLedgerReport() { _branchId = GlobalVariableBO._branchId; _fromDate = Convert.ToDateTime(dtFromDate.Value.ToShortDateString()); _toDate = Convert.ToDateTime(dtToDate.Value.ToShortDateString()); _custCode = txtCustCode.Text; IPOReportBAL moneyLedgerReportBal = new IPOReportBAL(); DataTable dtCustmoneyLedger = new DataTable(); DataTable dtCustBasicInfo = new DataTable(); LoadCommonInfo CmmInfo = new LoadCommonInfo(); crIPOCustMoneyLedger crCustMoneyledger = new crIPOCustMoneyLedger(); frmIPOReportViewer viewer = new frmIPOReportViewer(); dtCustmoneyLedger = moneyLedgerReportBal.GetIPOCustMoneyLedger(_custCode, _fromDate, _toDate); dtCustBasicInfo = moneyLedgerReportBal.GetIpoCustBasicInfo(_custCode); crCustMoneyledger.SetDataSource(dtCustmoneyLedger); if (dtCustBasicInfo.Rows.Count > 0) { ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtCustName"]).Text = dtCustBasicInfo.Rows[0]["Cust_Name"].ToString(); ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtCustCode"]).Text = dtCustBasicInfo.Rows[0]["Cust_Code"].ToString(); ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["Text6"]).Text = "Balance Before " + dtFromDate.Value.ToString("dd-MMM-yy") + " :"; ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtduration"]).Text = "Duration : " + dtFromDate.Value.ToString("dd-MMM-yyyy") + " To " + dtToDate.Value.ToString("dd-MMM-yyyy"); ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtreportName"]).Text = "IPO Customer Money Ledger"; } GetCommonInfo(); ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ///// Load Branch Name ((TextObject)crCustMoneyledger.ReportDefinition.Sections[2].ReportObjects["txtBranchName"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber; viewer.crystalReportViewer1.ReportSource = crCustMoneyledger; viewer.Show(); }