public static void GetJSON(string json) { var data = new ReportModel(json); ResetDefaults(); GenerateHeaderFooters(); for (int k = 0; k < data.GenerateTitleField.Length; k++) { GenerateTextField(data.GenerateTitleField.GetValue(k).ToString(), "=Fields." + data.GenerateDataField.GetValue(k).ToString()); } for (int a = 0; a < data.GroupBy.Length; a++) { GroupBy(data.GroupName.GetValue(a).ToString(), "=Fields." + data.GroupBy.GetValue(a).ToString()); } for (int i = 0; i < data.Filters.Length; i++) { CreateFilterOption(data.Filters.GetValue(i).ToString()); } for (int c = 0; c < data.SumOrCount.Length; c++) { SumOrCount("=Fields." + data.SumOrCount.GetValue(c).ToString().Substring(1, data.SumOrCount.GetValue(c).ToString().Length - 2), data.AggregateType.GetValue(c).ToString(), "Fields." + data.SumOrCount.GetValue(c).ToString().Substring(1, data.SumOrCount.GetValue(c).ToString().Length - 2)); } if (data.AddReportFooterSection == true) { AddReportFooterSection(data); } ChangeSqlString(data.ConnectionString); SqlCommandString = data.SelectCommand; }
public static void AddReportFooterSection(ReportModel data) { var totalBox = new TextBox(); string name = ""; for (int i = 0; i < data.AggregateType.Length; i++) { string typeFlag; string field; typeFlag = data.AggregateType.GetValue(i).ToString(); field = "Fields." + data.SumOrCount.GetValue(i).ToString().Substring(1, data.SumOrCount.GetValue(i).ToString().Length - 2); name = "=Fields." + data.SumOrCount.GetValue(i).ToString().Substring(1, data.SumOrCount.GetValue(i).ToString().Length - 2); int spot = GetDataPosition(name); ReportFooter.Items.Add(FooterHelper(typeFlag,field, spot)); } totalBox = GenerateAttributes(MyCaptionBoxes[0].Location, "Grand Total: ", name, "{0:$#,0.00}"); ReportFooter.Items.Add(totalBox); ReportFooter.Style.BackgroundColor = Color.FromArgb(89, 220, 216); //background color of overall report footer AddReportFooter = true; }