using System; using System.Collections; using System.Collections.Generic; using System.ComponentModel; using System.Windows.Forms; using System.Drawing; using System.Data; using FastReport; using FastReport.Data; using FastReport.Dialog; using FastReport.Barcode; using FastReport.Table; using FastReport.Utils; namespace FastReport { public class ReportScript { decimal TotalPlusSection = 0; decimal TotalMinusSection = 0; decimal TotalCardsSales = 0; decimal TotalCardPayments = 0; decimal TotalCardsOther = 0; decimal TotalAdditions = 0; decimal TotalDeductions = 0; private void Form1_Shown(object sender, EventArgs e) { dtpDate.Text = System.DateTime.Now.ToString("d MMMM yyy"); } private void btnOk_Click(object sender, EventArgs e) { txtCashupDate.Text = "Transactions Date " + dtpDate.Value.ToString("yyyy-MM-dd"); TableDataSource tCashUp = Report.GetDataSource("cashup") as TableDataSource; TableDataSource tDeposit = Report.GetDataSource("deposit") as TableDataSource; TableDataSource tAdditions = Report.GetDataSource("Additions") as TableDataSource; TableDataSource tDeductions = Report.GetDataSource("Deductions") as TableDataSource; TableDataSource tCashUpRelation = Report.GetDataSource("cashup_relation") as TableDataSource; TableDataSource tCashUpCheques = Report.GetDataSource("cheques") as TableDataSource; tCashUp.SelectCommand = tCashUp.SelectCommand.ToString().Replace("@Date", dtpDate.Value.ToString("yyyy-MM-dd")); tDeposit.SelectCommand = tDeposit.SelectCommand.ToString().Replace("@Date", dtpDate.Value.ToString("yyyy-MM-dd")); tAdditions.SelectCommand = tAdditions.SelectCommand.ToString().Replace("@Date", dtpDate.Value.ToString("yyyy-MM-dd")); tDeductions.SelectCommand = tDeductions.SelectCommand.ToString().Replace("@Date", dtpDate.Value.ToString("yyyy-MM-dd")); tCashUpRelation.SelectCommand = tCashUpRelation.SelectCommand.ToString().Replace("@Date", dtpDate.Value.ToString("yyyy-MM-dd")); tCashUpCheques.SelectCommand = tCashUpCheques.SelectCommand.ToString().Replace("@Date", dtpDate.Value.ToString("yyyy-MM-dd")); } private void Data7_AfterData(object sender, EventArgs e) { TotalCardsSales = Convert.ToDecimal(Report.GetColumnValue("cashup.TotalCards")); TotalCardPayments = Convert.ToDecimal(Report.GetColumnValue("cashup.TotalCardPayments")); TotalCardsOther = Convert.ToDecimal(Report.GetColumnValue("cashup.TotalCardOther")); TotalAdditions = Convert.ToDecimal(Report.GetColumnValue("cashup.TotalAdditions")); TotalDeductions = Convert.ToDecimal(Report.GetColumnValue("cashup.TotalDeductions")); } private void DataSubAdd_AfterData(object sender, EventArgs e) { //Get the Total (+) section TotalPlusSection = (decimal)Report.GetTotalValue("Total_Transactions") + TotalCardPayments + TotalAdditions; txtTotalPlusSection.Text = TotalPlusSection.ToString("# ###.00"); } private void DataSubDeduct_AfterData(object sender, EventArgs e) { //Get the Total (+) section TotalMinusSection = TotalCardsSales + TotalCardsOther + TotalDeductions; txtTotalMinusSection.Text = (TotalMinusSection * -1).ToString("# ###.00"); //Get the final total txtTotCalculated.Text = (TotalPlusSection - TotalMinusSection).ToString("# ###.00"); txtDifference.Text = (Convert.ToDecimal(Report.GetColumnValue("deposit.TotalDeposit")) - (TotalPlusSection - TotalMinusSection)).ToString("# ###.00"); } } }