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