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
{
string custom1 = string.Empty;
string custom2 = string.Empty;
string custom3 = string.Empty;
string custom4 = string.Empty;
string custom5 = string.Empty;
string custom6 = string.Empty;
private void Form1_Shown(object sender, EventArgs e)
{
//Shows today's date
dtpFromDate.Text = System.DateTime.Now.ToString("d MMMM yyy");
dtpToDate.Text = System.DateTime.Now.ToString("d MMMM yyy");
cboOrderBy.Text = "Document #";
cboSelection.Text = "Area";
//Add the custom labels (if any)
custom1 = Report.GetColumnValue("programs_config.InvCustomLabel1").ToString();
custom2 = Report.GetColumnValue("programs_config.InvCustomLabel2").ToString();
custom3 = Report.GetColumnValue("programs_config.InvCustomLabel3").ToString();
custom4 = Report.GetColumnValue("programs_config.InvCustomLabel4").ToString();
custom5 = Report.GetColumnValue("programs_config.InvCustomLabel5").ToString();
custom6 = Report.GetColumnValue("programs_config.InvCustomLabel6").ToString();
if (custom1.Length > 0) cboSelection.Items.Add(custom1);
if (custom2.Length > 0) cboSelection.Items.Add(custom2);
if (custom3.Length > 0) cboSelection.Items.Add(custom3);
if (custom4.Length > 0) cboSelection.Items.Add(custom4);
if (custom5.Length > 0) cboSelection.Items.Add(custom5);
if (custom6.Length > 0) cboSelection.Items.Add(custom6);
}
private void btnOk_Click(object sender, EventArgs e)
{
Report.SetParameterValue("FromDate", dtpFromDate.Value.ToString("yyyy-MM-dd"));
Report.SetParameterValue("ToDate", dtpToDate.Value.ToString("yyyy-MM-dd"));
/*
Area
City
User
*/
string groupBy = String.Empty;
if (cboSelection.Text == "Area")
groupBy = "Area";
else if (cboSelection.Text == "City")
groupBy = "City";
else if (cboSelection.Text == "User")
groupBy = "SalesRep";
//Custom fields
else if (cboSelection.Text == custom1)
groupBy = "Custom1";
else if (cboSelection.Text == custom2)
groupBy = "Custom2";
else if (cboSelection.Text == custom3)
groupBy = "Custom3";
else if (cboSelection.Text == custom4)
groupBy = "Custom4";
else if (cboSelection.Text == custom5)
groupBy = "Custom5";
else if (cboSelection.Text == custom6)
groupBy = "Custom6";
//Document #
//Date
//Client Name
string orderBy = string.Empty;
if (cboOrderBy.Text == "Document #")
orderBy = "TransID";
else if (cboOrderBy.Text == "Date")
orderBy = "TransDate";
else if (cboOrderBy.Text == "Client Name")
orderBy = "ClientName";
TableDataSource tSelection = Report.GetDataSource("total_sales") as TableDataSource;
tSelection.SelectCommand = tSelection.SelectCommand.ToString().Replace("@Selection", groupBy);
TableDataSource tSubSelection = Report.GetDataSource("selection") as TableDataSource;
tSubSelection.SelectCommand = tSubSelection.SelectCommand.ToString().Replace("@Selection", groupBy);
tSubSelection.SelectCommand = tSubSelection.SelectCommand.ToString().Replace("@OrderBy", orderBy);
lblSelection.Text = cboSelection.Text;
txtHeader.Text = "Sales by " + cboSelection.Text;
}
private void ReportSummary2_AfterData(object sender, EventArgs e)
{
decimal totProfit = Convert.ToDecimal(Report.GetTotalValue("P1_Total_Profit").ToString());
decimal totExcl = Convert.ToDecimal(Report.GetTotalValue("P1_Total_Excl").ToString());
if (totExcl != 0)
{
decimal avgGP = (totProfit/totExcl);
txtTotGP.Text = (avgGP * 100).ToString("#.00");
}
else
{
txtTotGP.Text = "0.00";
}
}
}
}