Telerik Forums
Reporting Forum
1 answer
115 views

Hi,
Based on samples I was able to get sort on Column_Click.Still having some issues. After table sorted:
1. sorted report opens in the second page and there is a back button
2. table doesn't have CSS;it lost Chart and Crosstab control

If I click on BACK button, there is initial report view with unsorted column, CSS, chart and Crosstab

I really appreciated any help.I need to sort based on any column click.
My report has 3 controls: table, crosstab and chart for each student.

I think the best should be Detail section sort. Still working on that.
Thank you



namespace report
{
    partial class FAIRSchoolK2
    {
        #region Component Designer generated code
        /// <summary>
        /// Required method for telerik Reporting designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            Telerik.Reporting.NavigateToReportAction navigateToReportAction1 = new Telerik.Reporting.NavigateToReportAction();
            Telerik.Reporting.Drawing.FormattingRule formattingRule1 = new Telerik.Reporting.Drawing.FormattingRule();
            Telerik.Reporting.NavigateToReportAction navigateToReportAction2 = new Telerik.Reporting.NavigateToReportAction();
            Telerik.Reporting.Drawing.FormattingRule formattingRule2 = new Telerik.Reporting.Drawing.FormattingRule();
            Telerik.Reporting.NavigateToReportAction navigateToReportAction3 = new Telerik.Reporting.NavigateToReportAction();
            Telerik.Reporting.TableGroup tableGroup6 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup7 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup8 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup9 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup10 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup11 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup12 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup13 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup14 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup15 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup16 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup17 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup18 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup1 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup2 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup3 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup4 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.TableGroup tableGroup5 = new Telerik.Reporting.TableGroup();
            Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter();
            Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter();
            Telerik.Reporting.ReportParameter reportParameter3 = new Telerik.Reporting.ReportParameter();
            Telerik.Reporting.ReportParameter reportParameter4 = new Telerik.Reporting.ReportParameter();
            Telerik.Reporting.ReportParameter reportParameter5 = new Telerik.Reporting.ReportParameter();
            Telerik.Reporting.ReportParameter reportParameter6 = new Telerik.Reporting.ReportParameter();
            Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule();
            Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule();
            Telerik.Reporting.Drawing.DescendantSelector descendantSelector1 = new Telerik.Reporting.Drawing.DescendantSelector();
            Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule();
            Telerik.Reporting.Drawing.DescendantSelector descendantSelector2 = new Telerik.Reporting.Drawing.DescendantSelector();
            this.textBox1 = new Telerik.Reporting.TextBox();
            this.textBox2 = new Telerik.Reporting.TextBox();
            this.textBox3 = new Telerik.Reporting.TextBox();
            this.textBox4 = new Telerik.Reporting.TextBox();
            this.textBox5 = new Telerik.Reporting.TextBox();
            this.textBox6 = new Telerik.Reporting.TextBox();
            this.textBox7 = new Telerik.Reporting.TextBox();
            this.textBox8 = new Telerik.Reporting.TextBox();
            this.textBox25 = new Telerik.Reporting.TextBox();
            this.textBox29 = new Telerik.Reporting.TextBox();
            this.pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection();
            this.detail = new Telerik.Reporting.DetailSection();
            this.table1 = new Telerik.Reporting.Table();
            this.textBox9 = new Telerik.Reporting.TextBox();
            this.textBox10 = new Telerik.Reporting.TextBox();
            this.textBox11 = new Telerik.Reporting.TextBox();
            this.textBox12 = new Telerik.Reporting.TextBox();
            this.textBox13 = new Telerik.Reporting.TextBox();
            this.textBox14 = new Telerik.Reporting.TextBox();
            this.textBox15 = new Telerik.Reporting.TextBox();
            this.textBox16 = new Telerik.Reporting.TextBox();
            this.textBox17 = new Telerik.Reporting.TextBox();
            this.textBox26 = new Telerik.Reporting.TextBox();
            this.chart1 = new Telerik.Reporting.Chart();
            this.textBox28 = new Telerik.Reporting.TextBox();
            this.pageFooterSection1 = new Telerik.Reporting.PageFooterSection();
            this.crosstab2 = new Telerik.Reporting.Crosstab();
            this.textBox22 = new Telerik.Reporting.TextBox();
            this.textBox23 = new Telerik.Reporting.TextBox();
            this.textBox24 = new Telerik.Reporting.TextBox();
            this.textBox19 = new Telerik.Reporting.TextBox();
            this.textBox20 = new Telerik.Reporting.TextBox();
            this.textBox21 = new Telerik.Reporting.TextBox();
            this.textBox27 = new Telerik.Reporting.TextBox();
            this.textBox30 = new Telerik.Reporting.TextBox();
            ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
            //
            // textBox1
            //
            navigateToReportAction1.Parameters.Add(new Telerik.Reporting.Parameter("SchoolYear", "=Parameters.SchoolYear.Value"));
            navigateToReportAction1.Parameters.Add(new Telerik.Reporting.Parameter("District", "=Parameters.District.Value"));
            navigateToReportAction1.Parameters.Add(new Telerik.Reporting.Parameter("School", "=Parameters.School.Value"));
            navigateToReportAction1.Parameters.Add(new Telerik.Reporting.Parameter("Grade", "=Parameters.Grade.Value"));
            navigateToReportAction1.Parameters.Add(new Telerik.Reporting.Parameter("SortBy", "STUDENT_LAST_NAME"));
            navigateToReportAction1.Parameters.Add(new Telerik.Reporting.Parameter("SortDirection", "=ToggleSortDirection(ReportItem, \"STUDENT_LAST_NAME\")"));
            navigateToReportAction1.ReportDocumentType = "report.Report1, report, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null";
            this.textBox1.Action = navigateToReportAction1;
            formattingRule1.Filters.AddRange(new Telerik.Reporting.Data.Filter[] {
            new Telerik.Reporting.Data.Filter("= Parameters.SortBy.Value", Telerik.Reporting.Data.FilterOperator.Equal, "STUDENT_LAST_NAME")});
            this.textBox1.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
            formattingRule1});
            this.textBox1.Name = "textBox1";
            this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.76875227689743042D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox1.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
            this.textBox1.StyleName = "Normal.TableHeader";
            this.textBox1.Value = "STUDENT_LAST_NAME{IIf(Parameters.SortBy.Value <> \"STUDENT_LAST_NAME\", \"\", IIf(Par" +
    "ameters.SortDirection.Value = \"Ascending\", \"Asc\", \"Desc\"))}";
            //
            // textBox2
            //
            navigateToReportAction2.Parameters.Add(new Telerik.Reporting.Parameter("SchoolYear", "=Parameters.SchoolYear.Value"));
            navigateToReportAction2.Parameters.Add(new Telerik.Reporting.Parameter("District", "=Parameters.District.Value"));
            navigateToReportAction2.Parameters.Add(new Telerik.Reporting.Parameter("School", "=Parameters.School.Value"));
            navigateToReportAction2.Parameters.Add(new Telerik.Reporting.Parameter("Grade", "=Parameters.Grade.Value"));
            navigateToReportAction2.Parameters.Add(new Telerik.Reporting.Parameter("SortBy", "STUDENT_NUMBER"));
            navigateToReportAction2.Parameters.Add(new Telerik.Reporting.Parameter("SortDirection", "=ToggleSortDirection(ReportItem, \"STUDENT_NUMBER\")"));
            navigateToReportAction2.ReportDocumentType = "report.Report1, report, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null";
            this.textBox2.Action = navigateToReportAction2;
            formattingRule2.Filters.AddRange(new Telerik.Reporting.Data.Filter[] {
            new Telerik.Reporting.Data.Filter("= Parameters.SortBy.Value", Telerik.Reporting.Data.FilterOperator.Equal, "STUDENT_NUMBER")});
            this.textBox2.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
            formattingRule2});
            this.textBox2.Name = "textBox2";
            this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.45625084638595581D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox2.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
            this.textBox2.StyleName = "Normal.TableHeader";
            this.textBox2.Value = "STUDENT_NUMBER{IIf(Parameters.SortBy.Value <> \"STUDENT_NUMBER\", \"\", IIf(Parameter" +
    "s.SortDirection.Value = \"Ascending\", \"Asc\", \"Desc\"))}";
            //
            // textBox3
            //
            navigateToReportAction3.Parameters.Add(new Telerik.Reporting.Parameter("SchoolYear", "=Parameters.SchoolYear.Value"));
            navigateToReportAction3.Parameters.Add(new Telerik.Reporting.Parameter("District", "=Parameters.District.Value"));
            navigateToReportAction3.Parameters.Add(new Telerik.Reporting.Parameter("School", "=Parameters.School.Value"));
            navigateToReportAction3.Parameters.Add(new Telerik.Reporting.Parameter("Grade", "=Parameters.Grade.Value"));
            navigateToReportAction3.Parameters.Add(new Telerik.Reporting.Parameter("SortBy", "SUCCESS_PROB_AP1"));
            navigateToReportAction3.Parameters.Add(new Telerik.Reporting.Parameter("SortDirection", "=ToggleSortDirection(ReportItem, \"SUCCESS_PROB_AP1\")"));
            navigateToReportAction3.ReportDocumentType = "report.Report1, report, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null";
            this.textBox3.Action = navigateToReportAction3;
            this.textBox3.Name = "textBox3";
            this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.560417652130127D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox3.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
            this.textBox3.StyleName = "Normal.TableHeader";
            this.textBox3.Value = "SUCCESS_PROB_AP1";
            //
            // textBox4
            //
            this.textBox4.Name = "textBox4";
            this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.19583407044410706D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox4.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
            this.textBox4.StyleName = "Normal.TableHeader";
            this.textBox4.Value = "SUCCESS_PROB_AP2";
            //
            // textBox5
            //
            this.textBox5.Name = "textBox5";
            this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.36250042915344238D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox5.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
            this.textBox5.StyleName = "Normal.TableHeader";
            this.textBox5.Value = "GROWTH_AP1_AP2";
            //
            // textBox6
            //
            this.textBox6.Name = "textBox6";
            this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.30000028014183044D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox6.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
            this.textBox6.StyleName = "Normal.TableHeader";
            this.textBox6.Value = "SUCCESS_PROB_AP3";
            //
            // textBox7
            //
            this.textBox7.Name = "textBox7";
            this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.31041678786277771D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox7.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
            this.textBox7.StyleName = "Normal.TableHeader";
            this.textBox7.Value = "GROWTH_AP2_AP3";
            //
            // textBox8
            //
            this.textBox8.Name = "textBox8";
            this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.32083335518836975D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox8.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
            this.textBox8.StyleName = "Normal.TableHeader";
            this.textBox8.Value = "GROWTH_AP1_AP3";
            //
            // textBox25
            //
            this.textBox25.Name = "textBox25";
            this.textBox25.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.30208447575569153D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000003278255463D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox25.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
            this.textBox25.StyleName = "Normal.TableHeader";
            this.textBox25.Value = "EEEEE_STUDENT_ID";
            //
            // textBox29
            //
            this.textBox29.Name = "textBox29";
            this.textBox29.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.4166667461395264D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000001788139343D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox29.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
            this.textBox29.StyleName = "Normal.TableHeader";
            //
            // pageHeaderSection1
            //
            this.pageHeaderSection1.Height = new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch);
            this.pageHeaderSection1.Name = "pageHeaderSection1";
            //
            // detail
            //
            this.detail.Height = new Telerik.Reporting.Drawing.Unit(1.6104167699813843D, Telerik.Reporting.Drawing.UnitType.Inch);
            this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.table1,
            this.textBox28});
            this.detail.Name = "detail";
            //
            // table1
            //
            this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.7687523365020752D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.4562506377696991D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.56041806936264038D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.19583414494991303D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.36250051856040955D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.30000045895576477D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.3104170560836792D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.32083398103713989D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.30208450555801392D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(2.4166667461395264D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.table1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(new Telerik.Reporting.Drawing.Unit(0.61666661500930786D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.table1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(new Telerik.Reporting.Drawing.Unit(0.69374990463256836D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.table1.Body.SetCellContent(0, 0, this.textBox9);
            this.table1.Body.SetCellContent(0, 1, this.textBox10);
            this.table1.Body.SetCellContent(0, 2, this.textBox11);
            this.table1.Body.SetCellContent(0, 3, this.textBox12);
            this.table1.Body.SetCellContent(0, 4, this.textBox13);
            this.table1.Body.SetCellContent(0, 5, this.textBox14);
            this.table1.Body.SetCellContent(0, 6, this.textBox15);
            this.table1.Body.SetCellContent(0, 7, this.textBox16);
            this.table1.Body.SetCellContent(1, 0, this.textBox17);
            this.table1.Body.SetCellContent(0, 8, this.textBox26);
            this.table1.Body.SetCellContent(1, 1, this.crosstab2, 1, 8);
            this.table1.Body.SetCellContent(0, 9, this.chart1, 2, 1);
            tableGroup6.ReportItem = this.textBox1;
            tableGroup7.ReportItem = this.textBox2;
            tableGroup8.ReportItem = this.textBox3;
            tableGroup9.ReportItem = this.textBox4;
            tableGroup10.ReportItem = this.textBox5;
            tableGroup11.ReportItem = this.textBox6;
            tableGroup12.ReportItem = this.textBox7;
            tableGroup13.ReportItem = this.textBox8;
            tableGroup14.Name = "Group3";
            tableGroup14.ReportItem = this.textBox25;
            tableGroup15.Name = "Group4";
            tableGroup15.ReportItem = this.textBox29;
            this.table1.ColumnGroups.Add(tableGroup6);
            this.table1.ColumnGroups.Add(tableGroup7);
            this.table1.ColumnGroups.Add(tableGroup8);
            this.table1.ColumnGroups.Add(tableGroup9);
            this.table1.ColumnGroups.Add(tableGroup10);
            this.table1.ColumnGroups.Add(tableGroup11);
            this.table1.ColumnGroups.Add(tableGroup12);
            this.table1.ColumnGroups.Add(tableGroup13);
            this.table1.ColumnGroups.Add(tableGroup14);
            this.table1.ColumnGroups.Add(tableGroup15);
            this.table1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.textBox9,
            this.textBox10,
            this.textBox11,
            this.textBox12,
            this.textBox13,
            this.textBox14,
            this.textBox15,
            this.textBox16,
            this.textBox17,
            this.textBox26,
            this.textBox1,
            this.textBox2,
            this.textBox3,
            this.textBox4,
            this.textBox5,
            this.textBox6,
            this.textBox7,
            this.textBox8,
            this.textBox25,
            this.textBox29,
            this.crosstab2,
            this.chart1});
            this.table1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099999986588954926D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.table1.Name = "table1";
            tableGroup17.Name = "Group1";
            tableGroup18.Name = "Group2";
            tableGroup16.ChildGroups.Add(tableGroup17);
            tableGroup16.ChildGroups.Add(tableGroup18);
            tableGroup16.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("")});
            tableGroup16.Name = "Detail";
            this.table1.RowGroups.Add(tableGroup16);
            this.table1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(5.9937586784362793D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.5104165077209473D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.table1.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] {
            new Telerik.Reporting.Data.Sorting("= Fields(Parameters.SortBy.Value)", Telerik.Reporting.Data.SortDirection.Asc)});
            this.table1.StyleName = "Normal.TableNormal";
            //
            // textBox9
            //
            this.textBox9.Name = "textBox9";
            this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.76875221729278564D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.61666667461395264D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox9.StyleName = "Normal.TableBody";
            this.textBox9.Value = "=Fields.STUDENT_LAST_NAME";
            //
            // textBox10
            //
            this.textBox10.Name = "textBox10";
            this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.45625081658363342D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.61666667461395264D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox10.StyleName = "Normal.TableBody";
            this.textBox10.Value = "=Fields.STUDENT_NUMBER";
            //
            // textBox11
            //
            this.textBox11.Name = "textBox11";
            this.textBox11.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.56041812896728516D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.61666667461395264D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox11.StyleName = "Normal.TableBody";
            this.textBox11.Value = "=Fields.SUCCESS_PROB_AP1";
            //
            // textBox12
            //
            this.textBox12.Name = "textBox12";
            this.textBox12.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.19583415985107422D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.61666667461395264D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox12.StyleName = "Normal.TableBody";
            this.textBox12.Value = "=Fields.SUCCESS_PROB_AP2";
            //
            // textBox13
            //
            this.textBox13.Name = "textBox13";
            this.textBox13.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.36250048875808716D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.61666667461395264D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox13.StyleName = "Normal.TableBody";
            this.textBox13.Value = "=Fields.GROWTH_AP1_AP2";
            //
            // textBox14
            //
            this.textBox14.Name = "textBox14";
            this.textBox14.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.30000045895576477D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.61666667461395264D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox14.StyleName = "Normal.TableBody";
            this.textBox14.Value = "=Fields.SUCCESS_PROB_AP3";
            //
            // textBox15
            //
            this.textBox15.Name = "textBox15";
            this.textBox15.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.31041714549064636D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.61666667461395264D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox15.StyleName = "Normal.TableBody";
            this.textBox15.Value = "=Fields.GROWTH_AP2_AP3";
            //
            // textBox16
            //
            this.textBox16.Name = "textBox16";
            this.textBox16.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.3208339512348175D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.61666667461395264D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox16.StyleName = "Normal.TableBody";
            this.textBox16.Value = "=Fields.GROWTH_AP1_AP3";
            //
            // textBox17
            //
            this.textBox17.Name = "textBox17";
            this.textBox17.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7687523365020752D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.69374996423721313D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox17.StyleName = "Normal.TableBody";
            //
            // textBox26
            //
            this.textBox26.Name = "textBox26";
            this.textBox26.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.30208447575569153D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.61666667461395264D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox26.StyleName = "Normal.TableBody";
            this.textBox26.Value = "=Fields.EEEEE_STUDENT_ID";
            //
            // chart1
            //
            this.chart1.BitmapResolution = 96F;
            this.chart1.ChartTitle.Appearance.Visible = false;
            this.chart1.ChartTitle.Visible = false;
            this.chart1.ImageFormat = System.Drawing.Imaging.ImageFormat.Emf;
            this.chart1.Legend.Appearance.Visible = false;
            this.chart1.Legend.Visible = false;
            this.chart1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(6.6599998474121094D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.27000001072883606D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.chart1.Name = "chart1";
            this.chart1.PlotArea.EmptySeriesMessage.Appearance.Visible = true;
            this.chart1.PlotArea.EmptySeriesMessage.Visible = true;
            this.chart1.SeriesOrientation = Telerik.Reporting.Charting.ChartSeriesOrientation.Horizontal;
            this.chart1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.4166667461395264D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.310416579246521D, Telerik.Reporting.Drawing.UnitType.Inch));
            //
            // textBox28
            //
            this.textBox28.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(6.2333736419677734D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox28.Name = "textBox28";
            this.textBox28.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.16658735275268555D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.099763475358486176D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox28.Style.Visible = false;
            this.textBox28.Value = "=Fields.EEEEE_STUDENT_ID";
            //
            // pageFooterSection1
            //
            this.pageFooterSection1.Height = new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch);
            this.pageFooterSection1.Name = "pageFooterSection1";
            //
            // crosstab2
            //
            this.crosstab2.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.7205778956413269D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.crosstab2.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.7205778956413269D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.crosstab2.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(new Telerik.Reporting.Drawing.Unit(0.72292381525039673D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.crosstab2.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(new Telerik.Reporting.Drawing.Unit(0.2878086268901825D, Telerik.Reporting.Drawing.UnitType.Inch)));
            this.crosstab2.Body.SetCellContent(0, 0, this.textBox22);
            this.crosstab2.Body.SetCellContent(0, 1, this.textBox23);
            this.crosstab2.Body.SetCellContent(0, 2, this.textBox24);
            tableGroup1.ReportItem = this.textBox19;
            tableGroup2.ReportItem = this.textBox20;
            tableGroup3.ReportItem = this.textBox21;
            this.crosstab2.ColumnGroups.Add(tableGroup1);
            this.crosstab2.ColumnGroups.Add(tableGroup2);
            this.crosstab2.ColumnGroups.Add(tableGroup3);
            this.crosstab2.Corner.SetCellContent(0, 0, this.textBox27);
            this.crosstab2.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.textBox22,
            this.textBox23,
            this.textBox24,
            this.textBox19,
            this.textBox20,
            this.textBox21,
            this.textBox27,
            this.textBox30});
            this.crosstab2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.crosstab2.Name = "crosstab2";
            tableGroup5.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("")});
            tableGroup5.Name = "Detail";
            tableGroup4.ChildGroups.Add(tableGroup5);
            tableGroup4.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("=Fields.ASSESSMENT")});
            tableGroup4.Name = "ASSESSMENT";
            tableGroup4.ReportItem = this.textBox30;
            tableGroup4.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] {
            new Telerik.Reporting.Data.Sorting("=Fields.ASSESSMENT", Telerik.Reporting.Data.SortDirection.Asc)});
            this.crosstab2.RowGroups.Add(tableGroup4);
            this.crosstab2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.8083393573760986D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.69374996423721313D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.crosstab2.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(210)))), ((int)(((byte)(209)))), ((int)(((byte)(214)))));
            this.crosstab2.Style.BorderColor.Top = System.Drawing.Color.FromArgb(((int)(((byte)(210)))), ((int)(((byte)(209)))), ((int)(((byte)(214)))));
            this.crosstab2.Style.Font.Name = "Arial";
            this.crosstab2.StyleName = "CrosstabData";
            //
            // textBox22
            //
            this.textBox22.Name = "textBox22";
            this.textBox22.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7205778956413269D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2878086268901825D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox22.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(210)))), ((int)(((byte)(209)))), ((int)(((byte)(214)))));
            this.textBox22.Style.Font.Name = "Arial";
            this.textBox22.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point);
            this.textBox22.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
            this.textBox22.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
            this.textBox22.StyleName = "CrosstabData";
            this.textBox22.Value = "=Fields.K2_COMP_FLUENCY";
            //
            // textBox23
            //
            this.textBox23.Name = "textBox23";
            this.textBox23.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7205778956413269D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2878086268901825D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox23.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(210)))), ((int)(((byte)(209)))), ((int)(((byte)(214)))));
            this.textBox23.Style.Font.Name = "Arial";
            this.textBox23.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point);
            this.textBox23.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
            this.textBox23.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
            this.textBox23.StyleName = "CrosstabData";
            this.textBox23.Value = "=Fields.K2_COMP_PERCENT_ACCURACY";
            //
            // textBox24
            //
            this.textBox24.Name = "textBox24";
            this.textBox24.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.72292381525039673D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2878086268901825D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox24.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(210)))), ((int)(((byte)(209)))), ((int)(((byte)(214)))));
            this.textBox24.Style.Font.Name = "Arial";
            this.textBox24.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point);
            this.textBox24.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
            this.textBox24.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
            this.textBox24.StyleName = "CrosstabData";
            this.textBox24.Value = "=Fields.G1_2_VOCAB_PERCENTILE";
            //
            // textBox19
            //
            this.textBox19.Name = "textBox19";
            this.textBox19.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7205778956413269D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.40594133734703064D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox19.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(238)))), ((int)(((byte)(238)))), ((int)(((byte)(238)))));
            this.textBox19.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(204)))), ((int)(((byte)(204)))), ((int)(((byte)(204)))));
            this.textBox19.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(97)))), ((int)(((byte)(97)))), ((int)(((byte)(97)))));
            this.textBox19.Style.Font.Name = "Arial";
            this.textBox19.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
            this.textBox19.StyleName = "CrosstabHeaderLabel";
            this.textBox19.Value = "Reading Comp Fluency (WCPM)";
            //
            // textBox20
            //
            this.textBox20.Name = "textBox20";
            this.textBox20.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7205778956413269D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.40594133734703064D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox20.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(238)))), ((int)(((byte)(238)))), ((int)(((byte)(238)))));
            this.textBox20.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(204)))), ((int)(((byte)(204)))), ((int)(((byte)(204)))));
            this.textBox20.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(97)))), ((int)(((byte)(97)))), ((int)(((byte)(97)))));
            this.textBox20.Style.Font.Name = "Arial";
            this.textBox20.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
            this.textBox20.StyleName = "CrosstabHeaderLabel";
            this.textBox20.Value = "Reading Comp Accuracy %";
            //
            // textBox21
            //
            this.textBox21.Name = "textBox21";
            this.textBox21.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.72292381525039673D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.40594133734703064D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox21.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(238)))), ((int)(((byte)(238)))), ((int)(((byte)(238)))));
            this.textBox21.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(204)))), ((int)(((byte)(204)))), ((int)(((byte)(204)))));
            this.textBox21.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(97)))), ((int)(((byte)(97)))), ((int)(((byte)(97)))));
            this.textBox21.Style.Font.Name = "Arial";
            this.textBox21.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
            this.textBox21.StyleName = "CrosstabHeaderLabel";
            this.textBox21.Value = "Vocabulary Percentile";
            //
            // textBox27
            //
            this.textBox27.Name = "textBox27";
            this.textBox27.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.64425981044769287D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.40594133734703064D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox27.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(238)))), ((int)(((byte)(238)))), ((int)(((byte)(238)))));
            this.textBox27.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(204)))), ((int)(((byte)(204)))), ((int)(((byte)(204)))));
            this.textBox27.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(97)))), ((int)(((byte)(97)))), ((int)(((byte)(97)))));
            this.textBox27.Style.Font.Name = "Arial";
            this.textBox27.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
            this.textBox27.StyleName = "CrosstabHeaderLabel";
            this.textBox27.Value = "Assessment Period";
            //
            // textBox30
            //
            this.textBox30.Name = "textBox30";
            this.textBox30.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.64425981044769287D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2878086268901825D, Telerik.Reporting.Drawing.UnitType.Inch));
            this.textBox30.Style.BorderColor.Default = System.Drawing.Color.FromArgb(((int)(((byte)(210)))), ((int)(((byte)(209)))), ((int)(((byte)(214)))));
            this.textBox30.Style.Color = System.Drawing.Color.FromArgb(((int)(((byte)(30)))), ((int)(((byte)(101)))), ((int)(((byte)(172)))));
            this.textBox30.Style.Font.Name = "Arial";
            this.textBox30.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(8D, Telerik.Reporting.Drawing.UnitType.Point);
            this.textBox30.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
            this.textBox30.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
            this.textBox30.StyleName = "CrosstabLabel";
            this.textBox30.Value = "=Fields.ASSESSMENT";
            //
            // FAIRSchoolK2
            //
            this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.pageHeaderSection1,
            this.detail,
            this.pageFooterSection1});
            this.PageSettings.Landscape = false;
            this.PageSettings.Margins.Bottom = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch);
            this.PageSettings.Margins.Left = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch);
            this.PageSettings.Margins.Right = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch);
            this.PageSettings.Margins.Top = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch);
            this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter;
            reportParameter1.Name = "SchoolYear";
            reportParameter1.Value = "STUDENT_LAST_NAME";
            reportParameter2.Name = "District";
            reportParameter3.Name = "School";
            reportParameter4.Name = "Grade";
            reportParameter5.Name = "SortBy";
            reportParameter6.Name = "SortDirection";
            reportParameter6.Value = "Ascending";
            this.ReportParameters.Add(reportParameter1);
            this.ReportParameters.Add(reportParameter2);
            this.ReportParameters.Add(reportParameter3);
            this.ReportParameters.Add(reportParameter4);
            this.ReportParameters.Add(reportParameter5);
            this.ReportParameters.Add(reportParameter6);
            this.Style.BackgroundColor = System.Drawing.Color.White;
            styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
            new Telerik.Reporting.Drawing.StyleSelector(typeof(Telerik.Reporting.Table), "Normal.TableNormal")});
            styleRule1.Style.BackgroundColor = System.Drawing.Color.White;
            styleRule1.Style.BorderColor.Default = System.Drawing.Color.Black;
            styleRule1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
            styleRule1.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Pixel);
            styleRule1.Style.Color = System.Drawing.Color.Black;
            styleRule1.Style.Font.Name = "Tahoma";
            styleRule1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(8D, Telerik.Reporting.Drawing.UnitType.Point);
            descendantSelector1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
            new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.Table)),
            new Telerik.Reporting.Drawing.StyleSelector(typeof(Telerik.Reporting.ReportItem), "Normal.TableHeader")});
            styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
            descendantSelector1});
            styleRule2.Style.BorderColor.Default = System.Drawing.Color.Black;
            styleRule2.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
            styleRule2.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Pixel);
            styleRule2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
            descendantSelector2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
            new Telerik.Reporting.Drawing.TypeSelector(typeof(Telerik.Reporting.Table)),
            new Telerik.Reporting.Drawing.StyleSelector(typeof(Telerik.Reporting.ReportItem), "Normal.TableBody")});
            styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] {
            descendantSelector2});
            styleRule3.Style.BorderColor.Default = System.Drawing.Color.Black;
            styleRule3.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid;
            styleRule3.Style.BorderWidth.Default = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Pixel);
            this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] {
            styleRule1,
            styleRule2,
            styleRule3});
            this.Width = new Telerik.Reporting.Drawing.Unit(6.4000000953674316D, Telerik.Reporting.Drawing.UnitType.Inch);
            this.Name = "FAIRSchoolK2";
            ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
  
        }
        #endregion
  
        private Telerik.Reporting.PageHeaderSection pageHeaderSection1;
        private Telerik.Reporting.DetailSection detail;
        private Telerik.Reporting.PageFooterSection pageFooterSection1;
        private Telerik.Reporting.TextBox textBox28;
        private Telerik.Reporting.Table table1;
        private Telerik.Reporting.TextBox textBox9;
        private Telerik.Reporting.TextBox textBox10;
        private Telerik.Reporting.TextBox textBox11;
        private Telerik.Reporting.TextBox textBox12;
        private Telerik.Reporting.TextBox textBox13;
        private Telerik.Reporting.TextBox textBox14;
        private Telerik.Reporting.TextBox textBox15;
        private Telerik.Reporting.TextBox textBox16;
        private Telerik.Reporting.TextBox textBox17;
        private Telerik.Reporting.TextBox textBox26;
        private Telerik.Reporting.Chart chart1;
        private Telerik.Reporting.TextBox textBox1;
        private Telerik.Reporting.TextBox textBox2;
        private Telerik.Reporting.TextBox textBox3;
        private Telerik.Reporting.TextBox textBox4;
        private Telerik.Reporting.TextBox textBox5;
        private Telerik.Reporting.TextBox textBox6;
        private Telerik.Reporting.TextBox textBox7;
        private Telerik.Reporting.TextBox textBox8;
        private Telerik.Reporting.TextBox textBox25;
        private Telerik.Reporting.TextBox textBox29;
        private Telerik.Reporting.Crosstab crosstab2;
        private Telerik.Reporting.TextBox textBox22;
        private Telerik.Reporting.TextBox textBox23;
        private Telerik.Reporting.TextBox textBox24;
        private Telerik.Reporting.TextBox textBox19;
        private Telerik.Reporting.TextBox textBox20;
        private Telerik.Reporting.TextBox textBox21;
        private Telerik.Reporting.TextBox textBox27;
        private Telerik.Reporting.TextBox textBox30;
    }
}

