public void FormatReport() { PTSProject.clsTraining TrainCL = Container.Resolve <clsTraining>(); if (ViewModel.FirstTime) { return; } ViewModel.sprReport.Row = 7; 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.BlockMode = false; if (TrainCL.GetTrainingFCCQuarterlyStandardReport(ViewModel.CurrYear, ViewModel.CurrQuarter, ViewModel.CurrShift) != 0) { //continue } else { ViewManager.ShowMessage("There are no Employee/Training Records to report for Year/Quarter!", "Training Quarterly Report", UpgradeHelpers.Helpers.BoxButtons.OK); return; } string sEmployeeName = ""; int iCodeRow = 6; int iCurrRow = 7; int iCurrCol = 1; while (!TrainCL.TrainingRecord.EOF) { ViewModel.sprReport.Row = iCurrRow; ViewModel.sprReport.Col = iCurrCol; if (sEmployeeName == "") { //first time sEmployeeName = modGlobal.Clean(TrainCL.TrainingRecord["name_full"]); ViewModel.sprReport.Text = sEmployeeName; ViewModel.sprReport.Col = iCurrCol + 1; ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]); ViewModel.sprReport.Col = iCurrCol + 2; ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]); ViewModel.sprReport.Col = iCurrCol + 3; ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["battalion_code"]); if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) != "") { ViewModel.sprReport.Row = iCodeRow; for (int i = 5; i <= 18; i++) { ViewModel.sprReport.Col = i; if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) == modGlobal.Clean(ViewModel.sprReport.Text)) { ViewModel.sprReport.Col = i; ViewModel.sprReport.Row = iCurrRow; //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx ViewModel.sprReport.Text = Convert.ToString(modGlobal.GetVal(TrainCL.TrainingRecord["total_occurances"])); break; } } } } else if (sEmployeeName == modGlobal.Clean(TrainCL.TrainingRecord["name_full"])) { if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) != "") { ViewModel.sprReport.Row = iCodeRow; for (int i = 5; i <= 18; i++) { ViewModel.sprReport.Col = i; if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) == modGlobal.Clean(ViewModel.sprReport.Text)) { ViewModel.sprReport.Col = i; ViewModel.sprReport.Row = iCurrRow; //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx ViewModel.sprReport.Text = Convert.ToString(modGlobal.GetVal(TrainCL.TrainingRecord["total_occurances"])); break; } } } } else { iCurrRow++; ViewModel.sprReport.Row = iCurrRow; sEmployeeName = modGlobal.Clean(TrainCL.TrainingRecord["name_full"]); ViewModel.sprReport.Text = sEmployeeName; ViewModel.sprReport.Col = iCurrCol + 1; ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["unit_code"]); ViewModel.sprReport.Col = iCurrCol + 2; ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["shift_code"]); ViewModel.sprReport.Col = iCurrCol + 3; ViewModel.sprReport.Text = modGlobal.Clean(TrainCL.TrainingRecord["battalion_code"]); if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) != "") { ViewModel.sprReport.Row = iCodeRow; for (int i = 5; i <= 18; i++) { ViewModel.sprReport.Col = i; if (modGlobal.Clean(TrainCL.TrainingRecord["report_column"]) == modGlobal.Clean(ViewModel.sprReport.Text)) { ViewModel.sprReport.Col = i; ViewModel.sprReport.Row = iCurrRow; //UPGRADE_WARNING: (1068) GetVal() of type Variant is being forced to string. More Information: http://www.vbtonet.com/ewis/ewi1068.aspx ViewModel.sprReport.Text = Convert.ToString(modGlobal.GetVal(TrainCL.TrainingRecord["total_occurances"])); break; } } } } TrainCL.TrainingRecord.MoveNext(); } ; }