private void SetNullWhenZero(DataDynamics.ActiveReports.TextBox textBox)
{
if (textBox.Text == "0")
{
textBox.Text = "";
}
}
private void SetGroupHeader(DataDynamics.ActiveReports.TextBox txtId,
DataDynamics.ActiveReports.TextBox txtName,
DataDynamics.ActiveReports.TextBox txtYosan,
DataDynamics.ActiveReports.TextBox txtJisseki,
DataDynamics.ActiveReports.TextBox txtSagaku,
DataDynamics.ActiveReports.TextBox txtHiritsu,
string namePrefix,
string nameSuffix)
{
int kamokuKubunId = helper.Converter.ObjToInt(txtId.Text, -1);
long yosan = helper.Converter.AmountToLongObj(txtYosan.Text).Value;
long jisseki = helper.Converter.AmountToLongObj(txtJisseki.Text).Value;
if (yosan == 0)
{
txtHiritsu.Text = "0.0";
}
else
{
txtHiritsu.Text = string.Format("{0:0.0}", ((double)jisseki) / ((double)yosan) * 100);
}
models.db.Row kamokuKubunRow = db.MTKamokuKubun.GetRowById(kamokuKubunId);
txtName.Text = namePrefix + kamokuKubunRow.GetStr("name") + nameSuffix;
}
void rptQuickReport_FetchData(object sender, ActiveReport3.FetchEventArgs eArgs)
{
foreach (ARControl arCtrl in this.detail.Controls)
{
if (arCtrl.GetType().Name == "TextBox")
{
DataDynamics.ActiveReports.TextBox txt = (DataDynamics.ActiveReports.TextBox)arCtrl;
string strDataField = txt.DataField;
//Bold
if (this.Fields.Contains("Bold"))
{
if ((bool)this.Fields["Bold"].Value == true)
{
txt.Font = new Font(txt.Font.FontFamily, txt.Font.Size, FontStyle.Bold);
}
else
{
txt.Font = new Font(txt.Font.FontFamily, txt.Font.Size, FontStyle.Regular);
}
}
if (this.Fields.Contains(strDataField) && txt.OutputFormat != null && txt.OutputFormat.Contains("#"))
{
if (Convert.ToDouble(this.Fields[strDataField].Value) == 0)
{
txt.Visible = false;
}
else
{
txt.Visible = true;
}
}
//DateMin
if (this.DataSource.GetType().Name == "DataTable")
{
DataTable dt = (DataTable)this.DataSource;
if (dt.Columns.Contains(strDataField) && dt.Columns[strDataField].DataType.Name == "DateTime")
{
if (this.Fields[strDataField].Value.ToString() == string.Empty || ((DateTime)this.Fields[strDataField].Value).ToString("dd/MM/yyyy") == "01/01/1900")
{
txt.Visible = false;
}
else
{
txt.Visible = true;
}
}
}
}
}
}
public void InitComponents(ControlCollection pageHeaderControls,
ControlCollection detailControls,
ControlCollection kubunFooterControls,
ControlCollection reportFooterControls,
DataDynamics.ActiveReports.TextBox txtKisanbi_,
DataDynamics.ActiveReports.TextBox txtKimatsubi_,
DataDynamics.ActiveReports.TextBox txtHoujinMei_,
DataDynamics.ActiveReports.TextBox txtKubunName_,
DataDynamics.ActiveReports.TextBox txtDaikubunName_,
DataDynamics.ActiveReports.TextBox txtKamokuCode_,
DataDynamics.ActiveReports.TextBox txtKamoku_,
DataDynamics.ActiveReports.TextBox txtKamokuId_,
DataDynamics.ActiveReports.TextBox txtDaikubunId_,
DataDynamics.ActiveReports.TextBox txtKubunId_,
DataDynamics.ActiveReports.Label txtShisyutsuKeiCaption_,
DataDynamics.ActiveReports.Label txtSyuunyuuKeiCaption_,
DataDynamics.ActiveReports.Label labelTitle_,
DataDynamics.ActiveReports.Label labelYoushiki_)
{
// コンポーネント配列の作成
txtColCaptions = helper.View.CreateTextboxArray(pageHeaderControls, "txtColCaption", NumCols);
txtDetailCols = helper.View.CreateTextboxArray(detailControls, "txtCol", NumCols);
txtSyuunyuuCols = helper.View.CreateTextboxArray(kubunFooterControls, "txtSyuunyuuKeiCol", NumCols);
txtShisyutsuCols = helper.View.CreateTextboxArray(kubunFooterControls, "txtShisyutsuKeiCol", NumCols);
//txtYobihiCols = helper.View.CreateTextboxArray(reportFooterControls, "txtYobihiCol", NumCols);
txtToukiCols = helper.View.CreateTextboxArray(reportFooterControls, "txtToukiCol", NumCols);
txtZenkiCols = helper.View.CreateTextboxArray(reportFooterControls, "txtZenkiCol", NumCols);
txtToukiZandakaCols = helper.View.CreateTextboxArray(reportFooterControls, "txtToukiZandakaCol", NumCols);
txtKisanbi = txtKisanbi_;
txtKimatsubi = txtKimatsubi_;
txtHoujinMei = txtHoujinMei_;
txtKubunName = txtKubunName_;
txtDaikubunName = txtDaikubunName_;
txtKamokuCode = txtKamokuCode_;
txtKamoku = txtKamoku_;
txtKamokuId = txtKamokuId_;
txtDaikubunId = txtDaikubunId_;
txtKubunId = txtKubunId_;
txtShisyutsuKeiCaption = txtShisyutsuKeiCaption_;
txtSyuunyuuKeiCaption = txtSyuunyuuKeiCaption_;
labelTitle = labelTitle_;
labelYoushiki = labelYoushiki_;
beforeSyuunyuuCols = new long[NumCols];
}
public void InitComponents(ControlCollection pageHeaderControls,
ControlCollection detailControls,
ControlCollection kubunFooterControls,
ControlCollection reportFooterControls,
DataDynamics.ActiveReports.TextBox txtKisanbi_,
DataDynamics.ActiveReports.TextBox txtKimatsubi_,
DataDynamics.ActiveReports.TextBox txtHoujinMei_,
DataDynamics.ActiveReports.TextBox txtKubunName_,
DataDynamics.ActiveReports.TextBox txtDaikubunName_,
DataDynamics.ActiveReports.TextBox txtKamokuCode_,
DataDynamics.ActiveReports.TextBox txtKamoku_,
DataDynamics.ActiveReports.TextBox txtKamokuId_,
DataDynamics.ActiveReports.TextBox txtDaikubunId_,
DataDynamics.ActiveReports.TextBox txtKubunId_,
DataDynamics.ActiveReports.Label txtSyuunyuuKeiCaption_,
DataDynamics.ActiveReports.Label labelTitle_,
DataDynamics.ActiveReports.Label labelYoushiki_)
{
// コンポーネント配列の作成
txtColCaptions = helper.View.CreateTextboxArray(pageHeaderControls, "txtColCaption", NumCols);
txtToukiCols = helper.View.CreateTextboxArray(reportFooterControls, "txtTouki", NumCols);
txtZenkiCols = helper.View.CreateTextboxArray(reportFooterControls, "txtZenki", NumCols);
txtToukimatsuCols = helper.View.CreateTextboxArray(reportFooterControls, "txtToukimatsu", NumCols);
txtKihonkinCols = helper.View.CreateTextboxArray(reportFooterControls, "txtKihonkin", NumCols);
txtTorikuzushiCols = helper.View.CreateTextboxArray(reportFooterControls, "txtTorikuzushi", NumCols);
txtTsumitateCols = helper.View.CreateTextboxArray(reportFooterControls, "txtTsumitate", NumCols);
txtJikiCols = helper.View.CreateTextboxArray(reportFooterControls, "txtJiki", NumCols);
txtKisanbi = txtKisanbi_;
txtKimatsubi = txtKimatsubi_;
txtHoujinMei = txtHoujinMei_;
txtKubunName = txtKubunName_;
txtDaikubunName = txtDaikubunName_;
txtKamokuCode = txtKamokuCode_;
txtKamoku = txtKamoku_;
txtKamokuId = txtKamokuId_;
txtDaikubunId = txtDaikubunId_;
txtKubunId = txtKubunId_;
txtSyuunyuuKeiCaption = txtSyuunyuuKeiCaption_;
labelTitle = labelTitle_;
labelYoushiki = labelYoushiki_;
}
private void rptTopReport_ReportStart(object sender, EventArgs e)
{
this._iRow = 0;
if (_InputParameters["DetailsType"] != null && _InputParameters["DetailsType"].ParamValue == _TypeName)//hide subreport if ReportType is the same as ParamType
{
this.Cancel();
}
else
{
//Dataset to hold data
DataTable _ChartData = new DataTable();
string criteria = bool.Parse(_InputParameters["IsShowLbs"].ParamValue) ? "(Weight - NItems*ContainerWeight)" : "WasteCost";
string where = " WHERE SiteID = " + _InputParameters["SiteID"].ParamValue;
if (_InputParameters["Filter"].ParamValue != "")
{
where += " AND " + _InputParameters["Filter"].ParamValue;
}
bool isWasteClassesUsed = false; // (VWA4Common.SecurityManager.GetSecurityManager().GetPermission("Allowed Waste Classes") != "-1") || (_InputParameters["WasteClasses"].ParamValue.ToString() != "");
//if (_InputParameters["WasteClasses"].ParamValue.ToString() != "")
// where += (where == "" ? "" : " AND (") + _InputParameters["WasteClasses"].ParamValue.ToString() + (where == "" ? "" : " )");
//else // if (VWA4Common.SecurityManager.GetSecurityManager().GetPermission("Allowed Waste Classes") != "-1")
// where = (where == "" ? VWA4Common.VWACommon.GetWasteClasses() : "(" + where + ") AND (" + VWA4Common.VWACommon.GetWasteClasses() + ")");
string subselect = "SELECT TOP " + _TopCount + " " + _TypeName + "Type.TypeName AS Name, " + _TypeName +
"TypeID as TypeID, Count(*) AS TransNum, Sum(WasteCost) AS Waste, Sum(Weight - NItems*ContainerWeight) AS Weights " +
" FROM (((Weights LEFT JOIN Transfers ON Transfers.TransKey = Weights.TransKey) " +
" LEFT JOIN LossType ON Weights.LossTypeID = LossType.TypeID)" +
((_TypeName == "Loss") ? "" : (" INNER JOIN " + _TypeName + "Type ON Weights." + _TypeName +
"TypeID = " + _TypeName + "Type.TypeID")) + ")" +
(isWasteClassesUsed ? " LEFT JOIN FoodType ON Weights.FoodTypeID = FoodType.TypeID " : "") +
where +
" GROUP BY Weights." + _TypeName + "TypeID, " + _TypeName + "Type.TypeName " +
" ORDER BY Sum(" + criteria + ") DESC";
string select =
@"SELECT * FROM (" + subselect + ") ORDER BY Waste " + (bool.Parse(_InputParameters["IsHorizontal"].ParamValue) ? " ASC;" : " DESC;");
_ChartData = VWA4Common.DB.Retrieve(select);
criteria = bool.Parse(_InputParameters["IsShowLbs"].ParamValue) ? "Weights" : "Waste";
if (_ChartData.Rows.Count > 0)
{
double max = double.Parse(_ChartData.Compute("Max(Waste)", "").ToString());
int step = 1; double temp = max;
for (step = 1; temp > 1; step *= 10)
{
temp = temp / 10;
}
step = step / 100 * (int)(1 + max * 10 / step);
this.chartControl1.ChartAreas[0].Axes["AxisY"].MajorTick.Step = step;
this.chartControl1.Series[0].Marker.Label.Font = new DataDynamics.ActiveReports.Chart.FontInfo(System.Drawing.Color.Black, new System.Drawing.Font("Arial", (_ChartData.Rows.Count > 20) ? 6F : 8F));
this.DataSource = VWA4Common.DB.Retrieve(subselect);
this.DataMember = _ChartData.TableName;
this.chartControl1.DataSource = _ChartData;
this.chartControl1.Series[0].ValueMembersY = criteria;
this.chartControl1.ColorPalette = VWA4Common.VWACommon.GetPalette(_InputParameters["ChartColor"].ParamValue);
this.chartControl1.Titles["footer"].Text = "TOP " + _TopCount + " " + _TypeName + (_TypeName == "Loss" ? "es" : "s");
SetWeight();
Set3D();
SetHorizontal();
if (_TypeName == "User")
{
DataDynamics.ActiveReports.TextBox txtTransNum = new DataDynamics.ActiveReports.TextBox();
detail.Controls.Add(txtTransNum);
txtWaste.Width = 0.64F;
txtWeight.Width = txtWaste.Width;
txtTransNum.Width = 0.44F;
txtTransNum.Height = txtWaste.Height;
txtTransNum.Top = txtWaste.Top;
txtTransNum.Left = txtWeight.Left;
txtWeight.Left = txtWeight.Left + 0.44F;
txtWaste.Left = txtWeight.Left + 0.64F;
txtTransNum.DataField = "TransNum";
lblName.Visible = true;
lblTrans.Visible = true;
lblWeight.Visible = true;
lblCost.Visible = true;
}
VWA4Common.GlobalSettings.SubReportWasPrinted = true;
}
else // don't show report if no data
{
this.Cancel();
}
//oleDBDataSource1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + VWA4Common.AppContext.DBPathName
// + ";Persist Security Info=False";
this.Document.Printer.Landscape = true;
//this.PrintWidth = this.PageSettings.PaperHeight - (this.PageSettings.Margins.Top + this.PageSettings.Margins.Bottom);
}
}
private void CreateTextBoxes(int num)
{
txtDates = new DataDynamics.ActiveReports.TextBox[num];
hdrDates = new DataDynamics.ActiveReports.TextBox[num];
lineHeader = new DataDynamics.ActiveReports.Line[num];
lineText = new DataDynamics.ActiveReports.Line[num];
float size = Math.Min(5F / num, 0.8F); //results + total
float left = 0.875F, height = 0.1875F, line_height = 0.1875F; // 0.25F;
for (int i = 0; i < num; i++)
{
txtDates[i] = new DataDynamics.ActiveReports.TextBox();
txtDates[i].Border.BottomColor = System.Drawing.Color.Black;
txtDates[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtDates[i].Border.LeftColor = System.Drawing.Color.Black;
txtDates[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtDates[i].Border.RightColor = System.Drawing.Color.Black;
txtDates[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtDates[i].Border.TopColor = System.Drawing.Color.Black;
txtDates[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtDates[i].Height = height;
txtDates[i].Left = left + i * size;
txtDates[i].Name = "txtDates" + i;
txtDates[i].Style = "font-size: 8pt; ";
txtDates[i].Text = null;
txtDates[i].Top = 0F;
txtDates[i].Width = size;
txtDates[i].DataField = "result" + i;
txtDates[i].Alignment = TextAlignment.Center;
this.detail.Controls.Add(txtDates[i]);
hdrDates[i] = new DataDynamics.ActiveReports.TextBox();
hdrDates[i].Border.BottomColor = System.Drawing.Color.Black;
hdrDates[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
hdrDates[i].Border.LeftColor = System.Drawing.Color.Black;
hdrDates[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
hdrDates[i].Border.RightColor = System.Drawing.Color.Black;
hdrDates[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
hdrDates[i].Border.TopColor = System.Drawing.Color.Black;
hdrDates[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
hdrDates[i].Height = height;
hdrDates[i].Left = left + i * size;
hdrDates[i].Name = "hdrDates" + i;
hdrDates[i].Style = "font-weight: bold; ";
hdrDates[i].Text = null;
hdrDates[i].Top = 0F;
hdrDates[i].Width = size;
hdrDates[i].OutputFormat = "d-MMM";
hdrDates[i].Alignment = TextAlignment.Center;
this.gpHeader.Controls.Add(hdrDates[i]);
//
// lineHeader
//
lineHeader[i] = new Line();
this.lineHeader[i].AnchorBottom = true;
this.lineHeader[i].Border.BottomColor = System.Drawing.Color.Black;
this.lineHeader[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
this.lineHeader[i].Border.LeftColor = System.Drawing.Color.Black;
this.lineHeader[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
this.lineHeader[i].Border.RightColor = System.Drawing.Color.Black;
this.lineHeader[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
this.lineHeader[i].Border.TopColor = System.Drawing.Color.Black;
this.lineHeader[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
this.lineHeader[i].Height = line_height;
this.lineHeader[i].Left = left + size * (i + 1);
this.lineHeader[i].LineWeight = 1F;
this.lineHeader[i].Name = "lineHeader" + i;
this.lineHeader[i].Top = 0F;
this.lineHeader[i].Width = 0F;
this.lineHeader[i].X1 = left + size * (i + 1);
this.lineHeader[i].X2 = left + size * (i + 1);
this.lineHeader[i].Y1 = 0F;
this.lineHeader[i].Y2 = line_height;
this.gpHeader.Controls.Add(lineHeader[i]);
//
// lineText
//
lineText[i] = new Line();
this.lineText[i].AnchorBottom = true;
this.lineText[i].Border.BottomColor = System.Drawing.Color.Black;
this.lineText[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
this.lineText[i].Border.LeftColor = System.Drawing.Color.Black;
this.lineText[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
this.lineText[i].Border.RightColor = System.Drawing.Color.Black;
this.lineText[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
this.lineText[i].Border.TopColor = System.Drawing.Color.Black;
this.lineText[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
this.lineText[i].Height = line_height;
this.lineText[i].Left = left + size * (i + 1);
this.lineText[i].LineWeight = 1F;
this.lineText[i].Name = "lineText" + i;
this.lineText[i].Top = 0F;
this.lineText[i].Width = 0F;
this.lineText[i].X1 = left + size * (i + 1);
this.lineText[i].X2 = left + size * (i + 1);
this.lineText[i].Y1 = 0F;
this.lineText[i].Y2 = line_height;
this.detail.Controls.Add(lineText[i]);
}
hdrTotal.Left = left + num * size;
txtTotal.Left = hdrTotal.Left;
line14.X2 = hdrTotal.Left + hdrTotal.Width;
line15.X2 = line14.X2;
line1.X2 = line14.X2;
line22.X1 = line14.X2;
line27.X1 = line14.X2;
line22.X2 = line14.X2;
line27.X2 = line14.X2;
lnBottom.Width = line14.Width;
lnBottom2.Width = line14.Width;
//line22.BringToFront();
//line27.BringToFront();
}
private void InitCells(int numMonths)
{
int i;
txtSalesBudget = new DataDynamics.ActiveReports.TextBox[numMonths];
txtFoodCostBudget = new DataDynamics.ActiveReports.TextBox[numMonths];
txtMealCountBudget = new DataDynamics.ActiveReports.TextBox[numMonths];
txtFoodCostPointsBudget = new DataDynamics.ActiveReports.TextBox[numMonths];
txtSales = new DataDynamics.ActiveReports.TextBox[numMonths];
txtFoodCost = new DataDynamics.ActiveReports.TextBox[numMonths];
txtMealCount = new DataDynamics.ActiveReports.TextBox[numMonths];
txtFoodCostPoints = new DataDynamics.ActiveReports.TextBox[numMonths];
txtFoodWasteAmount = new DataDynamics.ActiveReports.TextBox[numMonths];
txtFoodWastePercentage = new DataDynamics.ActiveReports.TextBox[numMonths];
txtSalesChanges = new DataDynamics.ActiveReports.TextBox[numMonths];
txtFoodCostChanges = new DataDynamics.ActiveReports.TextBox[numMonths];
txtMealCountChanges = new DataDynamics.ActiveReports.TextBox[numMonths];
txtFoodCostPointsChanges = new DataDynamics.ActiveReports.TextBox[numMonths];
for (i = 0; i < numMonths; i++)
{
txtSalesBudget[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodCostBudget[i] = new DataDynamics.ActiveReports.TextBox();
txtMealCountBudget[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodCostPointsBudget[i] = new DataDynamics.ActiveReports.TextBox();
txtSales[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodCost[i] = new DataDynamics.ActiveReports.TextBox();
txtMealCount[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodCostPoints[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodWasteAmount[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodWastePercentage[i] = new DataDynamics.ActiveReports.TextBox();
txtSalesChanges[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodCostChanges[i] = new DataDynamics.ActiveReports.TextBox();
txtMealCountChanges[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodCostPointsChanges[i] = new DataDynamics.ActiveReports.TextBox();
}
//
// txtSales
//
for (i = 0; i < numMonths; i++)
{
txtSalesBudget[i].Border.BottomColor = System.Drawing.Color.Black;
txtSalesBudget[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtSalesBudget[i].Border.LeftColor = System.Drawing.Color.Black;
txtSalesBudget[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtSalesBudget[i].Border.RightColor = System.Drawing.Color.Black;
txtSalesBudget[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtSalesBudget[i].Border.TopColor = System.Drawing.Color.Black;
txtSalesBudget[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtSalesBudget[i].Height = 0.1875F;
txtSalesBudget[i].Left = 1F + i * 0.625F;
txtSalesBudget[i].Name = "txtSalesBudget" + i;
txtSalesBudget[i].Style = "font-size: 8pt; ";
txtSalesBudget[i].Text = null;
txtSalesBudget[i].Top = 0.19F;
txtSalesBudget[i].Width = 0.625F;
txtSalesBudget[i].OutputFormat = "$#,##0";
this.detail.Controls.Add(txtSalesBudget[i]);
txtSales[i].Border.BottomColor = System.Drawing.Color.Black;
txtSales[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtSales[i].Border.LeftColor = System.Drawing.Color.Black;
txtSales[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtSales[i].Border.RightColor = System.Drawing.Color.Black;
txtSales[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtSales[i].Border.TopColor = System.Drawing.Color.Black;
txtSales[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtSales[i].Height = 0.1875F;
txtSales[i].Left = 1F + i * 0.625F;
txtSales[i].Name = "txtSales" + i;
txtSales[i].Style = "font-size: 8pt; ";
txtSales[i].Text = null;
txtSales[i].Top = 1.13F;
txtSales[i].Width = 0.625F;
txtSales[i].OutputFormat = "$#,##0";
this.detail.Controls.Add(txtSales[i]);
txtSalesChanges[i].Border.BottomColor = System.Drawing.Color.Black;
txtSalesChanges[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtSalesChanges[i].Border.LeftColor = System.Drawing.Color.Black;
txtSalesChanges[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtSalesChanges[i].Border.RightColor = System.Drawing.Color.Black;
txtSalesChanges[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtSalesChanges[i].Border.TopColor = System.Drawing.Color.Black;
txtSalesChanges[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtSalesChanges[i].Height = 0.1875F;
txtSalesChanges[i].Left = 1F + i * 0.625F;
txtSalesChanges[i].Name = "txtSalesChanges" + i;
txtSalesChanges[i].Style = "font-size: 8pt; ";
txtSalesChanges[i].Text = null;
txtSalesChanges[i].Top = 2.44F;
txtSalesChanges[i].Width = 0.625F;
txtSalesChanges[i].OutputFormat = "$#,##0";
this.detail.Controls.Add(txtSalesChanges[i]);
}
//
// txtFoodCost
//
for (i = 0; i < numMonths; i++)
{
txtFoodCostBudget[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodCostBudget[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostBudget[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodCostBudget[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostBudget[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodCostBudget[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostBudget[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodCostBudget[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostBudget[i].Height = 0.1875F;
txtFoodCostBudget[i].Left = 1F + i * 0.625F;
txtFoodCostBudget[i].Name = "txtFoodCostBudget" + i;
txtFoodCostBudget[i].Style = "font-size: 8pt; ";
txtFoodCostBudget[i].Text = null;
txtFoodCostBudget[i].Top = 0.38F;
txtFoodCostBudget[i].Width = 0.625F;
txtFoodCostBudget[i].OutputFormat = "$#,##0";
this.detail.Controls.Add(txtFoodCostBudget[i]);
txtFoodCost[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodCost[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCost[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodCost[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCost[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodCost[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCost[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodCost[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCost[i].Height = 0.1875F;
txtFoodCost[i].Left = 1F + i * 0.625F;
txtFoodCost[i].Name = "txtFoodCost" + i;
txtFoodCost[i].Style = "font-size: 8pt; ";
txtFoodCost[i].Text = null;
txtFoodCost[i].Top = 1.31F;
txtFoodCost[i].Width = 0.625F;
txtFoodCost[i].OutputFormat = "$#,##0";
this.detail.Controls.Add(txtFoodCost[i]);
txtFoodCostChanges[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodCostChanges[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostChanges[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodCostChanges[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostChanges[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodCostChanges[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostChanges[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodCostChanges[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostChanges[i].Height = 0.1875F;
txtFoodCostChanges[i].Left = 1F + i * 0.625F;
txtFoodCostChanges[i].Name = "txtFoodCostChanges" + i;
txtFoodCostChanges[i].Style = "font-size: 8pt; ";
txtFoodCostChanges[i].Text = null;
txtFoodCostChanges[i].Top = 2.63F;
txtFoodCostChanges[i].Width = 0.625F;
txtFoodCostChanges[i].OutputFormat = "$#,##0";
this.detail.Controls.Add(txtFoodCostChanges[i]);
}
//
// txtMealCount
//
for (i = 0; i < numMonths; i++)
{
txtMealCountBudget[i].Border.BottomColor = System.Drawing.Color.Black;
txtMealCountBudget[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtMealCountBudget[i].Border.LeftColor = System.Drawing.Color.Black;
txtMealCountBudget[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtMealCountBudget[i].Border.RightColor = System.Drawing.Color.Black;
txtMealCountBudget[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtMealCountBudget[i].Border.TopColor = System.Drawing.Color.Black;
txtMealCountBudget[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtMealCountBudget[i].Height = 0.1875F;
txtMealCountBudget[i].Left = 1F + i * 0.625F;
txtMealCountBudget[i].Name = "txtMealCountBudget" + i;
txtMealCountBudget[i].Style = "font-size: 8pt; ";
txtMealCountBudget[i].Text = null;
txtMealCountBudget[i].Top = 0.56F;
txtMealCountBudget[i].Width = 0.625F;
txtMealCountBudget[i].OutputFormat = "#,##0.";
this.detail.Controls.Add(txtMealCountBudget[i]);
txtMealCount[i].Border.BottomColor = System.Drawing.Color.Black;
txtMealCount[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtMealCount[i].Border.LeftColor = System.Drawing.Color.Black;
txtMealCount[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtMealCount[i].Border.RightColor = System.Drawing.Color.Black;
txtMealCount[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtMealCount[i].Border.TopColor = System.Drawing.Color.Black;
txtMealCount[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtMealCount[i].Height = 0.1875F;
txtMealCount[i].Left = 1F + i * 0.625F;
txtMealCount[i].Name = "txtMealCount" + i;
txtMealCount[i].Style = "font-size: 8pt; ";
txtMealCount[i].Text = null;
txtMealCount[i].Top = 1.5F;
txtMealCount[i].Width = 0.625F;
txtMealCount[i].OutputFormat = "#,##0.";
this.detail.Controls.Add(txtMealCount[i]);
txtMealCountChanges[i].Border.BottomColor = System.Drawing.Color.Black;
txtMealCountChanges[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtMealCountChanges[i].Border.LeftColor = System.Drawing.Color.Black;
txtMealCountChanges[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtMealCountChanges[i].Border.RightColor = System.Drawing.Color.Black;
txtMealCountChanges[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtMealCountChanges[i].Border.TopColor = System.Drawing.Color.Black;
txtMealCountChanges[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtMealCountChanges[i].Height = 0.1875F;
txtMealCountChanges[i].Left = 1F + i * 0.625F;
txtMealCountChanges[i].Name = "txtMealCountChanges" + i;
txtMealCountChanges[i].Style = "font-size: 8pt; ";
txtMealCountChanges[i].Text = null;
txtMealCountChanges[i].Top = 2.81F;
txtMealCountChanges[i].Width = 0.625F;
txtMealCountChanges[i].OutputFormat = "#,##0.";
this.detail.Controls.Add(txtMealCountChanges[i]);
}
//
// txtFoodCostPoints
//
for (i = 0; i < numMonths; i++)
{
txtFoodCostPointsBudget[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodCostPointsBudget[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsBudget[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodCostPointsBudget[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsBudget[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodCostPointsBudget[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsBudget[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodCostPointsBudget[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsBudget[i].Height = 0.1875F;
txtFoodCostPointsBudget[i].Left = 1F + i * 0.625F;
txtFoodCostPointsBudget[i].Name = "txtFoodCostPointsBudget" + i;
txtFoodCostPointsBudget[i].Style = "font-size: 8pt; ";
txtFoodCostPointsBudget[i].Text = null;
txtFoodCostPointsBudget[i].Top = 0.75F;
txtFoodCostPointsBudget[i].Width = 0.625F;
txtFoodCostPointsBudget[i].OutputFormat = _InputParameters["FinancialMode"].ParamValue == "Points" ? "#,##0.##%" : "$#,##0.##";
this.detail.Controls.Add(txtFoodCostPointsBudget[i]);
txtFoodCostPoints[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodCostPoints[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPoints[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodCostPoints[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPoints[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodCostPoints[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPoints[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodCostPoints[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPoints[i].Height = 0.1875F;
txtFoodCostPoints[i].Left = 1F + i * 0.625F;
txtFoodCostPoints[i].Name = "txtFoodCostPoints" + i;
txtFoodCostPoints[i].Style = "font-size: 8pt; ";
txtFoodCostPoints[i].Text = null;
txtFoodCostPoints[i].Top = 1.69F;
txtFoodCostPoints[i].Width = 0.625F;
txtFoodCostPoints[i].OutputFormat = txtFoodCostPointsBudget[i].OutputFormat;
this.detail.Controls.Add(txtFoodCostPoints[i]);
txtFoodCostPointsChanges[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodCostPointsChanges[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsChanges[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodCostPointsChanges[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsChanges[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodCostPointsChanges[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsChanges[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodCostPointsChanges[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsChanges[i].Height = 0.1875F;
txtFoodCostPointsChanges[i].Left = 1F + i * 0.625F;
txtFoodCostPointsChanges[i].Name = "txtFoodCostPointsChanges" + i;
txtFoodCostPointsChanges[i].Style = "font-size: 8pt; ";
txtFoodCostPointsChanges[i].Text = null;
txtFoodCostPointsChanges[i].Top = 3F;
txtFoodCostPointsChanges[i].Width = 0.625F;
txtFoodCostPointsChanges[i].OutputFormat = txtFoodCostPointsBudget[i].OutputFormat;
this.detail.Controls.Add(txtFoodCostPointsChanges[i]);
}
//
// txtFoodWasteAmount
//
for (i = 0; i < numMonths; i++)
{
txtFoodWasteAmount[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodWasteAmount[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmount[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodWasteAmount[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmount[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodWasteAmount[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmount[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodWasteAmount[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmount[i].Height = 0.1875F;
txtFoodWasteAmount[i].Left = 1F + i * 0.625F;
txtFoodWasteAmount[i].Name = "txtFoodWasteAmount" + i;
txtFoodWasteAmount[i].Style = "font-size: 8pt; ";
txtFoodWasteAmount[i].Text = null;
txtFoodWasteAmount[i].Top = 1.88F;
txtFoodWasteAmount[i].Width = 0.625F;
txtFoodWasteAmount[i].OutputFormat = "$#,##0";
this.detail.Controls.Add(txtFoodWasteAmount[i]);
}
//
// txtFoodWastePercentage
//
for (i = 0; i < numMonths; i++)
{
txtFoodWastePercentage[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodWastePercentage[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentage[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodWastePercentage[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentage[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodWastePercentage[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentage[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodWastePercentage[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentage[i].Height = 0.1875F;
txtFoodWastePercentage[i].Left = 1F + i * 0.625F;
txtFoodWastePercentage[i].Name = "txtFoodWastePercentage" + i;
txtFoodWastePercentage[i].Style = "font-size: 8pt; ";
txtFoodWastePercentage[i].Text = null;
txtFoodWastePercentage[i].Top = 2.06F;
txtFoodWastePercentage[i].Width = 0.625F;
txtFoodWastePercentage[i].OutputFormat = "#,##0.##%";
this.detail.Controls.Add(txtFoodWastePercentage[i]);
}
line1.X2 = 0.3F + 0.625F * (numMonths + 1);
line2.X1 = 0.3F + 0.625F * (numMonths + 1);
line2.X2 = 0.3F + 0.625F * (numMonths + 1) + 0.88F;
line3.X1 = 0.3F + 0.625F * (numMonths + 1);
line3.X2 = 0.3F + 0.625F * (numMonths + 1);
line4.X1 = 0.3F + 0.625F * (numMonths + 1) + 0.88F;
line4.X2 = 0.3F + 0.625F * (numMonths + 1) + 0.88F;
line7.X1 = 0.3F + 0.625F * (numMonths + 1);
line7.X2 = 0.3F + 0.625F * (numMonths + 1);
line8.X1 = 0.3F + 0.625F * (numMonths + 1) + 0.88F;
line8.X2 = 0.3F + 0.625F * (numMonths + 1) + 0.88F;
line9.X1 = 0.3F + 0.625F * (numMonths + 1);
line9.X2 = 0.3F + 0.625F * (numMonths + 1) + 0.88F;
hdrTotal.Left = 0.3F + 0.625F * (numMonths + 1);
txtTotalSalesBudget.Left = 0.3F + 0.625F * (numMonths + 1);
txtTotalFoodCostBudget.Left = 0.3F + 0.625F * (numMonths + 1);
txtTotalMealCountBudget.Left = 0.3F + 0.625F * (numMonths + 1);
txtTotalFoodCostPointsBudget.Left = 0.3F + 0.625F * (numMonths + 1);
txtTotalSales.Left = 0.3F + 0.625F * (numMonths + 1);
txtTotalFoodCost.Left = 0.3F + 0.625F * (numMonths + 1);
txtTotalMealCount.Left = 0.3F + 0.625F * (numMonths + 1);
txtTotalFoodCostPoints.Left = 0.3F + 0.625F * (numMonths + 1);
txtTotalFoodWastePercentage.Left = 0.3F + 0.625F * (numMonths + 1);
txtTotalFoodWasteAmount.Left = 0.3F + 0.625F * (numMonths + 1);
txtTotalSalesChanges.Left = 0.3F + 0.625F * (numMonths + 1);
txtTotalFoodCostChanges.Left = 0.3F + 0.625F * (numMonths + 1);
txtTotalMealCountChanges.Left = 0.3F + 0.625F * (numMonths + 1);
txtTotalFoodCostPointsChanges.Left = 0.3F + 0.625F * (numMonths + 1);
}
public void InitializeReport()
{
this.LoadLayout(this.GetType(), "Reports.rptFDICTraining.rpx");
this.ds = ((DataDynamics.ActiveReports.DataSources.OleDBDataSource)(this.DataSource));
this.PageHeader = ((DataDynamics.ActiveReports.PageHeader)(this.Sections["PageHeader"]));
this.GroupHeader1 = ((DataDynamics.ActiveReports.GroupHeader)(this.Sections["GroupHeader1"]));
this.Detail = ((DataDynamics.ActiveReports.Detail)(this.Sections["Detail"]));
this.GroupFooter1 = ((DataDynamics.ActiveReports.GroupFooter)(this.Sections["GroupFooter1"]));
this.PageFooter = ((DataDynamics.ActiveReports.PageFooter)(this.Sections["PageFooter"]));
this.Picture = ((DataDynamics.ActiveReports.Picture)(this.PageHeader.Controls[0]));
this.Label = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[1]));
this.Label1 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[2]));
this.Label2 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[3]));
this.lblEeName = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[4]));
this.lblEeNumber = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[5]));
this.Label3 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[6]));
this.lblSsn = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[7]));
this.Label5 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[8]));
this.lblEePhone = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[9]));
this.Line = ((DataDynamics.ActiveReports.Line)(this.PageHeader.Controls[10]));
this.Label7 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[11]));
this.Label8 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[12]));
this.Label9 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[13]));
this.Label10 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[14]));
this.Label11 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[15]));
this.Label12 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[16]));
this.Label13 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[17]));
this.Label14 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[18]));
this.Label15 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[19]));
this.Label16 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[20]));
this.Label17 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[21]));
this.Label18 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[22]));
this.Label19 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[23]));
this.Label20 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[24]));
this.Label21 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[25]));
this.Label22 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[26]));
this.lblWebSite = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[27]));
this.Label24 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[28]));
this.Label25 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[29]));
this.Label26 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[30]));
this.Label27 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[31]));
this.Label28 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[32]));
this.Label29 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[33]));
this.Label30 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[34]));
this.Label31 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[35]));
this.Label34 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[36]));
this.Label35 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[37]));
this.Label36 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[38]));
this.Label37 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[39]));
this.Label38 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[40]));
this.Label39 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[41]));
this.Label40 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[42]));
this.Label41 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[43]));
this.Label42 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[44]));
this.Label43 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[45]));
this.Label44 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[46]));
this.Label45 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[47]));
this.TextBox7 = ((DataDynamics.ActiveReports.TextBox)(this.PageHeader.Controls[48]));
this.TextBox8 = ((DataDynamics.ActiveReports.TextBox)(this.PageHeader.Controls[49]));
this.Line2 = ((DataDynamics.ActiveReports.Line)(this.PageHeader.Controls[50]));
this.Label4 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[51]));
this.Label46 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[0]));
this.Label47 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[1]));
this.Label48 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[2]));
this.Label49 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[3]));
this.TextBox = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[0]));
this.TextBox1 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[1]));
this.TextBox2 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[2]));
this.TextBox3 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[3]));
this.Line1 = ((DataDynamics.ActiveReports.Line)(this.GroupFooter1.Controls[0]));
this.Label50 = ((DataDynamics.ActiveReports.Label)(this.GroupFooter1.Controls[1]));
this.TextBox4 = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[2]));
this.TextBox5 = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[3]));
this.TextBox6 = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[4]));
}
private void InitCells()
{
int i;
txtFoodCostPointsPrior = new DataDynamics.ActiveReports.TextBox[12];
txtFoodWasteAmountPrior = new DataDynamics.ActiveReports.TextBox[12];
txtFoodWastePercentagePrior = new DataDynamics.ActiveReports.TextBox[12];
txtFoodCostPoints = new DataDynamics.ActiveReports.TextBox[12];
txtFoodWasteAmount = new DataDynamics.ActiveReports.TextBox[12];
txtFoodWastePercentage = new DataDynamics.ActiveReports.TextBox[12];
txtFoodCostPointsChanges = new DataDynamics.ActiveReports.TextBox[12];
txtFoodWasteAmountChanges = new DataDynamics.ActiveReports.TextBox[12];
txtFoodWastePercentageChanges = new DataDynamics.ActiveReports.TextBox[12];
for (i = 0; i < 12; i++)
{
txtFoodCostPointsPrior[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodWasteAmountPrior[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodWastePercentagePrior[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodCostPoints[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodWasteAmount[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodWastePercentage[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodCostPointsChanges[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodWasteAmountChanges[i] = new DataDynamics.ActiveReports.TextBox();
txtFoodWastePercentageChanges[i] = new DataDynamics.ActiveReports.TextBox();
}
//
// txtFoodCostPoints
//
for (i = 0; i < 12; i++)
{
txtFoodCostPointsPrior[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodCostPointsPrior[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsPrior[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodCostPointsPrior[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsPrior[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodCostPointsPrior[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsPrior[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodCostPointsPrior[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsPrior[i].Height = 0.1875F;
txtFoodCostPointsPrior[i].Left = 1F + i * 0.625F;
txtFoodCostPointsPrior[i].Name = "txtFoodCostPointsPrior" + i;
txtFoodCostPointsPrior[i].Style = "font-size: 8pt; ";
txtFoodCostPointsPrior[i].Text = null;
txtFoodCostPointsPrior[i].Top = 0.19F;
txtFoodCostPointsPrior[i].Width = 0.625F;
txtFoodCostPointsPrior[i].OutputFormat = _InputParameters["FinancialMode"].ParamValue == "Points" ? "#,##0.##%" : "$#,##0.##";
this.detail.Controls.Add(txtFoodCostPointsPrior[i]);
txtFoodCostPoints[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodCostPoints[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPoints[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodCostPoints[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPoints[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodCostPoints[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPoints[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodCostPoints[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPoints[i].Height = 0.1875F;
txtFoodCostPoints[i].Left = 1F + i * 0.625F;
txtFoodCostPoints[i].Name = "txtFoodCostPoints" + i;
txtFoodCostPoints[i].Style = "font-size: 8pt; ";
txtFoodCostPoints[i].Text = null;
txtFoodCostPoints[i].Top = 0.94F;
txtFoodCostPoints[i].Width = 0.625F;
txtFoodCostPoints[i].OutputFormat = txtFoodCostPointsPrior[i].OutputFormat;
this.detail.Controls.Add(txtFoodCostPoints[i]);
txtFoodCostPointsChanges[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodCostPointsChanges[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsChanges[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodCostPointsChanges[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsChanges[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodCostPointsChanges[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsChanges[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodCostPointsChanges[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodCostPointsChanges[i].Height = 0.1875F;
txtFoodCostPointsChanges[i].Left = 1F + i * 0.625F;
txtFoodCostPointsChanges[i].Name = "txtFoodCostPointsChanges" + i;
txtFoodCostPointsChanges[i].Style = "font-size: 8pt; ";
txtFoodCostPointsChanges[i].Text = null;
txtFoodCostPointsChanges[i].Top = 1.69F;
txtFoodCostPointsChanges[i].Width = 0.625F;
txtFoodCostPointsChanges[i].OutputFormat = txtFoodCostPointsPrior[i].OutputFormat;
this.detail.Controls.Add(txtFoodCostPointsChanges[i]);
}
//
// txtFoodWasteAmount
//
for (i = 0; i < 12; i++)
{
txtFoodWasteAmountPrior[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodWasteAmountPrior[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmountPrior[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodWasteAmountPrior[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmountPrior[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodWasteAmountPrior[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmountPrior[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodWasteAmountPrior[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmountPrior[i].Height = 0.1875F;
txtFoodWasteAmountPrior[i].Left = 1F + i * 0.625F;
txtFoodWasteAmountPrior[i].Name = "txtFoodWasteAmountPrior" + i;
txtFoodWasteAmountPrior[i].Style = "font-size: 8pt; ";
txtFoodWasteAmountPrior[i].Text = null;
txtFoodWasteAmountPrior[i].Top = 0.38F;
txtFoodWasteAmountPrior[i].Width = 0.625F;
txtFoodWasteAmountPrior[i].OutputFormat = "$#,##0";
this.detail.Controls.Add(txtFoodWasteAmountPrior[i]);
txtFoodWasteAmount[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodWasteAmount[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmount[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodWasteAmount[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmount[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodWasteAmount[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmount[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodWasteAmount[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmount[i].Height = 0.1875F;
txtFoodWasteAmount[i].Left = 1F + i * 0.625F;
txtFoodWasteAmount[i].Name = "txtFoodWasteAmount" + i;
txtFoodWasteAmount[i].Style = "font-size: 8pt; ";
txtFoodWasteAmount[i].Text = null;
txtFoodWasteAmount[i].Top = 1.13F;
txtFoodWasteAmount[i].Width = 0.625F;
txtFoodWasteAmount[i].OutputFormat = "$#,##0";
this.detail.Controls.Add(txtFoodWasteAmount[i]);
txtFoodWasteAmountChanges[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodWasteAmountChanges[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmountChanges[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodWasteAmountChanges[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmountChanges[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodWasteAmountChanges[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmountChanges[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodWasteAmountChanges[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWasteAmountChanges[i].Height = 0.1875F;
txtFoodWasteAmountChanges[i].Left = 1F + i * 0.625F;
txtFoodWasteAmountChanges[i].Name = "txtFoodWasteAmountChanges" + i;
txtFoodWasteAmountChanges[i].Style = "font-size: 8pt; ";
txtFoodWasteAmountChanges[i].Text = null;
txtFoodWasteAmountChanges[i].Top = 1.88F;
txtFoodWasteAmountChanges[i].Width = 0.625F;
txtFoodWasteAmountChanges[i].OutputFormat = "$#,##0";
this.detail.Controls.Add(txtFoodWasteAmountChanges[i]);
}
//
// txtFoodWastePercentage
//
for (i = 0; i < 12; i++)
{
txtFoodWastePercentagePrior[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodWastePercentagePrior[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentagePrior[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodWastePercentagePrior[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentagePrior[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodWastePercentagePrior[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentagePrior[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodWastePercentagePrior[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentagePrior[i].Height = 0.1875F;
txtFoodWastePercentagePrior[i].Left = 1F + i * 0.625F;
txtFoodWastePercentagePrior[i].Name = "txtFoodWastePercentagePrior" + i;
txtFoodWastePercentagePrior[i].Style = "font-size: 8pt; ";
txtFoodWastePercentagePrior[i].Text = null;
txtFoodWastePercentagePrior[i].Top = 0.56F;
txtFoodWastePercentagePrior[i].Width = 0.625F;
txtFoodWastePercentagePrior[i].OutputFormat = "#,##0.##%";
this.detail.Controls.Add(txtFoodWastePercentagePrior[i]);
txtFoodWastePercentage[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodWastePercentage[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentage[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodWastePercentage[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentage[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodWastePercentage[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentage[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodWastePercentage[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentage[i].Height = 0.1875F;
txtFoodWastePercentage[i].Left = 1F + i * 0.625F;
txtFoodWastePercentage[i].Name = "txtFoodWastePercentage" + i;
txtFoodWastePercentage[i].Style = "font-size: 8pt; ";
txtFoodWastePercentage[i].Text = null;
txtFoodWastePercentage[i].Top = 1.31F;
txtFoodWastePercentage[i].Width = 0.625F;
txtFoodWastePercentage[i].OutputFormat = "#,##0.##%";
this.detail.Controls.Add(txtFoodWastePercentage[i]);
txtFoodWastePercentageChanges[i].Border.BottomColor = System.Drawing.Color.Black;
txtFoodWastePercentageChanges[i].Border.BottomStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentageChanges[i].Border.LeftColor = System.Drawing.Color.Black;
txtFoodWastePercentageChanges[i].Border.LeftStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentageChanges[i].Border.RightColor = System.Drawing.Color.Black;
txtFoodWastePercentageChanges[i].Border.RightStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentageChanges[i].Border.TopColor = System.Drawing.Color.Black;
txtFoodWastePercentageChanges[i].Border.TopStyle = DataDynamics.ActiveReports.BorderLineStyle.None;
txtFoodWastePercentageChanges[i].Height = 0.1875F;
txtFoodWastePercentageChanges[i].Left = 1F + i * 0.625F;
txtFoodWastePercentageChanges[i].Name = "txtFoodWastePercentageChanges" + i;
txtFoodWastePercentageChanges[i].Style = "font-size: 8pt; ";
txtFoodWastePercentageChanges[i].Text = null;
txtFoodWastePercentageChanges[i].Top = 2.06F;
txtFoodWastePercentageChanges[i].Width = 0.625F;
txtFoodWastePercentageChanges[i].OutputFormat = "#,##0.##%";
this.detail.Controls.Add(txtFoodWastePercentageChanges[i]);
}
}
public void ApplyStyle()
{
int i, j;
DataDynamics.ActiveReports.ARControl arc;
#region Apply Style on Report
//设置Margins.Left和Margins.Right，使报表内容居中
if (this.PageSettings.Orientation.Equals(PageOrientation.Landscape))
{
this.PageSettings.Margins.Left = (this.PageSettings.PaperHeight - this.PrintWidth) / 2;
}
else
{
this.PageSettings.Margins.Left = (this.PageSettings.PaperWidth - this.PrintWidth) / 2;
}
this.PageSettings.Margins.Right = this.PageSettings.Margins.Left;
for (j = 0; j < this.Sections.Count; j++)
{
for (i = 0; i < this.Sections[j].Controls.Count; i++)
{
arc = (DataDynamics.ActiveReports.ARControl) this.Sections[j].Controls[i];
if (arc is DataDynamics.ActiveReports.TextBox)
{
DataDynamics.ActiveReports.TextBox tb = (DataDynamics.ActiveReports.TextBox)arc;
switch (tb.ClassName)
{
case "Heading1":
tb.Font = ftHeading1;
break;
case "Heading2":
tb.Font = ftHeading2;
break;
case "Heading3":
tb.Font = ftHeading3;
break;
case "Normal":
tb.Font = ftNormal;
break;
}
}
else if (arc is DataDynamics.ActiveReports.Label)
{
DataDynamics.ActiveReports.Label lb = (DataDynamics.ActiveReports.Label)arc;
switch (lb.ClassName)
{
case "Heading1":
lb.Font = ftHeading1;
//设置Heading1居中
lb.Left = 0;
lb.Top = 0;
if (this.PageSettings.Orientation.Equals(PageOrientation.Landscape))
{
lb.Width = this.PageSettings.PaperHeight - this.PageSettings.Margins.Left - this.PageSettings.Margins.Right;
}
else
{
lb.Width = this.PageSettings.PaperWidth - this.PageSettings.Margins.Left - this.PageSettings.Margins.Right;
}
lb.Alignment = TextAlignment.Center;
break;
case "Heading2":
lb.Font = ftHeading2;
break;
case "Heading3":
lb.Font = ftHeading3;
break;
case "Normal":
lb.Font = ftNormal;
break;
}
}
}
}
#endregion
}
public void InitializeReport()
{
this.LoadLayout(this.GetType(), "Reports.rptFDICTraining.rpx");
this.ds = ((DataDynamics.ActiveReports.DataSources.OleDBDataSource)(this.DataSource));
this.ReportHeader = ((DataDynamics.ActiveReports.ReportHeader)(this.Sections["ReportHeader"]));
this.PageHeader = ((DataDynamics.ActiveReports.PageHeader)(this.Sections["PageHeader"]));
this.GroupHeader1 = ((DataDynamics.ActiveReports.GroupHeader)(this.Sections["GroupHeader1"]));
this.Detail = ((DataDynamics.ActiveReports.Detail)(this.Sections["Detail"]));
this.GroupFooter1 = ((DataDynamics.ActiveReports.GroupFooter)(this.Sections["GroupFooter1"]));
this.PageFooter = ((DataDynamics.ActiveReports.PageFooter)(this.Sections["PageFooter"]));
this.ReportFooter = ((DataDynamics.ActiveReports.ReportFooter)(this.Sections["ReportFooter"]));
this.Label57 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[0]));
this.Label58 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[1]));
this.Label59 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[2]));
this.Label60 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[3]));
this.Label61 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[4]));
this.Label62 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[5]));
this.Label63 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[6]));
this.Label64 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[7]));
this.Line3 = ((DataDynamics.ActiveReports.Line)(this.ReportHeader.Controls[8]));
this.Label65 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[9]));
this.Label66 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[10]));
this.Label67 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[11]));
this.Label68 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[12]));
this.Label69 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[13]));
this.Label70 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[14]));
this.Label71 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[15]));
this.Label72 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[16]));
this.Label73 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[17]));
this.Label74 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[18]));
this.Label75 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[19]));
this.Label76 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[20]));
this.Label77 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[21]));
this.Label78 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[22]));
this.Label79 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[23]));
this.Label80 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[24]));
this.Label81 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[25]));
this.Label82 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[26]));
this.Label83 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[27]));
this.Label84 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[28]));
this.Label85 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[29]));
this.Label86 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[30]));
this.TextBox9 = ((DataDynamics.ActiveReports.TextBox)(this.ReportHeader.Controls[31]));
this.TextBox10 = ((DataDynamics.ActiveReports.TextBox)(this.ReportHeader.Controls[32]));
this.Label87 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[33]));
this.Label88 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[34]));
this.Label89 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[35]));
this.Label90 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[36]));
this.Label91 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[37]));
this.Line4 = ((DataDynamics.ActiveReports.Line)(this.ReportHeader.Controls[38]));
this.Label92 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[39]));
this.Label93 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[40]));
this.Label94 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[41]));
this.Label95 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[42]));
this.Label96 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[43]));
this.Label97 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[44]));
this.Label98 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[45]));
this.Label99 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[46]));
this.Label100 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[47]));
this.Label101 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[48]));
this.Label102 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[49]));
this.Label103 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[50]));
this.Label104 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[51]));
this.Label105 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[52]));
this.Label106 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[53]));
this.Label107 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[54]));
this.Label108 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[55]));
this.Label109 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[56]));
this.Label110 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[57]));
this.Label111 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[58]));
this.Label2 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[59]));
this.Label1 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[60]));
this.Label14 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[61]));
this.Label15 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[62]));
this.Label16 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[63]));
this.Label17 = ((DataDynamics.ActiveReports.Label)(this.ReportHeader.Controls[64]));
this.Picture1 = ((DataDynamics.ActiveReports.Picture)(this.ReportHeader.Controls[65]));
this.Picture2 = ((DataDynamics.ActiveReports.Picture)(this.ReportHeader.Controls[66]));
this.Label4 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[0]));
this.Label = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[1]));
this.Label3 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[2]));
this.Label6 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[3]));
this.Label7 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[4]));
this.Label8 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[5]));
this.Label9 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[6]));
this.Label10 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[7]));
this.Label11 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[8]));
this.Label12 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[9]));
this.Label13 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[10]));
this.Line = ((DataDynamics.ActiveReports.Line)(this.PageHeader.Controls[11]));
this.Label18 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[12]));
this.Label19 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[13]));
this.Picture = ((DataDynamics.ActiveReports.Picture)(this.PageHeader.Controls[14]));
this.Picture3 = ((DataDynamics.ActiveReports.Picture)(this.PageHeader.Controls[15]));
this.Label46 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[0]));
this.Label47 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[1]));
this.Label48 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[2]));
this.Label49 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[3]));
this.Label5 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[4]));
this.TextBox = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[0]));
this.TextBox1 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[1]));
this.TextBox2 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[2]));
this.TextBox3 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[3]));
this.TextBox7 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[4]));
this.Line1 = ((DataDynamics.ActiveReports.Line)(this.GroupFooter1.Controls[0]));
this.Label50 = ((DataDynamics.ActiveReports.Label)(this.GroupFooter1.Controls[1]));
this.TextBox4 = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[2]));
this.TextBox5 = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[3]));
this.TextBox6 = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[4]));
}
public void InitializeReport()
{
this.LoadLayout(this.GetType(), "CBSolutions.ETH.Web.GMGRadio.creditnotes.rptInvoiceNL_CN.rpx");
this.PageHeader = ((DataDynamics.ActiveReports.PageHeader)(this.Sections["PageHeader"]));
this.GroupHeader1 = ((DataDynamics.ActiveReports.GroupHeader)(this.Sections["GroupHeader1"]));
this.Detail = ((DataDynamics.ActiveReports.Detail)(this.Sections["Detail"]));
this.GroupFooter1 = ((DataDynamics.ActiveReports.GroupFooter)(this.Sections["GroupFooter1"]));
this.PageFooter = ((DataDynamics.ActiveReports.PageFooter)(this.Sections["PageFooter"]));
this.Label23 = ((DataDynamics.ActiveReports.Label)(this.PageHeader.Controls[0]));
this.Shape1 = ((DataDynamics.ActiveReports.Shape)(this.GroupHeader1.Controls[0]));
this.TextBox1 = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[1]));
this.TextBox2 = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[2]));
this.TextBox3 = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[3]));
this.Label1 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[4]));
this.Label2 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[5]));
this.Label3 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[6]));
this.Label5 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[7]));
this.Label6 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[8]));
this.Label8 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[9]));
this.Label9 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[10]));
this.TextBox6 = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[11]));
this.TextBox7 = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[12]));
this.TextBox8 = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[13]));
this.TextBox9 = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[14]));
this.Label10 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[15]));
this.Label11 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[16]));
this.Label13 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[17]));
this.Label15 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[18]));
this.Label16 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[19]));
this.Label17 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[20]));
this.Label18 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[21]));
this.Label19 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[22]));
this.Label20 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[23]));
this.Label21 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[24]));
this.TextBox19 = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[25]));
this.TextBox20 = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[26]));
this.TextBox21 = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[27]));
this.Label22 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[28]));
this.Label27 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[29]));
this.TextBox25 = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[30]));
this.Label28 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[31]));
this.Label29 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[32]));
this.Label30 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[33]));
this.Label32 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[34]));
this.txtAssociatedInvoiceNo = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[35]));
this.lblSecondDisc = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[36]));
this.lblSettlementDay = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[37]));
this.txtSettlementDay = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[38]));
this.lblOverallDiscount = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[39]));
this.txtOverallDiscount = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[40]));
this.lblBuyerCompany = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[41]));
this.txtBuyerCompany = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[42]));
this.lblSupplierCompany = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[43]));
this.txtSupplierCompany = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[44]));
this.txtCustomerContact = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[45]));
this.lblCustomerContact = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[46]));
this.lblInvoiceName = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[47]));
this.txtInvoiceName = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[48]));
this.lblSecondSettlementDays = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[49]));
this.txtSecondSettlementDays = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[50]));
this.Label73 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[51]));
this.txtSettlementDiscount2 = ((DataDynamics.ActiveReports.TextBox)(this.GroupHeader1.Controls[52]));
this.Label74 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[53]));
this.lblPaymentDate = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[54]));
this.lblPaymentMethod = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[55]));
this.txtPaymentDate = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[56]));
this.txtPaymentMethod = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[57]));
this.lblDiscountGiven = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[58]));
this.txtDiscountGiven = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[59]));
this.Line3 = ((DataDynamics.ActiveReports.Line)(this.GroupHeader1.Controls[60]));
this.Line4 = ((DataDynamics.ActiveReports.Line)(this.GroupHeader1.Controls[61]));
this.Label76 = ((DataDynamics.ActiveReports.Label)(this.GroupHeader1.Controls[62]));
this.TextBox10 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[0]));
this.TextBox12 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[1]));
this.TextBox13 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[2]));
this.TextBox15 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[3]));
this.TextBox16 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[4]));
this.TextBox17 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[5]));
this.TextBox18 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[6]));
this.TextBox26 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[7]));
this.TextBox27 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[8]));
this.TextBox28 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[9]));
this.txtSecondDiscount = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[10]));
this.TextBox29 = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[11]));
this.txtColor = ((DataDynamics.ActiveReports.TextBox)(this.Detail.Controls[12]));
this.Label24 = ((DataDynamics.ActiveReports.Label)(this.GroupFooter1.Controls[0]));
this.TextBox22 = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[1]));
this.TextBox23 = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[2]));
this.Label25 = ((DataDynamics.ActiveReports.Label)(this.GroupFooter1.Controls[3]));
this.Label26 = ((DataDynamics.ActiveReports.Label)(this.GroupFooter1.Controls[4]));
this.TextBox24 = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[5]));
this.Line2 = ((DataDynamics.ActiveReports.Line)(this.GroupFooter1.Controls[6]));
this.lblGBPEquivalentAmount = ((DataDynamics.ActiveReports.Label)(this.GroupFooter1.Controls[7]));
this.tblGBPEquivalentAmount = ((DataDynamics.ActiveReports.TextBox)(this.GroupFooter1.Controls[8]));
this.Label71 = ((DataDynamics.ActiveReports.Label)(this.PageFooter.Controls[0]));
// Attach Report Events
this.DataInitialize += new System.EventHandler(this.rptInvoice_DataInitialize);
this.FetchData += new DataDynamics.ActiveReports.ActiveReport.FetchEventHandler(this.rptInvoice_FetchData);
}