//CHART
using System;
using Telerik.Reporting.Drawing;
 
namespace PlotReporting.ReportObjects
{
    public partial class FairChart : Telerik.Reporting.Chart
    {
        protected static System.Drawing.Color cellRed = System.Drawing.ColorTranslator.FromHtml("#CA423D");
        protected static System.Drawing.Color cellYellow = System.Drawing.ColorTranslator.FromHtml("#EDB04C");
        protected static System.Drawing.Color cellGreen = System.Drawing.ColorTranslator.FromHtml("#6EA45A");
        protected static System.Drawing.Color textRed = System.Drawing.Color.Red;
 
        public void InitChart(Telerik.Reporting.Chart _chart)
        {
            _chart.Series.Clear();
            _chart.ChartTitle.TextBlock.Text = string.Empty;
            _chart.SeriesOrientation = Telerik.Reporting.Charting.ChartSeriesOrientation.Horizontal;
            _chart.Width = Unit.Pixel(250);
            _chart.Height = Unit.Pixel(100);
            _chart.ChartTitle.TextBlock.Text = string.Empty;
            _chart.ChartTitle.Visible = false;
            _chart.Legend.Appearance.Visible = false;
            _chart.Skin = "LightBrown";
            _chart.PlotArea.XAxis.Appearance.Color = System.Drawing.Color.Red;
            _chart.PlotArea.YAxis.AutoScale = false;
            _chart.PlotArea.Appearance.Dimensions.Margins = "1,10,25,50";
            _chart.PlotArea.YAxis.Step = 20;
            _chart.PlotArea.YAxis.MaxValue = 60;
            _chart.PlotArea.YAxis.MinValue = -60;
            _chart.PlotArea.XAxis.AutoScale = false;
            _chart.PlotArea.XAxis.AddRange(1, 3, 1);
            _chart.PlotArea.XAxis[2].TextBlock.Text = "AP1-2";
            _chart.PlotArea.XAxis[1].TextBlock.Text = "AP2-3";
            _chart.PlotArea.XAxis[0].TextBlock.Text = "AP1-3";
 
        }
 
