This is a migrated thread and some comments may be shown as answers.

Interactive sorting( lost CSS and controls)

1 Answer 102 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

Jelena Nahaja asked on 17 May 2011, 12:25 PM

beforesorting.png

aftersorting.png



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

1 Answer, 1 is accepted

answered on 20 May 2011, 11:14 AM

Hello Jelena Nahaja,

You may find a working sample with dynamic sorting in our blog post Dynamic Sorting of Reporting Crosstabs Using a Custom Aggregate Function. Please find in the attached samples the TableSorting report which is what you need. It even does not need the custom aggregate mentioned in the article.

The code you provided is not runnable (types missing) so we are not able to find out exactly what is causing the described behavior. However we may advise you to remove the inherited chart/crosstab and move the NeedDataSource logic in your report. You do not use the inherited crosstab/chart items in your report tree (and this is not supported), so you do not need them. Also you should not modify the report definition (add/remove items) once the report processing has started. Instead the report flexibility should work based only on ReportParameters.

You may also review the help article Understanding Events.

Hope this information helps.

Kind regards,
Milen
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items