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