        internal void SetChartFAIRNeedDataSource(object sender)
        {
            Telerik.Reporting.Processing.Chart chart2 = sender as Telerik.Reporting.Processing.Chart;
            Telerik.Reporting.Chart chartDef = (Telerik.Reporting.Chart)chart2.ItemDefinition;
 
            //IMPORTANT!!!!!! FILTER//
 
            Guid EEEEE_STUDENT_ID = new Guid(chart2.DataObject["EEEEE_STUDENT_ID"].ToString());
            //IMPORTANT!!!!!! FILTER//
 
            chartDef.Series.Clear();
            //STUDENT
            Telerik.Reporting.Charting.ChartSeries csStudent = new Telerik.Reporting.Charting.ChartSeries();
            csStudent.Type = Telerik.Reporting.Charting.ChartSeriesType.Bar;
            csStudent.Appearance.Border.Color = System.Drawing.Color.Gray;
 
            //GRADE
            Telerik.Reporting.Charting.ChartSeries csGrade = new Telerik.Reporting.Charting.ChartSeries();
            csGrade.Type = Telerik.Reporting.Charting.ChartSeriesType.Bubble;
            csGrade.Appearance.BubbleSize = 6;
            csGrade.Appearance.FillStyle.MainColor = System.Drawing.Color.LightBlue;
            csGrade.Appearance.Border.Color = System.Drawing.Color.Gray;
 
 
            Telerik.Reporting.Charting.ChartSeriesItem csiGrade;
            Telerik.Reporting.Charting.ChartSeriesItem csiStudent;
            System.Collections.Generic.List<string> textBlockText = new System.Collections.Generic.List<string>();
 
            chartDef.Series.Add(csStudent);
            chartDef.Series.Add(csGrade);
 
            bool hasData = false;
            float stdAP12, stdAP23, stdAP13;
            float grAP12, grAP23, grAP13;
 
 
            //AP1-3
            float.TryParse(chart2.DataObject["SCHOOL_GR_AVG_GROWTH_AP1_AP3"].ToString(), out grAP13);
            hasData = float.TryParse(chart2.DataObject["GROWTH_AP1_AP3"].ToString(), out stdAP13);
            csiGrade = new Telerik.Reporting.Charting.ChartSeriesItem(grAP13);
            if (stdAP13 >= 0)
            {
                csiStudent = new Telerik.Reporting.Charting.ChartSeriesItem(stdAP13, "", cellGreen);
            }
            else
            {
                csiStudent = new Telerik.Reporting.Charting.ChartSeriesItem(stdAP13, "", cellRed);
            }
 
            if (!hasData)
            {
                csiGrade.Empty = true;
                csiStudent = new Telerik.Reporting.Charting.ChartSeriesItem(stdAP13, "NO DATA", System.Drawing.Color.Red);
            }
 
            textBlockText.Add("AP1-3");
            csiGrade.ActiveRegion.Tooltip = "Avg Grade AP1-AP3 Growth = " + "  " + grAP13;
 
            csGrade.AddItem(csiGrade);
            csStudent.AddItem(csiStudent);
 
            //AP2-3
            float.TryParse(chart2.DataObject["SCHOOL_GR_AVG_GROWTH_AP2_AP3"].ToString(), out grAP23);
            hasData = float.TryParse(chart2.DataObject["GROWTH_AP2_AP3"].ToString(), out stdAP23);
            csiGrade = new Telerik.Reporting.Charting.ChartSeriesItem(grAP23);
            if (stdAP23 >= 0)
            {
                csiStudent = new Telerik.Reporting.Charting.ChartSeriesItem(stdAP23, "", cellGreen);
 
            }
            else
            {
                csiStudent = new Telerik.Reporting.Charting.ChartSeriesItem(stdAP23, "", cellRed);
 
            }
 
            if (!hasData)
            {
                csiGrade.Empty = true;
                csiStudent = new Telerik.Reporting.Charting.ChartSeriesItem(stdAP23, "NO DATA", System.Drawing.Color.Blue);
            }
 
            textBlockText.Add("AP2-3");
            csiGrade.ActiveRegion.Tooltip = "Avg Grade AP2-AP3 Growth = " + "  " + grAP23;
 
            csGrade.AddItem(csiGrade);
            csStudent.AddItem(csiStudent);
 
            //AP1-2
            float.TryParse(chart2.DataObject["SCHOOL_GR_AVG_GROWTH_AP1_AP2"].ToString(), out grAP12);
            hasData = float.TryParse(chart2.DataObject["GROWTH_AP1_AP2"].ToString(), out stdAP12);
            csiGrade = new Telerik.Reporting.Charting.ChartSeriesItem(grAP12);
            if (stdAP12 >= 0)
            {
                csiStudent = new Telerik.Reporting.Charting.ChartSeriesItem(stdAP12, "", cellGreen);
 
            }
            else
            {
                csiStudent = new Telerik.Reporting.Charting.ChartSeriesItem(stdAP12, "", cellRed);
 
            }
 
            if (!hasData)
            {
                csiGrade.Empty = true;
                csiStudent = new Telerik.Reporting.Charting.ChartSeriesItem(stdAP12, "NO DATA", System.Drawing.Color.Green);
            }
            textBlockText.Add("AP1-2");
            csiGrade.ActiveRegion.Tooltip = "Avg Grade AP1-AP2 Growth = " + "  " + grAP12;
 
            csGrade.AddItem(csiGrade);
            csStudent.AddItem(csiStudent);
 
        }
 
    }
}
namespace report
{
    using System;
    using System.Collections.Generic;
    using PlotReporting.DataObjects;
    using PlotReporting.ReportObjects;
    public partial class FAIRSchoolK2 : Telerik.Reporting.Report
    {
        Fairs _objFair = new Fairs();
        FairChart _objChart = new FairChart();
        FairCrosstab _objCrosstab = new FairCrosstab();
        private enum SortDirection { Descending, Ascending };
        private SortDirection Direction;
        private String SortBy;
       
