private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { grdViewDemand.FocusedRowHandle = grdViewDemand.FocusedRowHandle + 1; if (grdViewDemand.RowCount == 0) { Close(); return; } if (grdViewDemand.FocusedRowHandle < 0) { Close(); return; } Cursor.Current = Cursors.WaitCursor; if (m_sType == "DL") { GetLeadId(); GetBillId(); if (m_sLeadId == "") { Close(); return; } ReportDocument cryRpt = new ReportDocument(); string strReportPath = ""; if (m_sReportName == "") { strReportPath = Application.StartupPath + "\\DemandLetter.Rpt"; } else { strReportPath = Application.StartupPath + "\\" + m_sReportName + ""; } cryRpt.Load(strReportPath); string[] DataFiles = new string[] { BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sRateAnalDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sRateAnalDBName }; frmReport objReport = new frmReport(); objReport.Text = "Report : " + strReportPath; objReport.ReportConvert(cryRpt, DataFiles); objReport.rptViewer.ReportSource = null; objReport.rptViewer.ReportSource = cryRpt; if (cryRpt.Database.Tables.Count > 1) { string s = "{ProgressBillRegister.LeadId} In [" + m_sLeadId.TrimEnd(',') + "] And {ProgressBillRegister.PBillId} In [" + m_sBillId.TrimEnd(',') + "]"; if (s.Length > 0) { cryRpt.RecordSelectionFormula = s; } objReport.rptViewer.SelectionFormula = s; } else { DataTable dt = new DataTable(); dt = ProgBillBL.GetDemandLetterFirstPrint(m_iCCId, m_sBillId, m_sLeadId); cryRpt.SetDataSource(dt); } if (cryRpt.Subreports.Count != 0) { string[] Sub_DataFiles = new string[] { BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName }; objReport.Sub_ReportConvert(cryRpt, DataFiles, 0); } objReport.WindowState = FormWindowState.Maximized; objReport.rptViewer.Refresh(); objReport.Show(); } else { if (grdViewDemand.RowCount == 0) { Close(); return; } ProgBillBL.InsertDLStatus(dtStatus, m_iAgeId); FillGridStatus(); } grdViewDemand.FocusedRowHandle = grdViewDemand.FocusedRowHandle - 1; Cursor.Current = Cursors.Default; }