public void FormatHeadings() { PTSProject.clsTraining TrainCL = Container.Resolve <clsTraining>(); if (ViewModel.FirstTime) { return; } ViewModel.sprReport.Row = 4; ViewModel.sprReport.Row2 = ViewModel.sprReport.MaxRows; ViewModel.sprReport.Col = 1; ViewModel.sprReport.Col2 = ViewModel.sprReport.MaxCols; ViewModel.sprReport.BlockMode = true; ViewModel.sprReport.Text = ""; ViewModel.sprReport.BackColor = modGlobal.Shared.WHITE; ViewModel.sprReport.BlockMode = false; //Set colors... //Green ViewModel.sprReport.Row = 4; ViewModel.sprReport.Row2 = ViewModel.sprReport.MaxRows; ViewModel.sprReport.Col = 5; ViewModel.sprReport.Col2 = 6; ViewModel.sprReport.BlockMode = true; ViewModel.sprReport.BackColor = UpgradeHelpers.Helpers.ColorTranslator.FromOle(modGlobal.TrainingGreen); ViewModel.sprReport.BlockMode = false; //Blue ViewModel.sprReport.Row = 4; ViewModel.sprReport.Row2 = ViewModel.sprReport.MaxRows; ViewModel.sprReport.Col = 7; ViewModel.sprReport.Col2 = 9; ViewModel.sprReport.BlockMode = true; ViewModel.sprReport.BackColor = UpgradeHelpers.Helpers.ColorTranslator.FromOle(modGlobal.TrainingBlue); ViewModel.sprReport.BlockMode = false; //Yellow ViewModel.sprReport.Row = 4; ViewModel.sprReport.Row2 = ViewModel.sprReport.MaxRows; ViewModel.sprReport.Col = 10; ViewModel.sprReport.Col2 = 12; ViewModel.sprReport.BlockMode = true; ViewModel.sprReport.BackColor = UpgradeHelpers.Helpers.ColorTranslator.FromOle(modGlobal.TrainingYellow); ViewModel.sprReport.BlockMode = false; //Peach ViewModel.sprReport.Row = 4; ViewModel.sprReport.Row2 = ViewModel.sprReport.MaxRows; ViewModel.sprReport.Col = 13; ViewModel.sprReport.Col2 = 15; ViewModel.sprReport.BlockMode = true; ViewModel.sprReport.BackColor = UpgradeHelpers.Helpers.ColorTranslator.FromOle(modGlobal.TrainingPeach); ViewModel.sprReport.BlockMode = false; string sHeading = ""; sHeading = ViewModel.CurrYear.ToString() + " - "; switch (ViewModel.CurrQuarter) { case 4: sHeading = sHeading + "4th Quarter Report"; break; case 3: sHeading = sHeading + "3rd Quarter Report"; break; case 2: sHeading = sHeading + "2nd Quarter Report"; break; default: sHeading = sHeading + "1st Quarter Report"; break; } ViewModel.sprReport.Row = 2; ViewModel.sprReport.Col = 1; ViewModel.sprReport.Text = sHeading; sHeading = "FCC Minimum Standard Drills For "; if (ViewModel.CurrShift == "") { sHeading = sHeading + "All Shifts"; } else { sHeading = sHeading + "Shift " + ViewModel.CurrShift; } ViewModel.sprReport.Row = 3; ViewModel.sprReport.Col = 1; ViewModel.sprReport.Text = sHeading; ViewModel.sprReport.Row = 5; ViewModel.sprReport.Col = 1; ViewModel.sprReport.Text = "Name"; ViewModel.sprReport.Col = 2; ViewModel.sprReport.Text = "Unit"; ViewModel.sprReport.Col = 3; ViewModel.sprReport.Text = "Shift"; ViewModel.sprReport.Col = 4; ViewModel.sprReport.Text = "Batt"; if (TrainCL.GetTrainingFCCDrillsByYearQuarter(ViewModel.CurrYear, ViewModel.CurrQuarter) != 0) { //continue } else { ViewManager.ShowMessage("Oh No! There are no Training FCC Standard Drills set up for Year/Quarter!", "Training Quarterly Report", UpgradeHelpers.Helpers.BoxButtons.OK); return; } int iCurrRow = 4; int iCurrCol = 5; string sSubHeading = ""; int iReportColumn = 1; while (!TrainCL.TrainingRecord.EOF) { ViewModel.sprReport.Row = iCurrRow; ViewModel.sprReport.Col = iCurrCol; if (sSubHeading == "") { //first time sSubHeading = modGlobal.Clean(TrainCL.TrainingRecord["standard_description"]); ViewModel.sprReport.Text = sSubHeading; //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx iReportColumn = Convert.ToInt32(modGlobal.GetVal(TrainCL.TrainingRecord["report_column"])); ViewModel.sprReport.Row = iCurrRow + 1; ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["description"]); ViewModel.sprReport.Row = iCurrRow + 2; ViewModel.sprReport.Text = iReportColumn.ToString(); iCurrCol++; } else if (sSubHeading == modGlobal.Clean(TrainCL.TrainingRecord["standard_description"])) { ViewModel.sprReport.Row = iCurrRow + 1; //UPGRADE_WARNING: (1068) GetVal(TrainCL.TrainingRecord(report_column)) of type Variant is being forced to double. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx if (iReportColumn == Convert.ToDouble(modGlobal.GetVal(TrainCL.TrainingRecord["report_column"]))) { ViewModel.sprReport.Col = iReportColumn + 4; ViewModel.sprReport.Text = modGlobal.Clean(ViewModel.sprReport.Text) + " / " + modGlobal.Clean(TrainCL.TrainingRecord["description"]); } else { //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx iReportColumn = Convert.ToInt32(modGlobal.GetVal(TrainCL.TrainingRecord["report_column"])); ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["description"]); ViewModel.sprReport.Row = iCurrRow + 2; ViewModel.sprReport.Text = iReportColumn.ToString(); // sprReport.Text = Clean(TrainCL.TrainingRecord("trn_specific_code"]) iCurrCol++; } } else { sSubHeading = modGlobal.Clean(TrainCL.TrainingRecord["standard_description"]); //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to int. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx iReportColumn = Convert.ToInt32(modGlobal.GetVal(TrainCL.TrainingRecord["report_column"])); ViewModel.sprReport.Text = sSubHeading; ViewModel.sprReport.Row = iCurrRow + 1; ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["description"]); ViewModel.sprReport.Row = iCurrRow + 2; ViewModel.sprReport.Text = iReportColumn.ToString(); iCurrCol++; } TrainCL.TrainingRecord.MoveNext(); } ; }