        public FAIRSchoolK2()
        {
            InitializeComponent();
            this.NeedDataSource += new EventHandler(FAIRSchoolK2_NeedDataSource);
            table1.NeedDataSource += new EventHandler(table1_NeedDataSource);
            chart1.NeedDataSource += new EventHandler(chart1_NeedDataSource);
            crosstab2.NeedDataSource += new EventHandler(crosstab2_NeedDataSource);
            table1.ItemDataBinding+=new EventHandler(table1_ItemDataBinding);
        }
        void chart1_NeedDataSource(object sender, EventArgs e)
        {
            _objChart.SetChartFAIRNeedDataSource(sender);
        }
 
        void table1_NeedDataSource(object sender, EventArgs e)
        {
            table1NeedDataSource(sender);
        }
 
        void FAIRSchoolK2_NeedDataSource(object sender, EventArgs e)
        {
            thisNeedDS(sender);
        }
        void crosstab2_NeedDataSource(object sender, EventArgs e)
        {
            if (_objCrosstab != null)
            {
                    _objCrosstab.SetCrosstabNeedDataSourceK2(sender,
                                                                this.ReportParameters["SchoolYear"].Value.ToString(),
                                                                this.ReportParameters["District"].Value.ToString(),
                                                                this.ReportParameters["School"].Value.ToString(),
                                                                this.ReportParameters["Grade"].Value.ToString(),
                                                               "School",
                                                                null);
            }
 
        }
        private void table1_ItemDataBinding(object sender, EventArgs e)
        {
            var procTable = sender as Telerik.Reporting.Processing.Table;
            if (((string)procTable.Report.Parameters["SortDirection"].Value) == "Descending")
            {
                this.table1.Sorting[0].Direction = Telerik.Reporting.Data.SortDirection.Desc;
            }
            else
            {
                this.table1.Sorting[0].Direction = Telerik.Reporting.Data.SortDirection.Asc;
            }
        }
 
