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;
}
