public static void printOpenOrders(Main frmMain, string sCompanyName, string sReportHeader, DataSet dsOpenOrder) { using (Solsage_Process_Management_System.Documents.crOpenOrder reportOpenOrder = new Solsage_Process_Management_System.Documents.crOpenOrder()) { using (Solsage_Process_Management_System.Documents.PrintInvoice frmPrint = new Solsage_Process_Management_System.Documents.PrintInvoice()) { reportOpenOrder.SetDataSource(dsOpenOrder.Tables["OpenOrder"]); foreach (CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinition forReport in reportOpenOrder.DataDefinition.FormulaFields) { switch (forReport.FormulaName) { case "{@sCompanyName}": forReport.Text = "'" + sCompanyName + "'"; break; case "{@sReportHeading}": forReport.Text = "'" + sReportHeader + "'"; break; } } frmPrint.crystalReportViewer1.ReportSource = reportOpenOrder; frmPrint.printThisDocument(); } } }
public static void printAssetCosts(Main frmMain, DateTime dFromDate, DateTime dToDate,string sCompanyName,string sReportHeader, DataSet dsAssetCosts) { using (Solsage_Process_Management_System.Documents.crAssetCosting reportAssetCost = new Solsage_Process_Management_System.Documents.crAssetCosting()) { using (Solsage_Process_Management_System.Documents.PrintInvoice frmPrint = new Solsage_Process_Management_System.Documents.PrintInvoice()) { reportAssetCost.SetDataSource(dsAssetCosts.Tables["Costs"]); foreach (CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinition forReport in reportAssetCost.DataDefinition.FormulaFields) { switch (forReport.FormulaName) { case "{@FromDate}": forReport.Text = "'" + dFromDate.ToString("yyyy-MM-dd") + "'"; break; case "{@ToDate}": forReport.Text = "'" + dToDate.ToString("yyyy-MM-dd") + "'"; break; case "{@sCompanyName}": forReport.Text = "'" + sCompanyName + "'"; break; case "{@sReportHeading}": forReport.Text = "'" + sReportHeader + "'"; break; } } frmPrint.crystalReportViewer1.ReportSource = reportAssetCost; frmPrint.printThisDocument(); } } }
public static void printAvgCustTurnover18(DataTable dtCustTurnover) { using (Solsage_Process_Management_System.Documents.avgSalesPerCust18 reportAvgSalesPerCust = new Solsage_Process_Management_System.Documents.avgSalesPerCust18()) { using (Solsage_Process_Management_System.Documents.PrintInvoice frmPrint = new Solsage_Process_Management_System.Documents.PrintInvoice()) { reportAvgSalesPerCust.SetDataSource(dtCustTurnover); foreach (CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinition forReport in reportAvgSalesPerCust.DataDefinition.FormulaFields) { switch (forReport.FormulaName) { case "{@sGlobCompanyName}": forReport.Text = "'" + Global.sCompanyName.Trim() + "'"; break; case "{@sGlobCompanyRegName}": forReport.Text = "'" + Global.sRegName.Trim() + "'"; break; case "{@sGlobTel}": forReport.Text = "'" + Global.sCompanyTel.Trim() + "'"; break; case "{@sGlobFax}": forReport.Text = "'" + Global.sCompanyFax.Trim() + "'"; break; case "{@sGlobPost1}": forReport.Text = "'" + Global.sCompanyPostAd1.Trim() + "'"; break; case "{@sGlobPost2}": forReport.Text = "'" + Global.sCompanyPostAd2.Trim() + "'"; break; case "{@sGlobPost3}": forReport.Text = "'" + Global.sCompanyPostAd3.Trim() + "'"; break; case "{@sGlobAdd1}": forReport.Text = "'" + Global.sCompanyAd1.Trim() + "'"; break; case "{@sGlobAdd2}": forReport.Text = "'" + Global.sCompanyAd2.Trim() + "'"; break; case "{@sGlobAdd3}": forReport.Text = "'" + Global.sCompanyAd3.Trim() + "'"; break; case "{@CompanyCell}": forReport.Text = "'" + Global.sInvoiceContactNumber + "'"; break; //case "{@sCustomer}": // forReport.Text = "'" + sCustomer + "'"; // break; //case "{@sCustCode}": // forReport.Text = "'" + sCustCode + "'"; // break; //case "{@sCustPhone}": // forReport.Text = "'" + sCustPhone + "'"; // break; //case "{@sCustFax}": // forReport.Text = "'" + sCustFax + "'"; // break; //case "{@sCustContact}": // forReport.Text = "'" + sCustContact + "'"; // break; } } frmPrint.crystalReportViewer1.ReportSource = reportAvgSalesPerCust; // frmPrint.printThisDocument(); frmPrint.ShowDialog(); } } }
public static void printGoodsReturned(Main frmMain, string sSalesCode, string sUserCode, string sAssetNumber, string sReference, string sDocName, DataTable dtReturnedItems) { using (Solsage_Process_Management_System.Documents.crGoodsReturned reportGoodsRet = new Solsage_Process_Management_System.Documents.crGoodsReturned()) { using (Solsage_Process_Management_System.Documents.PrintInvoice frmPrint = new Solsage_Process_Management_System.Documents.PrintInvoice()) { reportGoodsRet.SetDataSource(dtReturnedItems); foreach (CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinition forReport in reportGoodsRet.DataDefinition.FormulaFields) { switch (forReport.FormulaName) { case "{@sGlobCompanyName}": forReport.Text = "'" + Global.sCompanyName.Trim() + "'"; break; case "{@sGlobCompanyRegName}": forReport.Text = "'" + Global.sRegName.Trim() + "'"; break; case "{@sGlobTel}": forReport.Text = "'" + Global.sCompanyTel.Trim() + "'"; break; case "{@sGlobFax}": forReport.Text = "'" + Global.sCompanyFax.Trim() + "'"; break; case "{@sGlobPost1}": forReport.Text = "'" + Global.sCompanyPostAd1.Trim() + "'"; break; case "{@sGlobPost2}": forReport.Text = "'" + Global.sCompanyPostAd2.Trim() + "'"; break; case "{@sGlobPost3}": forReport.Text = "'" + Global.sCompanyPostAd3.Trim() + "'"; break; case "{@sDocName}": forReport.Text = "'" + sDocName + "'"; break; case "{@sSalesCode}": forReport.Text = "'" + sSalesCode + "'"; break; case "{@sUserCode}": forReport.Text = "'" + sUserCode + "'"; break; case "{@sAssetNumber}": forReport.Text = "'" + sAssetNumber + "'"; break; case "{@sReference}": forReport.Text = "'" + sReference + "'"; break; } } frmPrint.crystalReportViewer1.ReportSource = reportGoodsRet; frmPrint.printThisDocument(); } } }
public static void printGoodsIssue(Main frmMain, string sDocumentNumber, string sMessage01, string sMessage02, string sDocName) { using (Solsage_Process_Management_System.Documents.GoodsIssues reportDelivery = new Solsage_Process_Management_System.Documents.GoodsIssues()) { using (Solsage_Process_Management_System.Documents.PrintInvoice frmPrint = new Solsage_Process_Management_System.Documents.PrintInvoice()) { frmPrint.crystalReportViewer1.SelectionFormula = "{SOLAL.DocumentNumber} = \"" + sDocumentNumber + "\" and {SOLAL.Quantity} > 0"; foreach (CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinition forReport in reportDelivery.DataDefinition.FormulaFields) { switch (forReport.FormulaName) { case "{@sGlobCompanyName}": forReport.Text = "'" + Global.sCompanyName.Trim() + "'"; break; case "{@sGlobCompanyRegName}": forReport.Text = "'" + Global.sRegName.Trim() + "'"; break; case "{@sGlobVat}": forReport.Text = "'" + Global.sVAT.Trim() + "'"; break; case "{@sGlobReg}": forReport.Text = "'" + Global.sReg.Trim() + "'"; break; case "{@sGlobTel}": forReport.Text = "'" + Global.sCompanyTel.Trim() + "'"; break; case "{@sGlobFax}": forReport.Text = "'" + Global.sCompanyFax.Trim() + "'"; break; case "{@sGlobPost1}": forReport.Text = "'" + Global.sCompanyPostAd1.Trim() + "'"; break; case "{@sGlobPost2}": forReport.Text = "'" + Global.sCompanyPostAd2.Trim() + "'"; break; case "{@sGlobPost3}": forReport.Text = "'" + Global.sCompanyPostAd3.Trim() + "'"; break; case "{@sGlobAdd1}": forReport.Text = "'" + Global.sCompanyAd1.Trim() + "'"; break; case "{@sGlobAdd2}": forReport.Text = "'" + Global.sCompanyAd2.Trim() + "'"; break; case "{@sGlobAdd3}": forReport.Text = "'" + Global.sCompanyAd3.Trim() + "'"; break; case "{@sInvoiceMessage01}": forReport.Text = sMessage01; break; case "{@sInvoiceMessage02}": forReport.Text = sMessage02; break; case "{@sDocName}": forReport.Text = "'" + sDocName + "'"; break; } } frmPrint.crystalReportViewer1.ReportSource = reportDelivery; frmPrint.printThisDocument(); } } }
public static void printDeliveryNote(Main frmMain, string sDocumentNumber, string sMessage01, string sMessage02, string sCoordinates, string sCollected, bool bFirstPrint, bool sendToDepot, PrintDialog pdPrintDetails) { using (PsqlConnection oPastelConn = new PsqlConnection(Connect.sPastelConnStr)) { using (PsqlConnection oLiquidConn = new PsqlConnection(Connect.sConnStr)) { ReportClass reportDelivery = null; oPastelConn.Open(); string sSql = ""; if (Global.sDeliveryNoteTemplate == "Talisman - Thubatse") { reportDelivery = new Solsage_Process_Management_System.Documents.Templates.Delivery.Del_Thubatse(); sSql = "Select HistoryHeader.DocumentNumber, HistoryHeader.CustomerCode, HistoryHeader.DocumentDate, HistoryHeader.SalesmanCode, DelAddress01, DelAddress02, DelAddress03, DelAddress04, DelAddress05, HistoryLines.ItemCode, UnitUsed, HistoryLines.Description, Qty, UnitPrice "; sSql += ",LinkNum, CustomerDesc, PostAddress01,PostAddress02,PostAddress03,PostAddress04,PostAddress05, OrderNumber,UserDefNum01, UserDefNum02, DiscountPercentage, UserDefined05 "; sSql += " From HistoryHeader Left Join HistoryLines on HistoryHeader.DocumentNumber = HistoryLines.DocumentNumber "; sSql += " Left Join CustomerMaster on HistoryHeader.CustomerCode = CustomerMaster.CustomerCode"; sSql += " Left Join Inventory on HistoryLines.ItemCode = Inventory.ItemCode"; sSql += " Where HistoryHeader.DocumentNumber = '" + sDocumentNumber + "' and HistoryHeader.DocumentType in (102,2) and HistoryLines.DocumentType in (102,2) order by LinkNum"; Datasets.dsDeliveryNote.delivery_01DataTable dtDelivery = new Solsage_Process_Management_System.Datasets.dsDeliveryNote.delivery_01DataTable(); using (PsqlDataReader rdReader = Connect.getDataCommand(sSql, oPastelConn).ExecuteReader()) { while (rdReader.Read()) { DataRow drRow = dtDelivery.NewRow(); drRow["DocumentNumber"] = rdReader["DocumentNumber"]; drRow["CustomerCode"] = rdReader["CustomerCode"]; drRow["DocumentDate"] = rdReader["DocumentDate"]; drRow["DelAddress01"] = rdReader["DelAddress01"]; drRow["DelAddress02"] = rdReader["DelAddress02"]; drRow["DelAddress03"] = rdReader["DelAddress03"]; drRow["DelAddress04"] = rdReader["DelAddress04"]; drRow["DelAddress05"] = rdReader["DelAddress05"]; drRow["ItemCode"] = rdReader["ItemCode"]; drRow["UnitUsed"] = rdReader["UnitUsed"]; drRow["Description"] = rdReader["Description"]; drRow["Qty"] = rdReader["Qty"]; drRow["UnitPrice"] = rdReader["UnitPrice"]; drRow["LinkNum"] = rdReader["LinkNum"]; drRow["CustomerDesc"] = rdReader["CustomerDesc"]; drRow["PostAddress01"] = rdReader["PostAddress01"]; drRow["PostAddress02"] = rdReader["PostAddress02"]; drRow["PostAddress03"] = rdReader["PostAddress03"]; drRow["PostAddress04"] = rdReader["PostAddress04"]; drRow["PostAddress05"] = rdReader["PostAddress05"]; drRow["OrderNumber"] = rdReader["OrderNumber"]; drRow["LineDiscount"] = rdReader["DiscountPercentage"]; drRow["DiscountCode"] = rdReader["UserDefined05"]; drRow["sTermsAndConditions"] = Global.sTermsAndConditions.Trim(); //get salesman name from solus 06/13/2011 string sSqlUs = "Select UserName from SOLUS where Code = '" + rdReader["SalesmanCode"].ToString() + "'"; string sUserName = Connect.getDataCommand(sSqlUs, oLiquidConn).ExecuteScalar().ToString(); drRow["SalesmanCode"] = sUserName; if (rdReader["ItemCode"].ToString().Trim() != "'" && !rdReader["ItemCode"].ToString().Trim().StartsWith("*D")) { if (rdReader["UserDefNum01"].ToString() == "1") { sSql = "select Convert(Multiplier,SQL_VARCHAR) + '|' + Convert(Status,SQL_VARCHAR) from SOLHL where Header = '" + rdReader["DocumentNumber"].ToString().Trim() + "' and LinkNum =" + rdReader["LinkNum"]; string[] aMultiplierRet = Connect.getDataCommand(sSql, oLiquidConn).ExecuteScalar().ToString().Split("|".ToCharArray()[0]); drRow["Multiplier"] = aMultiplierRet[0]; if (aMultiplierRet[1] == "1") { drRow["Returned"] = "*Ret"; } else { drRow["Returned"] = ""; } } else { sSql = "select Convert(Multiplier,SQL_VARCHAR) + '|' + Convert(Status,SQL_VARCHAR) from SOLHL where Header = '" + rdReader["DocumentNumber"].ToString().Trim() + "' and LinkNum =" + rdReader["LinkNum"]; string[] aQtyRet = Connect.getDataCommand(sSql, oLiquidConn).ExecuteScalar().ToString().Split("|".ToCharArray()[0]); drRow["Multiplier"] = aQtyRet[0]; if (aQtyRet[1] == "1") { drRow["Returned"] = "*Ret"; } else { drRow["Returned"] = ""; } } } dtDelivery.Rows.Add(drRow); } rdReader.Close(); } //extObject txtDeliveryMessage = (TextObject)((Solsage_Process_Management_System.Documents.Templates.Delivery.Del_02)reportDelivery).Section5.ReportObjects["txtConditions"]; //if (txtDeliveryMessage != null) //{ // txtDeliveryMessage.Text = txtDeliveryMessage.Text.Replace("<Company>", Global.sDeliveryNoteCompany); //} reportDelivery.SetDataSource((DataTable)dtDelivery); foreach (CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinition forReport in reportDelivery.DataDefinition.FormulaFields) { switch (forReport.FormulaName) { case "{@sGlobCompanyName}": forReport.Text = "'" + Global.sCompanyName.Trim() + "'"; break; case "{@sGlobCompanyRegName}": forReport.Text = "'" + Global.sRegName.Trim() + "'"; break; case "{@sGlobVat}": forReport.Text = "'" + Global.sVAT.Trim() + "'"; break; case "{@sGlobReg}": forReport.Text = "'" + Global.sReg.Trim() + "'"; break; case "{@sGlobTel}": forReport.Text = "'" + Global.sCompanyTel.Trim() + "'"; break; case "{@sGlobFax}": forReport.Text = "'" + Global.sCompanyFax.Trim() + "'"; break; case "{@sGlobPost1}": forReport.Text = "'" + Global.sCompanyPostAd1.Trim() + "'"; break; case "{@sGlobPost2}": forReport.Text = "'" + Global.sCompanyPostAd2.Trim() + "'"; break; case "{@sGlobPost3}": forReport.Text = "'" + Global.sCompanyPostAd3.Trim() + "'"; break; case "{@sGlobAdd1}": forReport.Text = "'" + Global.sCompanyAd1.Trim() + "'"; break; case "{@sGlobAdd2}": forReport.Text = "'" + Global.sCompanyAd2.Trim() + "'"; break; case "{@sGlobAdd3}": forReport.Text = "'" + Global.sCompanyAd3.Trim() + "'"; break; case "{@sInvoiceMessage01}": forReport.Text = sMessage01; break; case "{@sInvoiceMessage02}": forReport.Text = sMessage02; break; case "{@sCoordinates}": forReport.Text = "'" + sCoordinates + "'"; break; case "{@Collected}": if (sCollected == "COLLECTED") sCollected = sCollected + " BY:"; else sCollected = sCollected + " TO:"; forReport.Text = "'" + sCollected + "'"; break; case "{@CompanyCell}": forReport.Text = "'" + Global.sInvoiceContactNumber + "'"; break; } } } else if (Global.sDeliveryNoteTemplate == "Talisman - Lydenburg; Phalaborwa; Thubatse; Wonderboom") { reportDelivery = new Solsage_Process_Management_System.Documents.Templates.Delivery.Del_02(); sSql = "Select HistoryHeader.DocumentNumber, HistoryHeader.CustomerCode, HistoryHeader.DocumentDate, HistoryHeader.SalesmanCode, DelAddress01, DelAddress02, DelAddress03, DelAddress04, DelAddress05, HistoryLines.ItemCode, UnitUsed, HistoryLines.Description, Qty, UnitPrice "; sSql += ",LinkNum, CustomerDesc, PostAddress01,PostAddress02,PostAddress03,PostAddress04,PostAddress05, OrderNumber,UserDefNum01, UserDefNum02, DiscountPercentage, UserDefined05 "; sSql += " From HistoryHeader Left Join HistoryLines on HistoryHeader.DocumentNumber = HistoryLines.DocumentNumber "; sSql += " Left Join CustomerMaster on HistoryHeader.CustomerCode = CustomerMaster.CustomerCode"; sSql += " Left Join Inventory on HistoryLines.ItemCode = Inventory.ItemCode"; sSql += " Where HistoryHeader.DocumentNumber = '" + sDocumentNumber + "' and HistoryHeader.DocumentType in (102,2) and HistoryLines.DocumentType in (102,2) order by LinkNum"; Datasets.dsDeliveryNote.delivery_01DataTable dtDelivery = new Solsage_Process_Management_System.Datasets.dsDeliveryNote.delivery_01DataTable(); using (PsqlDataReader rdReader = Connect.getDataCommand(sSql, oPastelConn).ExecuteReader()) { while (rdReader.Read()) { DataRow drRow = dtDelivery.NewRow(); drRow["DocumentNumber"] = rdReader["DocumentNumber"]; drRow["CustomerCode"] = rdReader["CustomerCode"]; drRow["DocumentDate"] = rdReader["DocumentDate"]; drRow["DelAddress01"] = rdReader["DelAddress01"]; drRow["DelAddress02"] = rdReader["DelAddress02"]; drRow["DelAddress03"] = rdReader["DelAddress03"]; drRow["DelAddress04"] = rdReader["DelAddress04"]; drRow["DelAddress05"] = rdReader["DelAddress05"]; drRow["ItemCode"] = rdReader["ItemCode"]; drRow["UnitUsed"] = rdReader["UnitUsed"]; drRow["Description"] = rdReader["Description"]; drRow["Qty"] = rdReader["Qty"]; drRow["UnitPrice"] = rdReader["UnitPrice"]; drRow["LinkNum"] = rdReader["LinkNum"]; drRow["CustomerDesc"] = rdReader["CustomerDesc"]; drRow["PostAddress01"] = rdReader["PostAddress01"]; drRow["PostAddress02"] = rdReader["PostAddress02"]; drRow["PostAddress03"] = rdReader["PostAddress03"]; drRow["PostAddress04"] = rdReader["PostAddress04"]; drRow["PostAddress05"] = rdReader["PostAddress05"]; drRow["OrderNumber"] = rdReader["OrderNumber"]; drRow["LineDiscount"] = rdReader["DiscountPercentage"]; drRow["DiscountCode"] = rdReader["UserDefined05"]; drRow["sTermsAndConditions"] = Global.sTermsAndConditions.Trim(); //get salesman name from solus 06/13/2011 string sSqlUs = "Select UserName from SOLUS where Code = '" + rdReader["SalesmanCode"].ToString() + "'"; string sUserName = Connect.getDataCommand(sSqlUs, oLiquidConn).ExecuteScalar().ToString(); drRow["SalesmanCode"] = sUserName; if (rdReader["ItemCode"].ToString().Trim() != "'" && !rdReader["ItemCode"].ToString().Trim().StartsWith("*D")) { if (rdReader["UserDefNum01"].ToString() == "1") { sSql = "select Convert(Multiplier,SQL_VARCHAR) + '|' + Convert(Status,SQL_VARCHAR) from SOLHL where Header = '" + rdReader["DocumentNumber"].ToString().Trim() + "' and LinkNum =" + rdReader["LinkNum"]; string[] aMultiplierRet = Connect.getDataCommand(sSql, oLiquidConn).ExecuteScalar().ToString().Split("|".ToCharArray()[0]); drRow["Multiplier"] = aMultiplierRet[0]; if (aMultiplierRet[1] == "1") { drRow["Returned"] = "*Ret"; } else { drRow["Returned"] = ""; } } else { sSql = "select Convert(Multiplier,SQL_VARCHAR) + '|' + Convert(Status,SQL_VARCHAR) from SOLHL where Header = '" + rdReader["DocumentNumber"].ToString().Trim() + "' and LinkNum =" + rdReader["LinkNum"]; string[] aQtyRet = Connect.getDataCommand(sSql, oLiquidConn).ExecuteScalar().ToString().Split("|".ToCharArray()[0]); drRow["Multiplier"] = aQtyRet[0]; if (aQtyRet[1] == "1") { drRow["Returned"] = "*Ret"; } else { drRow["Returned"] = ""; } } } dtDelivery.Rows.Add(drRow); } rdReader.Close(); } //extObject txtDeliveryMessage = (TextObject)((Solsage_Process_Management_System.Documents.Templates.Delivery.Del_02)reportDelivery).Section5.ReportObjects["txtConditions"]; //if (txtDeliveryMessage != null) //{ // txtDeliveryMessage.Text = txtDeliveryMessage.Text.Replace("<Company>", Global.sDeliveryNoteCompany); //} reportDelivery.SetDataSource((DataTable)dtDelivery); foreach (CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinition forReport in reportDelivery.DataDefinition.FormulaFields) { switch (forReport.FormulaName) { case "{@sGlobCompanyName}": forReport.Text = "'" + Global.sCompanyName.Trim() + "'"; break; case "{@sGlobCompanyRegName}": forReport.Text = "'" + Global.sRegName.Trim() + "'"; break; case "{@sGlobVat}": forReport.Text = "'" + Global.sVAT.Trim() + "'"; break; case "{@sGlobReg}": forReport.Text = "'" + Global.sReg.Trim() + "'"; break; case "{@sGlobTel}": forReport.Text = "'" + Global.sCompanyTel.Trim() + "'"; break; case "{@sGlobFax}": forReport.Text = "'" + Global.sCompanyFax.Trim() + "'"; break; case "{@sGlobPost1}": forReport.Text = "'" + Global.sCompanyPostAd1.Trim() + "'"; break; case "{@sGlobPost2}": forReport.Text = "'" + Global.sCompanyPostAd2.Trim() + "'"; break; case "{@sGlobPost3}": forReport.Text = "'" + Global.sCompanyPostAd3.Trim() + "'"; break; case "{@sGlobAdd1}": forReport.Text = "'" + Global.sCompanyAd1.Trim() + "'"; break; case "{@sGlobAdd2}": forReport.Text = "'" + Global.sCompanyAd2.Trim() + "'"; break; case "{@sGlobAdd3}": forReport.Text = "'" + Global.sCompanyAd3.Trim() + "'"; break; case "{@sInvoiceMessage01}": forReport.Text = sMessage01; break; case "{@sInvoiceMessage02}": forReport.Text = sMessage02; break; case "{@sCoordinates}": forReport.Text = "'" + sCoordinates + "'"; break; case "{@Collected}": if (sCollected == "COLLECTED") sCollected = sCollected + " BY:"; else sCollected = sCollected + " TO:"; forReport.Text = "'" + sCollected + "'"; break; case "{@CompanyCell}": forReport.Text = "'" + Global.sInvoiceContactNumber + "'"; break; } } } else if (Global.sDeliveryNoteTemplate == "Kings Hire") { reportDelivery = new Solsage_Process_Management_System.Documents.Templates.Delivery.Site(); sSql = "Select HistoryHeader.DocumentNumber, HistoryHeader.CustomerCode, HistoryHeader.DocumentDate, HistoryHeader.SalesmanCode, DelAddress01, DelAddress02, DelAddress03, DelAddress04, DelAddress05, HistoryLines.ItemCode, UnitUsed, HistoryLines.Description, Qty, UnitPrice "; sSql += ",LinkNum, CustomerDesc, PostAddress01,PostAddress02,PostAddress03,PostAddress04,PostAddress05, OrderNumber,UserDefNum01, UserDefNum02, DiscountPercentage "; sSql += " From HistoryHeader Left Join HistoryLines on HistoryHeader.DocumentNumber = HistoryLines.DocumentNumber "; sSql += " Left Join CustomerMaster on HistoryHeader.CustomerCode = CustomerMaster.CustomerCode"; sSql += " Left Join Inventory on HistoryLines.ItemCode = Inventory.ItemCode"; sSql += " Where HistoryHeader.DocumentNumber = '" + sDocumentNumber + "' and HistoryHeader.DocumentType in (102,2) and HistoryLines.DocumentType in (102,2) order by LinkNum"; Datasets.dsDeliveryNote.delivery_01DataTable dtDelivery = new Solsage_Process_Management_System.Datasets.dsDeliveryNote.delivery_01DataTable(); using (PsqlDataReader rdReader = Connect.getDataCommand(sSql, oPastelConn).ExecuteReader()) { while (rdReader.Read()) { DataRow drRow = dtDelivery.NewRow(); drRow["DocumentNumber"] = rdReader["DocumentNumber"]; drRow["CustomerCode"] = rdReader["CustomerCode"]; drRow["DocumentDate"] = rdReader["DocumentDate"]; //get salesman name from solus 06/13/2011 string sSqlUs = "Select UserName from SOLUS where Code = '" + rdReader["SalesmanCode"].ToString() + "'"; string sUserName = Connect.getDataCommand(sSqlUs, oLiquidConn).ExecuteScalar().ToString(); drRow["SalesmanCode"] = sUserName; using (PsqlConnection oConn = new PsqlConnection(Solsage_Process_Management_System.Classes.Connect.sConnStr)) { oConn.Open(); if (rdReader["SalesmanCode"].ToString().Trim() != "") { sSql = "Select top 1 TelephoneNumber From SOLUS where Code = '" + rdReader["SalesmanCode"].ToString() + "'"; drRow["TelephoneNumber"] = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql, oConn).ExecuteScalar().ToString(); } else { drRow["TelephoneNumber"] = ""; } oConn.Dispose(); } using (PsqlConnection oConn = new PsqlConnection(Solsage_Process_Management_System.Classes.Connect.sConnStr)) { oConn.Open(); if (rdReader["SalesmanCode"].ToString().Trim() != "") { sSql = "Select top 1 Shortname From SOLUS where Code = '" + rdReader["SalesmanCode"].ToString() + "'"; drRow["ShortName"] = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql, oConn).ExecuteScalar().ToString(); } else { drRow["ShortName"] = ""; } oConn.Dispose(); } using (PsqlConnection oConn = new PsqlConnection(Solsage_Process_Management_System.Classes.Connect.sConnStr)) { oConn.Open(); if (rdReader["SalesmanCode"].ToString().Trim() != "") { sSql = "Select top 1 Description From SOLUS where Code = '" + rdReader["SalesmanCode"].ToString() + "'"; drRow["SalesmanName"] = Solsage_Process_Management_System.Classes.Connect.getDataCommand(sSql, oConn).ExecuteScalar().ToString(); } else { drRow["SalesmanName"] = ""; } oConn.Dispose(); } drRow["DelAddress01"] = rdReader["DelAddress01"]; drRow["DelAddress02"] = rdReader["DelAddress02"]; drRow["DelAddress03"] = rdReader["DelAddress03"]; drRow["DelAddress04"] = rdReader["DelAddress04"]; drRow["DelAddress05"] = rdReader["DelAddress05"]; drRow["ItemCode"] = rdReader["ItemCode"]; drRow["UnitUsed"] = rdReader["UnitUsed"]; drRow["Description"] = rdReader["Description"]; drRow["Qty"] = rdReader["Qty"]; drRow["UnitPrice"] = rdReader["UnitPrice"]; drRow["LinkNum"] = rdReader["LinkNum"]; drRow["CustomerDesc"] = rdReader["CustomerDesc"]; drRow["PostAddress01"] = rdReader["PostAddress01"]; drRow["PostAddress02"] = rdReader["PostAddress02"]; drRow["PostAddress03"] = rdReader["PostAddress03"]; drRow["PostAddress04"] = rdReader["PostAddress04"]; drRow["PostAddress05"] = rdReader["PostAddress05"]; drRow["OrderNumber"] = rdReader["OrderNumber"]; drRow["LineDiscount"] = rdReader["DiscountPercentage"]; if (rdReader["ItemCode"].ToString().Trim() != "'" && !rdReader["ItemCode"].ToString().Trim().StartsWith("*D")) { if (rdReader["UserDefNum01"].ToString() == "1") { sSql = "select Convert(Multiplier,SQL_VARCHAR) + '|' + Convert(Status,SQL_VARCHAR) from SOLHL where Header = '" + rdReader["DocumentNumber"].ToString().Trim() + "' and LinkNum =" + rdReader["LinkNum"]; string[] aMultiplierRet = Connect.getDataCommand(sSql, oLiquidConn).ExecuteScalar().ToString().Split("|".ToCharArray()[0]); drRow["Multiplier"] = aMultiplierRet[0]; if (aMultiplierRet[1] == "1") { drRow["Returned"] = "*Ret"; } else { drRow["Returned"] = ""; } } else { sSql = "select Convert(Multiplier,SQL_VARCHAR) + '|' + Convert(Status,SQL_VARCHAR) from SOLHL where Header = '" + rdReader["DocumentNumber"].ToString().Trim() + "' and LinkNum =" + rdReader["LinkNum"]; string[] aQtyRet = Connect.getDataCommand(sSql, oLiquidConn).ExecuteScalar().ToString().Split("|".ToCharArray()[0]); drRow["Multiplier"] = aQtyRet[0]; if (aQtyRet[1] == "1") { drRow["Returned"] = "*Ret"; } else { drRow["Returned"] = ""; } } } dtDelivery.Rows.Add(drRow); } rdReader.Close(); } TextObject txtDeliveryMessage = (TextObject)((Solsage_Process_Management_System.Documents.Templates.Delivery.Site)reportDelivery).Section5.ReportObjects["txtConditions"]; if (txtDeliveryMessage != null) { txtDeliveryMessage.Text = txtDeliveryMessage.Text.Replace("<Company>", Global.sDeliveryNoteCompany); } reportDelivery.SetDataSource((DataTable)dtDelivery); foreach (CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinition forReport in reportDelivery.DataDefinition.FormulaFields) { switch (forReport.FormulaName) { case "{@sGlobCompanyName}": forReport.Text = "'" + Global.sCompanyName.Trim() + "'"; break; case "{@sGlobCompanyRegName}": forReport.Text = "'" + Global.sRegName.Trim() + "'"; break; case "{@sGlobVat}": forReport.Text = "'" + Global.sVAT.Trim() + "'"; break; case "{@sGlobReg}": forReport.Text = "'" + Global.sReg.Trim() + "'"; break; case "{@sGlobTel}": forReport.Text = "'" + Global.sCompanyTel.Trim() + "'"; break; case "{@sGlobFax}": forReport.Text = "'" + Global.sCompanyFax.Trim() + "'"; break; case "{@sGlobPost1}": forReport.Text = "'" + Global.sCompanyPostAd1.Trim() + "'"; break; case "{@sGlobPost2}": forReport.Text = "'" + Global.sCompanyPostAd2.Trim() + "'"; break; case "{@sGlobPost3}": forReport.Text = "'" + Global.sCompanyPostAd3.Trim() + "'"; break; case "{@sGlobAdd1}": forReport.Text = "'" + Global.sCompanyAd1.Trim() + "'"; break; case "{@sGlobAdd2}": forReport.Text = "'" + Global.sCompanyAd2.Trim() + "'"; break; case "{@sGlobAdd3}": forReport.Text = "'" + Global.sCompanyAd3.Trim() + "'"; break; case "{@sInvoiceMessage01}": forReport.Text = sMessage01; break; case "{@sInvoiceMessage02}": forReport.Text = sMessage02; break; case "{@sCoordinates}": forReport.Text = "'" + sCoordinates + "'"; break; case "{@Collected}": if (sCollected == "COLLECTED") sCollected = sCollected + " BY:"; else sCollected = sCollected + " TO:"; forReport.Text = "'" + sCollected + "'"; break; case "{@CompanyCell}": forReport.Text = "'" + Global.sInvoiceContactNumber + "'"; break; } } } else if (Global.sDeliveryNoteTemplate == "Talisman - Faerie Glenn") { reportDelivery = new Solsage_Process_Management_System.Documents.Templates.Delivery.Del_01(); sSql = "Select HistoryHeader.DocumentNumber, HistoryHeader.CustomerCode, HistoryHeader.DocumentDate, HistoryHeader.SalesmanCode, DelAddress01, DelAddress02, DelAddress03, DelAddress04, DelAddress05, HistoryLines.ItemCode, UnitUsed, HistoryLines.Description, Qty, UnitPrice "; sSql += ",LinkNum, CustomerDesc, PostAddress01,PostAddress02,PostAddress03,PostAddress04,PostAddress05, OrderNumber,UserDefNum01, UserDefNum02, DiscountPercentage "; sSql += " From HistoryHeader Left Join HistoryLines on HistoryHeader.DocumentNumber = HistoryLines.DocumentNumber "; sSql += " Left Join CustomerMaster on HistoryHeader.CustomerCode = CustomerMaster.CustomerCode"; sSql += " Left Join Inventory on HistoryLines.ItemCode = Inventory.ItemCode"; sSql += " Where HistoryHeader.DocumentNumber = '" + sDocumentNumber + "' and HistoryHeader.DocumentType in (102,2) and HistoryLines.DocumentType in (102,2) order by LinkNum"; Datasets.dsDeliveryNote.delivery_01DataTable dtDelivery = new Solsage_Process_Management_System.Datasets.dsDeliveryNote.delivery_01DataTable(); using (PsqlDataReader rdReader = Connect.getDataCommand(sSql, oPastelConn).ExecuteReader()) { while (rdReader.Read()) { DataRow drRow = dtDelivery.NewRow(); drRow["DocumentNumber"] = rdReader["DocumentNumber"]; drRow["CustomerCode"] = rdReader["CustomerCode"]; drRow["DocumentDate"] = rdReader["DocumentDate"]; drRow["SalesmanCode"] = rdReader["SalesmanCode"]; drRow["DelAddress01"] = rdReader["DelAddress01"]; drRow["DelAddress02"] = rdReader["DelAddress02"]; drRow["DelAddress03"] = rdReader["DelAddress03"]; drRow["DelAddress04"] = rdReader["DelAddress04"]; drRow["DelAddress05"] = rdReader["DelAddress05"]; drRow["ItemCode"] = rdReader["ItemCode"]; drRow["UnitUsed"] = rdReader["UnitUsed"]; drRow["Description"] = rdReader["Description"]; drRow["Qty"] = rdReader["Qty"]; drRow["UnitPrice"] = rdReader["UnitPrice"]; drRow["LinkNum"] = rdReader["LinkNum"]; drRow["CustomerDesc"] = rdReader["CustomerDesc"]; drRow["PostAddress01"] = rdReader["PostAddress01"]; drRow["PostAddress02"] = rdReader["PostAddress02"]; drRow["PostAddress03"] = rdReader["PostAddress03"]; drRow["PostAddress04"] = rdReader["PostAddress04"]; drRow["PostAddress05"] = rdReader["PostAddress05"]; drRow["OrderNumber"] = rdReader["OrderNumber"]; drRow["sTermsAndConditions"] = Global.sTermsAndConditions; if (rdReader["UserDefNum01"].ToString() == "1") { sSql = "select Convert(Multiplier,SQL_VARCHAR) + '|' + Convert(Status,SQL_VARCHAR) from SOLHL where Header = '" + rdReader["DocumentNumber"].ToString().Trim() + "' and LinkNum =" + rdReader["LinkNum"]; string[] aMultiplierRet = Connect.getDataCommand(sSql, oLiquidConn).ExecuteScalar().ToString().Split("|".ToCharArray()[0]); drRow["Multiplier"] = aMultiplierRet[0]; if (aMultiplierRet[1] == "1") { drRow["Returned"] = "*Ret"; } else { drRow["Returned"] = ""; } } else { sSql = "select Convert(Multiplier,SQL_VARCHAR) + '|' + Convert(Status,SQL_VARCHAR) from SOLHL where Header = '" + rdReader["DocumentNumber"].ToString().Trim() + "' and LinkNum =" + rdReader["LinkNum"]; try { string[] aQtyRet = Connect.getDataCommand(sSql, oLiquidConn).ExecuteScalar().ToString().Split("|".ToCharArray()[0]); drRow["Multiplier"] = aQtyRet[0]; if (aQtyRet[1] == "1") { drRow["Returned"] = "*Ret"; } else { drRow["Returned"] = ""; } } catch { drRow["Returned"] = ""; } } dtDelivery.Rows.Add(drRow); } rdReader.Close(); } reportDelivery.SetDataSource((DataTable)dtDelivery); foreach (CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinition forReport in reportDelivery.DataDefinition.FormulaFields) { switch (forReport.FormulaName) { case "{@sGlobCompanyName}": forReport.Text = "'" + Global.sCompanyName.Trim() + "'"; break; case "{@sGlobCompanyRegName}": forReport.Text = "'" + Global.sRegName.Trim() + "'"; break; case "{@sGlobVat}": forReport.Text = "'" + Global.sVAT.Trim() + "'"; break; case "{@sGlobReg}": forReport.Text = "'" + Global.sReg.Trim() + "'"; break; case "{@sGlobTel}": forReport.Text = "'" + Global.sCompanyTel.Trim() + "'"; break; case "{@sGlobFax}": forReport.Text = "'" + Global.sCompanyFax.Trim() + "'"; break; case "{@sGlobPost1}": forReport.Text = "'" + Global.sCompanyPostAd1.Trim() + "'"; break; case "{@sGlobPost2}": forReport.Text = "'" + Global.sCompanyPostAd2.Trim() + "'"; break; case "{@sGlobPost3}": forReport.Text = "'" + Global.sCompanyPostAd3.Trim() + "'"; break; case "{@sGlobAdd1}": forReport.Text = "'" + Global.sCompanyAd1.Trim() + "'"; break; case "{@sGlobAdd2}": forReport.Text = "'" + Global.sCompanyAd2.Trim() + "'"; break; case "{@sGlobAdd3}": forReport.Text = "'" + Global.sCompanyAd3.Trim() + "'"; break; case "{@sInvoiceMessage01}": forReport.Text = sMessage01; break; case "{@sInvoiceMessage02}": forReport.Text = sMessage02; break; case "{@sCoordinates}": forReport.Text = "'" + sCoordinates + "'"; break; case "{@Collected}": if (sCollected == "COLLECTED") sCollected = sCollected + " BY:"; else sCollected = sCollected + " TO:"; forReport.Text = "'" + sCollected + "'"; break; case "{@CompanyCell}": forReport.Text = "'" + Global.sInvoiceContactNumber + "'"; break; } } } decimal iFPQuantity = Convert.ToDecimal(ConfigurationSettings.AppSettings.Get("DeliveryNoteFirstPrintCopies")); decimal iDPQuantity = Convert.ToDecimal(ConfigurationSettings.AppSettings.Get("DeliveryNoteDuplicatePrintCopies")); string filename = ""; //Printing of delivery note try { //convert to pdf for terms attachment if (Global.sDeliveryNoteTemplate == "Kings Hire") { // clear temp directory if (Directory.Exists(Application.StartupPath + "\\Temp")) { Directory.Delete(Application.StartupPath + "\\Temp", true); } Directory.CreateDirectory(Application.StartupPath + "\\Temp"); reportDelivery.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Application.StartupPath + "\\Temp\\DeliveryNote.pdf"); //merge terms and conditions with report try { // Open the output document PdfSharp.Pdf.PdfDocument outputDocument = new PdfSharp.Pdf.PdfDocument(); PdfSharp.Pdf.PdfDocument inputDocument = new PdfSharp.Pdf.PdfDocument(); int i = 0; int n = 1; try { while (i < n + 1) { if (i == 0) //1st page { inputDocument = PdfReader.Open(Application.StartupPath + "\\Temp\\DeliveryNote.pdf", PdfDocumentOpenMode.Import); } else { //add terms file if (File.Exists(Application.StartupPath + "\\Attachments\\Kings Hire terms and conditions.pdf")) { inputDocument = PdfReader.Open(Application.StartupPath + "\\Attachments\\Kings Hire terms and conditions.pdf", PdfDocumentOpenMode.Import); //PdfSharp.Pdf.PdfPage pagelast = inputDocument.Pages[0]; // ...and add it to the output document. //outputDocument.AddPage(pagelast); } else { MessageBox.Show("Please confirm that Terms and condition file exists"); } } // Get the page from the external document... PdfSharp.Pdf.PdfPage page = inputDocument.Pages[0]; // ...and add it to the output document. outputDocument.AddPage(page); i++; } } catch { } // Save the document... try { filename = Application.StartupPath + "\\Temp\\TempDeliveryNote.pdf"; //Application.StartupPath + "\\Qoutes\\" + sDocumentNumber +".pdf"; outputDocument.Save(filename); Process.Start(filename); //MessageBox.Show("Files are merged successfully"); // ...and start a viewer. } catch { MessageBox.Show("Error saving file to directory, please verify path in Company Setup"); } } catch (Exception Ex) { MessageBox.Show("Error Merging PDF Files, Please verify path of attached pictures."); } } if (sendToDepot) { //Send file to workstation if (!Directory.Exists(Application.StartupPath + "\\Temp")) { Directory.CreateDirectory(Application.StartupPath + "\\Temp"); } string sFilename = sDocumentNumber + ".rpt"; if (File.Exists(Application.StartupPath + "\\Temp\\" + sFilename)) { File.Delete(Application.StartupPath + "\\Temp\\" + sFilename); } // reportDelivery.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Application.StartupPath + "\\Temp\\" + sFilename); reportDelivery.SaveAs(Application.StartupPath + "\\Temp\\" + sFilename, true); sDepotFilename = Application.StartupPath + "\\Temp\\" + sFilename; oPastelConn.Dispose(); return; } if (Global.sDeliveryNoteTemplate == "Kings Hire") { if (bFirstPrint) { //reportDelivery.PrintOptions.PrinterName = Global.sDefaultDocPrinter; //reportDelivery.PrintToPrinter(Convert.ToInt16(iFPQuantity), false, 0, 0); //ddk 09/06/2011 //reportDelivery.PrintOptions.PrinterName = pdPrintDetails.PrinterSettings.PrinterName; //reportDelivery.PrintToPrinter(pdPrintDetails.PrinterSettings.Copies, false, 0, 0); } if (!bFirstPrint) { //reportDelivery.PrintOptions.PrinterName = Global.sDefaultDocPrinter; //reportDelivery.PrintToPrinter(Convert.ToInt16(iDPQuantity), false, 0, 0); //ddk 09/06/2011 //reportDelivery.PrintOptions.PrinterName = pdPrintDetails.PrinterSettings.PrinterName; //reportDelivery.PrintToPrinter(Convert.ToInt16(pdPrintDetails.PrinterSettings.Copies), false, 0, 0); } } else if (Global.sDeliveryNoteTemplate == "Talisman - Faerie Glenn") { reportDelivery.PrintOptions.PrinterName = Global.sDefaultDocPrinter; reportDelivery.PrintToPrinter(2, false, 0, 0); } else { reportDelivery.PrintOptions.PrinterName = Global.sDefaultDocPrinter; reportDelivery.PrintToPrinter(1, false, 0, 0); } } catch (Exception Ex) { using (Solsage_Process_Management_System.Documents.PrintInvoice frmPrint = new Solsage_Process_Management_System.Documents.PrintInvoice()) { frmPrint.crystalReportViewer1.ReportSource = reportDelivery; frmPrint.printThisDocument(); } } oPastelConn.Dispose(); } } }
public static void printInvoice_Old(Main frmMain, string sDocumentNumber) { using (Solsage_Process_Management_System.Documents.InvoicePrint reportInvoice = new Solsage_Process_Management_System.Documents.InvoicePrint()) { using (Solsage_Process_Management_System.Documents.PrintInvoice frmPrint = new Solsage_Process_Management_System.Documents.PrintInvoice()) { frmPrint.crystalReportViewer1.SelectionFormula = "{HistoryHeader.DocumentNumber} = \"" + sDocumentNumber + "\""; TextObject txtInvoiceMessage = (TextObject)reportInvoice.Section5.ReportObjects["txtInvoiceMessage"]; txtInvoiceMessage.Text = txtInvoiceMessage.Text.Replace("<I_NAME>", Global.sInvoiceContactName).Replace("<I_NUMBER123456>", Global.sInvoiceContactNumber).Replace("<ENTER>", "\r\n"); foreach (CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinition forReport in reportInvoice.DataDefinition.FormulaFields) { switch (forReport.FormulaName) { case "{@sGlobCompanyName}": forReport.Text = "'" + Global.sCompanyName.Trim() + "'"; break; case "{@sGlobCompanyRegName}": forReport.Text = "'" + Global.sRegName.Trim() + "'"; break; case "{@sGlobVat}": forReport.Text = "'" + Global.sVAT.Trim() + "'"; break; case "{@sGlobReg}": forReport.Text = "'" + Global.sReg.Trim() + "'"; break; case "{@sGlobTel}": forReport.Text = "'" + Global.sCompanyTel.Trim() + "'"; break; case "{@sGlobFax}": forReport.Text = "'" + Global.sCompanyFax.Trim() + "'"; break; case "{@sGlobPost1}": forReport.Text = "'" + Global.sCompanyPostAd1.Trim() + "'"; break; case "{@sGlobPost2}": forReport.Text = "'" + Global.sCompanyPostAd2.Trim() + "'"; break; case "{@sGlobPost3}": forReport.Text = "'" + Global.sCompanyPostAd3.Trim() + "'"; break; case "{@sGlobAdd1}": forReport.Text = "'" + Global.sCompanyAd1.Trim() + "'"; break; case "{@sGlobAdd2}": forReport.Text = "'" + Global.sCompanyAd2.Trim() + "'"; break; case "{@sGlobAdd3}": forReport.Text = "'" + Global.sCompanyAd3.Trim() + "'"; break; case "{@CompanyCell}": forReport.Text = "'" + Global.sInvoiceContactNumber + "'"; break; } } frmPrint.crystalReportViewer1.ReportSource = reportInvoice; frmPrint.printThisDocument(); } } }
private void dgCreditNotes_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { Cursor = System.Windows.Forms.Cursors.WaitCursor; using (Solsage_Process_Management_System.Documents.CreditNote reportCredit = new CreditNote()) { using (PrintInvoice frmPrint = new PrintInvoice()) { frmPrint.crystalReportViewer1.SelectionFormula = "{HistoryHeader.DocumentNumber} = \"" + dgCreditNotes.Rows[e.RowIndex].Cells[1].Value.ToString() + "\""; foreach (CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinition forReport in reportCredit.DataDefinition.FormulaFields) { switch (forReport.FormulaName) { case "{@sGlobCompanyName}": forReport.Text = "'" + Global.sCompanyName.Trim() + "'"; break; case "{@sGlobCompanyRegName}": forReport.Text = "'" + Global.sRegName.Trim() + "'"; break; case "{@sGlobVat}": forReport.Text = "'" + Global.sVAT.Trim() + "'"; break; case "{@sGlobReg}": forReport.Text = "'" + Global.sReg.Trim() + "'"; break; case "{@sGlobTel}": forReport.Text = "'" + Global.sCompanyTel.Trim() + "'"; break; case "{@sGlobFax}": forReport.Text = "'" + Global.sCompanyFax.Trim() + "'"; break; case "{@sGlobPost1}": forReport.Text = "'" + Global.sCompanyPostAd1.Trim() + "'"; break; case "{@sGlobPost2}": forReport.Text = "'" + Global.sCompanyPostAd2.Trim() + "'"; break; case "{@sGlobPost3}": forReport.Text = "'" + Global.sCompanyPostAd3.Trim() + "'"; break; case "{@sGlobAdd1}": forReport.Text = "'" + Global.sCompanyAd1.Trim() + "'"; break; case "{@sGlobAdd2}": forReport.Text = "'" + Global.sCompanyAd2.Trim() + "'"; break; case "{@sGlobAdd3}": forReport.Text = "'" + Global.sCompanyAd3.Trim() + "'"; break; case "{@sInvoiceMessage01}": forReport.Text = ""; break; case "{@sInvoiceMessage02}": forReport.Text = "'CREDIT NOTE AUTHORITY:__________________________'"; break; } } frmPrint.crystalReportViewer1.ReportSource = reportCredit; frmPrint.ShowDialog(); } } Cursor = System.Windows.Forms.Cursors.Default; }