        public static string ToggleSortDirection(Telerik.Reporting.Processing.ReportItem reportItem, string sortBy)
        {
            var currentSortBy = (string)reportItem.Report.Parameters["SortBy"].Value;
            var currentSortDirection = (string)reportItem.Report.Parameters["SortDirection"].Value;
 
            if (currentSortBy != sortBy)
            {
                return "Ascending";
            }
 
            if (currentSortDirection == "Descending")
            {
                return "Ascending";
            }
            else
            {
                return "Descending";
            }
        }
        void thisNeedDS(object sender)
        {
 
            List<FairDataItemSumK2> FairDataList = new List<FairDataItemSumK2>();
            if (_objFair != null)
            {
                FairDataList = _objFair.GetFAIRDataSumK2(
                    this.ReportParameters["SchoolYear"].Value.ToString(), this.ReportParameters["District"].Value.ToString(),
                    this.ReportParameters["School"].Value.ToString(), this.ReportParameters["Grade"].Value.ToString(),
                     "School", null);
            }
 
            if (FairDataList.Count > 0)
            {
                this.DataSource = FairDataList;
            }
        }
        void table1NeedDataSource(object sender)
        {
            List<FairDataItemSumK2> FairDataList = new List<FairDataItemSumK2>();
            Telerik.Reporting.Processing.Table tbl = (Telerik.Reporting.Processing.Table)sender;
            if (tbl != null)
            {
                string strEEEEE_STUDENT_ID = tbl.DataObject["EEEEE_STUDENT_ID"].ToString();
 
                if (_objFair != null)
                {
                    FairDataList = _objFair.GetFAIRDataSumbyStudentK2(
                                                            this.ReportParameters["SchoolYear"].Value.ToString(),
                                                            this.ReportParameters["District"].Value.ToString(),
                                                            this.ReportParameters["School"].Value.ToString(),
                                                            this.ReportParameters["Grade"].Value.ToString(),
                                                            strEEEEE_STUDENT_ID,
                                                            "School",
                                                            null);
                }
 
                if (FairDataList.Count > 0)
                {
                    tbl.DataSource = FairDataList;
                }
            }
 
 
        }
    }
 
}
Milen | Product Manager @DX
Telerik team
 answered on 20 May 2011
