public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { cr_DSE_22_1 rpt = new cr_DSE_22_1(); rpt.Site = this.Site; return(rpt); }
private void ShowPortFolioReportInvestorWise() { cr_DSE_22_1 objcr_DSE_22_1Report = new cr_DSE_22_1(); DataTable dtProtofolioReportInvestorwise = new DataTable(); DESReportBal objPortfolioBal = new DESReportBal(); CustShareSummeryViewer objfrm_DSE_22_1_Report = new CustShareSummeryViewer(); string deposit = "0.00"; string withdraw = "0.00"; string balance = "0.00"; string accruedbalance = "0.00"; string IPObalance = "0.00"; string availablebalance = "0.00"; string netbalance = "0.00"; try { ShareLedgerBAL shareLedgerBal = new ShareLedgerBAL(); DataTable dtCustSummerybasic = new DataTable(); RecordLevelFilteringBAL obj = new RecordLevelFilteringBAL(ResourceName.Customer_Share_Ledger_Share_Portfolio_Summery); string T_Custcode = obj.FilterCustCode(_custCode, ResourceName.Customer_Share_Ledger_Share_Portfolio_Summery); if (T_Custcode == "") { MessageBox.Show("You are restricted"); return; } dtCustSummerybasic = shareLedgerBal.GetCustomerSummerBasicInfo(T_Custcode, dtToDate.Value); if (dtCustSummerybasic.Rows.Count != 0) { deposit = Convert.ToDouble(dtCustSummerybasic.Rows[0]["Dep_Amount"]).ToString("N"); withdraw = Convert.ToDouble(dtCustSummerybasic.Rows[0]["Withdraw_Amount"]).ToString("N"); balance = Convert.ToDouble(dtCustSummerybasic.Rows[0]["Head_Balance"]).ToString("N"); accruedbalance = Convert.ToDouble(dtCustSummerybasic.Rows[0]["Accrued_Balance"]).ToString("N"); IPObalance = Convert.ToDouble(dtCustSummerybasic.Rows[0]["IPO_Balance"]).ToString("N"); availablebalance = (Convert.ToDecimal(balance) - (Convert.ToDecimal(accruedbalance))).ToString("N"); netbalance = (Convert.ToDecimal(availablebalance) + Convert.ToDecimal(IPObalance)).ToString("N"); } string temp_custCode = obj.FilterCustCode(_custCode, ResourceName.Customer_Share_Ledger_Share_Portfolio_Summery); dtProtofolioReportInvestorwise = objPortfolioBal.Get_DSE_22_1_Report(temp_custCode, dtToDate.Value); objcr_DSE_22_1Report.SetDataSource(dtProtofolioReportInvestorwise); GetCommonInfo(); ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtBranchInfo"]).Text = _branchAddress + ". Phone:" + _branchContactNumber; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtCustCode"]).Text = txtCustCode.Text; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtBOID"]).Text = txtAccountHolderBOId.Text; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtCustName"]).Text = txtAccountHolderName.Text; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtDeposit"]).Text = deposit; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtWithdraw"]).Text = withdraw; //((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtBalance"]).Text = // balance; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtCurrentTradeBalance"]).Text = balance; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtTotalAcrudeCharge"]).Text = accruedbalance; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtAvailableBalance"]).Text = availablebalance; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtIPOBalance"]).Text = IPObalance; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["txtNetBalance"]).Text = netbalance; ((TextObject)objcr_DSE_22_1Report.ReportDefinition.Sections[2].ReportObjects["asOnDate"]).Text = dtToDate.Value.ToString("dd/MMM/yyyy"); objfrm_DSE_22_1_Report.crvShareSummeryReportViewer.ReportSource = objcr_DSE_22_1Report; objfrm_DSE_22_1_Report.crvShareSummeryReportViewer.DisplayGroupTree = false; objfrm_DSE_22_1_Report.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Portfolio Report Investor Wise", MessageBoxButtons.OK, MessageBoxIcon.Information); } }