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