5 answers
99 views
I've been using the RAD AJAX controls for many years.

I develop the project on my local machine (as IIS 7.5 web-site) and then copy to the client's live web-site with a standard FTP connection. I use the built-in Copy Website function within VS2010. Everything works slick,

Now, following your recommendations, I have had to add a class library to allow creation and editing of reports.

What is the recommended method for getting that class library to the production server?

I realize this might be a simple, elementary procedure that I am "supposed to know", but until now, just the web copy has been the most productive method of deployment. Therefore, I don't even know what search terms to use, so please give me a few hints to start.

Alternatively, I have found that I can create the reports, and when finished, copy them from the local class library to my App_Code directory, and with a few adjustments, run them on the production server. But at least deployment is simplified.

Does anybody else run into these complications?
Tomica
Top achievements
Rank 2
 answered on 19 May 2011
2 answers
175 views
Hi all,

I'm actually working with Entity Framework Code First (DB created from coded model), but believe that Telerik Reporting doesn't yet support this. Therefore, I've created myself an edmx file from the SQL database for this purpose.

When I create a new report, the wizard launches and I'm able to select a new Entity Data Source, select the connection created with the edmx file and the context. After that, I'm presented with the Choose an Object Context Member dialog, asking me to select a member of the object context that will return data. Unfortunately, I'm unsure as to what I should be selecting at this point. Say I have a model named Products. Right now, all I'm interested in is returning every product. How would I go about this? Selecting the Products model from the dialog and clicking Finish returns an "Exception has been thrown by the target of a invocation" error.

Any help much appreciated!
Massimiliano Bassili
Top achievements
Rank 1
 answered on 19 May 2011
3 answers
349 views

I created a simple report on three different machines, Windows 7 64bit, Win Vista 64bit and Windows XP 32 bit.  On each report I get the following message:

An error has occured while processing Report '':
Format of the initialization string does not conform to specification starting at index 0.

I saw the post at http://www.telerik.com/community/forums/reporting/documentation/format-of-the-initialization-string-does-not-conform-to-specification-starting-at-index-0.aspx and I still get the error even though this is a report being used in a winforms project with a separate Report Class.

The report renders perfectly in the design preview for winforms and  html.

this is the code in my code behind
        public Form1()
        {
            InitializeComponent();
            Report1 report = new Report1 ();
            ReportViewer1.Report = report;
        }

I'm using the sqlDataSouce, could this problem be caused by using SQLExpress 2008 as the backend database?



sid
Top achievements
Rank 1
 answered on 19 May 2011
2 answers
87 views
In preview my report look fine but when  i print the  report the margins (left and top)are missing and a field (3 red arrow) are also missing.

Any idea?

Thanks

Claudiu

p p
Top achievements
Rank 1
 answered on 19 May 2011
1 answer
186 views
I am experiencing issues while trying to add a EntityDataSource to a report:

Method 1:
1) Opened a new VS2010 project of "Class Library"
2) Added a new "Telerik Report Q1 2011" item to the project, and cancelled the Report Wizard
3) Added a new EntityDataSource from the toolbox
    a) On the "Choose Your Data Connection" screen, selected "Specifiy a new connection string" and added the following to connect to a simple database on my local installation of SQL 2008: (See attached picture "ConnectionString")
metadata=res://*/SL_Lab1.csdl|res://*/SL_Lab1.ssdl|res://*/SL_Lab1.msl;provider=System.Data.SqlClient;provider connection string="Data Source=localhost;Initial Catalog=SL_Lab1;Integrated Security=True"
    b) Proceed to the "Save the Connection String" page, leaving the "Yes, save this connection string..." checkbox checked, I click "Next" and receive a "blank" VS2010 error. (See attachment "SaveError")

Method 2:
1) I cancel the wizard and remove the EntityDataSource item from the report
2) I add an ADO.NET Entity Model to the project - named "SL_Lab1" to match the database name.
3) I add a blank table "table1" into the body of the report.
4) I switch over to the code view and update the code behind.
namespace EntitySetTest
{
    using System;
    using System.ComponentModel;
    using System.Drawing;
    using System.Windows.Forms;
    using Telerik.Reporting;
    using Telerik.Reporting.Drawing;
  
    /// <summary>
    /// Summary description for EntitySetReport.
    /// </summary>
    public partial class EntitySetReport : Telerik.Reporting.Report
    {
        public EntitySetReport()
        {
            //
            // Required for telerik Reporting designer support
            //
            InitializeComponent();
  
            Telerik.Reporting.EntityDataSource entityDataSource = new Telerik.Reporting.EntityDataSource();
  
            entityDataSource.ObjectContext = typeof(SL_Lab1Entities);
  
            Telerik.Reporting.Report report = new Telerik.Reporting.Report();
  
            report.DataSource = entityDataSource;
  
            table1.DataSource = entityDataSource;
        }
    }
}
5) Previewing the report gives me "The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid."
6) Add in the connection string
entityDataSource.ConnectionString = "SL_Lab1Entites";
6) Build and Preview - same error.
7) Change ConnectionString to:
entityDataSource.ConnectionString = "metadata=res://*/SL_Lab1.csdl|res://*/SL_Lab1.ssdl|res://*/SL_Lab1.msl;provider=System.Data.SqlClient;provider connection string="Data Source=localhost;Initial Catalog=SL_Lab1;Integrated Security=True;MultipleActiveResultSets=True"";
8) Build and Preview - same error.

I have tried this several times, with different databases and always receive an error.  Either the one above or "Unable to load the specified metadata resource".

Any advice on what I am doing wrong?




Robert
Top achievements
Rank 1
 answered on 18 May 2011
7 answers
996 views

I have a textbox in my detail section that gets a value from a user function. I need to sum all of those textbox values in the report footer, but I can’t get it to work. Is there a way to use the SUM function on textbox values instead of data fields?

Deepak Shakya
Top achievements
Rank 1
 answered on 18 May 2011
2 answers
497 views
Hello, I have created a report to display it on a web page.  The data comes up fine but I am unable to find how to have the report fill the entire screen.

There seems to be no property to set the report to expand to 100% of the screen width.

I am using Q1 2011 and developing in VS 2010.

Please advise.

Thanks
Michael
Top achievements
Rank 1
 answered on 17 May 2011
1 answer
101 views
Is it possible to use Telerik Reporting to render a report on the server and send it to a server attached printer ?

We would like to invoke that kind of feature from a web service trigger.

Thanks, Erik.
Steve
Telerik team
 answered on 17 May 2011
4 answers
279 views
I would like to visualize bound dates...can you guys put together a calendar control I can bind a DateTime to which would render the selected Day\Month by any chance?

PITS?
sitefinitysteve
Top achievements
Rank 2
Iron
Veteran
 answered on 17 May 2011
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?