Esempio n. 1
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell           xrCrossTabCell5;
     DevExpress.DataAccess.Sql.StoredProcQuery                   storedProcQuery1          = new DevExpress.DataAccess.Sql.StoredProcQuery();
     DevExpress.DataAccess.Sql.QueryParameter                    queryParameter1           = new DevExpress.DataAccess.Sql.QueryParameter();
     System.ComponentModel.ComponentResourceManager              resources                 = new System.ComponentModel.ComponentResourceManager(typeof(BDTK));
     DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition crossTabColumnDefinition1 = new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition(285.7375F);
     DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition crossTabColumnDefinition2 = new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition(285.7375F);
     DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition crossTabColumnDefinition3 = new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition(1.954114F);
     DevExpress.XtraReports.UI.CrossTab.CrossTabColumnField      crossTabColumnField1      = new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnField();
     DevExpress.XtraReports.UI.CrossTab.CrossTabDataField        crossTabDataField1        = new DevExpress.XtraReports.UI.CrossTab.CrossTabDataField();
     DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition    crossTabRowDefinition1    = new DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition(25F);
     DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition    crossTabRowDefinition2    = new DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition(25F);
     DevExpress.XtraReports.UI.CrossTab.CrossTabRowField         crossTabRowField1         = new DevExpress.XtraReports.UI.CrossTab.CrossTabRowField();
     DevExpress.XtraReports.UI.CrossTab.CrossTabRowField         crossTabRowField2         = new DevExpress.XtraReports.UI.CrossTab.CrossTabRowField();
     this.qldsvDataSet2 = new QLSV.QLDSVDataSet();
     this.sP_getBangDiemTongKetTableAdapter = new QLSV.QLDSVDataSetTableAdapters.SP_getBangDiemTongKetTableAdapter();
     this.sqlDataSource1       = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
     this.TitleStyle           = new DevExpress.XtraReports.UI.XRControlStyle();
     this.qldsvDataSet1        = new QLSV.QLDSVDataSet();
     this.crossTabTotalStyle   = new DevExpress.XtraReports.UI.XRControlStyle();
     this.crossTabHeaderStyle  = new DevExpress.XtraReports.UI.XRControlStyle();
     this.crossTabDataStyle    = new DevExpress.XtraReports.UI.XRControlStyle();
     this.crossTabGeneralStyle = new DevExpress.XtraReports.UI.XRControlStyle();
     this.ReportHeader         = new DevExpress.XtraReports.UI.ReportHeaderBand();
     this.xrPanel1             = new DevExpress.XtraReports.UI.XRPanel();
     this.xrLabel1             = new DevExpress.XtraReports.UI.XRLabel();
     this.name             = new DevExpress.XtraReports.UI.XRLabel();
     this.Detail           = new DevExpress.XtraReports.UI.DetailBand();
     this.crossTab1        = new DevExpress.XtraReports.UI.XRCrossTab();
     this.xrCrossTabCell1  = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell2  = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell3  = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell4  = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell6  = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell7  = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell8  = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell9  = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell10 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell11 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell12 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell13 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell14 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.TopMargin        = new DevExpress.XtraReports.UI.TopMarginBand();
     this.BottomMargin     = new DevExpress.XtraReports.UI.BottomMarginBand();
     xrCrossTabCell5       = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     ((System.ComponentModel.ISupportInitialize)(this.qldsvDataSet2)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.qldsvDataSet1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.crossTab1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // xrCrossTabCell5
     //
     xrCrossTabCell5.ColumnIndex = 3;
     xrCrossTabCell5.Name        = "xrCrossTabCell5";
     xrCrossTabCell5.RowIndex    = 0;
     //
     // qldsvDataSet2
     //
     this.qldsvDataSet2.DataSetName             = "QLDSVDataSet";
     this.qldsvDataSet2.Locale                  = new System.Globalization.CultureInfo("en-US");
     this.qldsvDataSet2.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     //
     // sP_getBangDiemTongKetTableAdapter
     //
     this.sP_getBangDiemTongKetTableAdapter.ClearBeforeFill = true;
     //
     // sqlDataSource1
     //
     this.sqlDataSource1.ConnectionName = "QLSV.Properties.Settings.QLDSVConnectionString";
     this.sqlDataSource1.Name           = "sqlDataSource1";
     storedProcQuery1.Name     = "SP_getBangDiemTongKet";
     queryParameter1.Name      = "@malop";
     queryParameter1.Type      = typeof(string);
     queryParameter1.ValueInfo = "D15CQCN1";
     storedProcQuery1.Parameters.Add(queryParameter1);
     storedProcQuery1.StoredProcName = "SP_getBangDiemTongKet";
     this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
         storedProcQuery1
     });
     this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
     //
     // TitleStyle
     //
     this.TitleStyle.Font    = new System.Drawing.Font("Arial", 18F);
     this.TitleStyle.Name    = "TitleStyle";
     this.TitleStyle.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     //
     // qldsvDataSet1
     //
     this.qldsvDataSet1.DataSetName             = "QLDSVDataSet";
     this.qldsvDataSet1.Locale                  = new System.Globalization.CultureInfo("en-US");
     this.qldsvDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
     //
     // crossTabTotalStyle
     //
     this.crossTabTotalStyle.BackColor     = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(227)))), ((int)(((byte)(240)))));
     this.crossTabTotalStyle.Font          = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold);
     this.crossTabTotalStyle.Name          = "crossTabTotalStyle";
     this.crossTabTotalStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     //
     // crossTabHeaderStyle
     //
     this.crossTabHeaderStyle.BackColor     = System.Drawing.Color.FromArgb(((int)(((byte)(250)))), ((int)(((byte)(251)))), ((int)(((byte)(252)))));
     this.crossTabHeaderStyle.Font          = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold);
     this.crossTabHeaderStyle.Name          = "crossTabHeaderStyle";
     this.crossTabHeaderStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
     //
     // crossTabDataStyle
     //
     this.crossTabDataStyle.Name          = "crossTabDataStyle";
     this.crossTabDataStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     //
     // crossTabGeneralStyle
     //
     this.crossTabGeneralStyle.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(232)))), ((int)(((byte)(234)))));
     this.crossTabGeneralStyle.Borders     = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                                                                                     | DevExpress.XtraPrinting.BorderSide.Right)
                                                                                    | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.crossTabGeneralStyle.BorderWidth = 1F;
     this.crossTabGeneralStyle.Font        = new System.Drawing.Font("Arial", 9.75F);
     this.crossTabGeneralStyle.Name        = "crossTabGeneralStyle";
     this.crossTabGeneralStyle.Padding     = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F);
     //
     // ReportHeader
     //
     this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrPanel1
     });
     this.ReportHeader.HeightF = 108.25F;
     this.ReportHeader.Name    = "ReportHeader";
     //
     // xrPanel1
     //
     this.xrPanel1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrLabel1,
         this.name
     });
     this.xrPanel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
     this.xrPanel1.Name          = "xrPanel1";
     this.xrPanel1.SizeF         = new System.Drawing.SizeF(900F, 108.25F);
     //
     // xrLabel1
     //
     this.xrLabel1.Font                           = new System.Drawing.Font("Segoe UI", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.xrLabel1.LocationFloat                  = new DevExpress.Utils.PointFloat(10.00001F, 75.25001F);
     this.xrLabel1.Multiline                      = true;
     this.xrLabel1.Name                           = "xrLabel1";
     this.xrLabel1.Padding                        = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.xrLabel1.SizeF                          = new System.Drawing.SizeF(880F, 23F);
     this.xrLabel1.StylePriority.UseFont          = false;
     this.xrLabel1.StylePriority.UseTextAlignment = false;
     this.xrLabel1.Text                           = "xrLabel1";
     this.xrLabel1.TextAlignment                  = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
     //
     // name
     //
     this.name.Font                           = new System.Drawing.Font("Segoe UI", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.name.LocationFloat                  = new DevExpress.Utils.PointFloat(10.00001F, 25.16667F);
     this.name.Multiline                      = true;
     this.name.Name                           = "name";
     this.name.Padding                        = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     this.name.SizeF                          = new System.Drawing.SizeF(879.9999F, 50.08334F);
     this.name.StylePriority.UseFont          = false;
     this.name.StylePriority.UseTextAlignment = false;
     this.name.Text                           = "BẢNG ĐIỂM TỔNG KẾT";
     this.name.TextAlignment                  = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
     //
     // Detail
     //
     this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.crossTab1
     });
     this.Detail.FillEmptySpace   = true;
     this.Detail.HeightF          = 125F;
     this.Detail.KeepTogether     = true;
     this.Detail.MultiColumn.Mode = DevExpress.XtraReports.UI.MultiColumnMode.UseColumnCount;
     this.Detail.Name             = "Detail";
     //
     // crossTab1
     //
     this.crossTab1.Cells.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrCrossTabCell1,
         this.xrCrossTabCell2,
         this.xrCrossTabCell3,
         this.xrCrossTabCell4,
         xrCrossTabCell5,
         this.xrCrossTabCell6,
         this.xrCrossTabCell7,
         this.xrCrossTabCell8,
         this.xrCrossTabCell9,
         this.xrCrossTabCell10,
         this.xrCrossTabCell11,
         this.xrCrossTabCell12,
         this.xrCrossTabCell13,
         this.xrCrossTabCell14
     });
     crossTabColumnDefinition1.AutoWidthMode = DevExpress.XtraReports.UI.AutoSizeMode.ShrinkAndGrow;
     crossTabColumnDefinition2.AutoWidthMode = DevExpress.XtraReports.UI.AutoSizeMode.ShrinkAndGrow;
     crossTabColumnDefinition3.Visible       = false;
     this.crossTab1.ColumnDefinitions.AddRange(new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition[] {
         crossTabColumnDefinition1,
         crossTabColumnDefinition2,
         new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition(285.7375F),
         crossTabColumnDefinition3
     });
     crossTabColumnField1.FieldName = "TENMH";
     this.crossTab1.ColumnFields.AddRange(new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnField[] {
         crossTabColumnField1
     });
     this.crossTab1.DataAreaStyleName = "crossTabDataStyle";
     crossTabDataField1.FieldName     = "DIEM";
     this.crossTab1.DataFields.AddRange(new DevExpress.XtraReports.UI.CrossTab.CrossTabDataField[] {
         crossTabDataField1
     });
     this.crossTab1.DataMember          = "SP_getBangDiemTongKet";
     this.crossTab1.DataSource          = this.qldsvDataSet2;
     this.crossTab1.GeneralStyleName    = "crossTabGeneralStyle";
     this.crossTab1.HeaderAreaStyleName = "crossTabHeaderStyle";
     this.crossTab1.LocationFloat       = new DevExpress.Utils.PointFloat(30.83334F, 0F);
     this.crossTab1.Name            = "crossTab1";
     crossTabRowDefinition1.Visible = false;
     crossTabRowDefinition2.Visible = false;
     this.crossTab1.RowDefinitions.AddRange(new DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition[] {
         new DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition(25F),
         new DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition(25F),
         crossTabRowDefinition1,
         crossTabRowDefinition2
     });
     crossTabRowField1.FieldName = "MASV";
     crossTabRowField2.FieldName = "HOTEN";
     this.crossTab1.RowFields.AddRange(new DevExpress.XtraReports.UI.CrossTab.CrossTabRowField[] {
         crossTabRowField1,
         crossTabRowField2
     });
     this.crossTab1.SizeF = new System.Drawing.SizeF(859.1666F, 100F);
     this.crossTab1.TotalAreaStyleName = "crossTabTotalStyle";
     //
     // xrCrossTabCell1
     //
     this.xrCrossTabCell1.ColumnIndex = 0;
     this.xrCrossTabCell1.Name        = "xrCrossTabCell1";
     this.xrCrossTabCell1.RowIndex    = 0;
     this.xrCrossTabCell1.Text        = "Mã Sinh Viên";
     //
     // xrCrossTabCell2
     //
     this.xrCrossTabCell2.ColumnIndex = 1;
     this.xrCrossTabCell2.Name        = "xrCrossTabCell2";
     this.xrCrossTabCell2.RowIndex    = 0;
     this.xrCrossTabCell2.Text        = "Họ Tên";
     //
     // xrCrossTabCell3
     //
     this.xrCrossTabCell3.ColumnIndex   = 2;
     this.xrCrossTabCell3.Name          = "xrCrossTabCell3";
     this.xrCrossTabCell3.RowIndex      = 1;
     this.xrCrossTabCell3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
     //
     // xrCrossTabCell4
     //
     this.xrCrossTabCell4.ColumnIndex   = 2;
     this.xrCrossTabCell4.Name          = "xrCrossTabCell4";
     this.xrCrossTabCell4.RowIndex      = 0;
     this.xrCrossTabCell4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
     //
     // xrCrossTabCell6
     //
     this.xrCrossTabCell6.ColumnIndex = 3;
     this.xrCrossTabCell6.Name        = "xrCrossTabCell6";
     this.xrCrossTabCell6.RowIndex    = 1;
     //
     // xrCrossTabCell7
     //
     this.xrCrossTabCell7.ColumnIndex = 0;
     this.xrCrossTabCell7.Name        = "xrCrossTabCell7";
     this.xrCrossTabCell7.RowIndex    = 1;
     //
     // xrCrossTabCell8
     //
     this.xrCrossTabCell8.ColumnIndex   = 1;
     this.xrCrossTabCell8.Name          = "xrCrossTabCell8";
     this.xrCrossTabCell8.RowIndex      = 1;
     this.xrCrossTabCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
     //
     // xrCrossTabCell9
     //
     this.xrCrossTabCell9.ColumnIndex      = 0;
     this.xrCrossTabCell9.ColumnSpan       = 2;
     this.xrCrossTabCell9.Name             = "xrCrossTabCell9";
     this.xrCrossTabCell9.RowIndex         = 2;
     this.xrCrossTabCell9.TextFormatString = "Total {0}";
     //
     // xrCrossTabCell10
     //
     this.xrCrossTabCell10.ColumnIndex = 0;
     this.xrCrossTabCell10.ColumnSpan  = 2;
     this.xrCrossTabCell10.Name        = "xrCrossTabCell10";
     this.xrCrossTabCell10.RowIndex    = 3;
     this.xrCrossTabCell10.Text        = "Grand Total";
     //
     // xrCrossTabCell11
     //
     this.xrCrossTabCell11.BackColor   = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(241)))), ((int)(((byte)(247)))));
     this.xrCrossTabCell11.ColumnIndex = 2;
     this.xrCrossTabCell11.Name        = "xrCrossTabCell11";
     this.xrCrossTabCell11.RowIndex    = 2;
     //
     // xrCrossTabCell12
     //
     this.xrCrossTabCell12.ColumnIndex = 2;
     this.xrCrossTabCell12.Name        = "xrCrossTabCell12";
     this.xrCrossTabCell12.RowIndex    = 3;
     //
     // xrCrossTabCell13
     //
     this.xrCrossTabCell13.ColumnIndex = 3;
     this.xrCrossTabCell13.Name        = "xrCrossTabCell13";
     this.xrCrossTabCell13.RowIndex    = 2;
     //
     // xrCrossTabCell14
     //
     this.xrCrossTabCell14.ColumnIndex = 3;
     this.xrCrossTabCell14.Name        = "xrCrossTabCell14";
     this.xrCrossTabCell14.RowIndex    = 3;
     //
     // TopMargin
     //
     this.TopMargin.HeightF = 111.4583F;
     this.TopMargin.Name    = "TopMargin";
     //
     // BottomMargin
     //
     this.BottomMargin.Name = "BottomMargin";
     //
     // BDTK
     //
     this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
         this.ReportHeader,
         this.Detail,
         this.TopMargin,
         this.BottomMargin
     });
     this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
         this.sqlDataSource1,
         this.qldsvDataSet1,
         this.qldsvDataSet2
     });
     this.DataAdapter = this.sP_getBangDiemTongKetTableAdapter;
     this.Font        = new System.Drawing.Font("Arial", 9.75F);
     this.HorizontalContentSplitting = DevExpress.XtraPrinting.HorizontalContentSplitting.Smart;
     this.Landscape  = true;
     this.Margins    = new System.Drawing.Printing.Margins(100, 100, 111, 100);
     this.PageHeight = 850;
     this.PageWidth  = 1100;
     this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] {
         this.TitleStyle,
         this.crossTabTotalStyle,
         this.crossTabHeaderStyle,
         this.crossTabDataStyle,
         this.crossTabGeneralStyle
     });
     this.Version = "20.2";
     this.VerticalContentSplitting = DevExpress.XtraPrinting.VerticalContentSplitting.Smart;
     ((System.ComponentModel.ISupportInitialize)(this.qldsvDataSet2)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.qldsvDataSet1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.crossTab1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }
Esempio n. 2
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.components = new System.ComponentModel.Container();
     DevExpress.DataAccess.Sql.SelectQuery          selectQuery1       = new DevExpress.DataAccess.Sql.SelectQuery();
     DevExpress.DataAccess.Sql.Column               column1            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression1  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Table                table1             = new DevExpress.DataAccess.Sql.Table();
     DevExpress.DataAccess.Sql.Column               column2            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression2  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column3            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression3  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column4            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression4  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column5            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression5  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column6            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression6  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column7            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression7  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column8            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression8  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column9            = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression9  = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column10           = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression10 = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column11           = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression11 = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column12           = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression12 = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column13           = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression13 = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column14           = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression14 = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column15           = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression15 = new DevExpress.DataAccess.Sql.ColumnExpression();
     DevExpress.DataAccess.Sql.Column               column16           = new DevExpress.DataAccess.Sql.Column();
     DevExpress.DataAccess.Sql.ColumnExpression     columnExpression16 = new DevExpress.DataAccess.Sql.ColumnExpression();
     System.ComponentModel.ComponentResourceManager resources          = new System.ComponentModel.ComponentResourceManager(typeof(xTab));
     DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition crossTabColumnDefinition1 = new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition(100F);
     DevExpress.XtraReports.UI.CrossTab.CrossTabColumnField      crossTabColumnField1      = new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnField();
     DevExpress.XtraReports.UI.CrossTab.CrossTabRowField         crossTabRowField1         = new DevExpress.XtraReports.UI.CrossTab.CrossTabRowField();
     this.sqlDataSource1       = new DevExpress.DataAccess.Sql.SqlDataSource(this.components);
     this.crossTabGeneralStyle = new DevExpress.XtraReports.UI.XRControlStyle();
     this.crossTabDataStyle    = new DevExpress.XtraReports.UI.XRControlStyle();
     this.crossTabHeaderStyle  = new DevExpress.XtraReports.UI.XRControlStyle();
     this.crossTabTotalStyle   = new DevExpress.XtraReports.UI.XRControlStyle();
     this.ReportHeader         = new DevExpress.XtraReports.UI.ReportHeaderBand();
     this.Detail          = new DevExpress.XtraReports.UI.DetailBand();
     this.TopMargin       = new DevExpress.XtraReports.UI.TopMarginBand();
     this.BottomMargin    = new DevExpress.XtraReports.UI.BottomMarginBand();
     this.label1          = new DevExpress.XtraReports.UI.XRLabel();
     this.crossTab1       = new DevExpress.XtraReports.UI.XRCrossTab();
     this.xrCrossTabCell1 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell2 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell3 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell4 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell5 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell6 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell7 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell8 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.xrCrossTabCell9 = new DevExpress.XtraReports.UI.CrossTab.XRCrossTabCell();
     this.TitleStyle      = new DevExpress.XtraReports.UI.XRControlStyle();
     ((System.ComponentModel.ISupportInitialize)(this.crossTab1)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();
     //
     // sqlDataSource1
     //
     this.sqlDataSource1.ConnectionName = "MainConnection";
     this.sqlDataSource1.Name           = "sqlDataSource1";
     columnExpression1.ColumnName       = "ComplaintId";
     table1.Name                   = "Complaints";
     columnExpression1.Table       = table1;
     column1.Expression            = columnExpression1;
     columnExpression2.ColumnName  = "ComplaintTitle";
     columnExpression2.Table       = table1;
     column2.Expression            = columnExpression2;
     columnExpression3.ColumnName  = "NonResidentComplainants";
     columnExpression3.Table       = table1;
     column3.Expression            = columnExpression3;
     columnExpression4.ColumnName  = "NonResidentRespondents";
     columnExpression4.Table       = table1;
     column4.Expression            = columnExpression4;
     columnExpression5.ColumnName  = "NonResidentVictims";
     columnExpression5.Table       = table1;
     column5.Expression            = columnExpression5;
     columnExpression6.ColumnName  = "IncidentLocation";
     columnExpression6.Table       = table1;
     column6.Expression            = columnExpression6;
     columnExpression7.ColumnName  = "DisputeNature";
     columnExpression7.Table       = table1;
     column7.Expression            = columnExpression7;
     columnExpression8.ColumnName  = "IncidentDateTime";
     columnExpression8.Table       = table1;
     column8.Expression            = columnExpression8;
     columnExpression9.ColumnName  = "DateTimeRecorded";
     columnExpression9.Table       = table1;
     column9.Expression            = columnExpression9;
     columnExpression10.ColumnName = "ComplainantNarrative";
     columnExpression10.Table      = table1;
     column10.Expression           = columnExpression10;
     columnExpression11.ColumnName = "CreatedBy";
     columnExpression11.Table      = table1;
     column11.Expression           = columnExpression11;
     columnExpression12.ColumnName = "LastUpdatedBy";
     columnExpression12.Table      = table1;
     column12.Expression           = columnExpression12;
     columnExpression13.ColumnName = "ModeOfSettlement";
     columnExpression13.Table      = table1;
     column13.Expression           = columnExpression13;
     columnExpression14.ColumnName = "ComplaintStatus";
     columnExpression14.Table      = table1;
     column14.Expression           = columnExpression14;
     columnExpression15.ColumnName = "GovernmentSavings";
     columnExpression15.Table      = table1;
     column15.Expression           = columnExpression15;
     columnExpression16.ColumnName = "Remarks";
     columnExpression16.Table      = table1;
     column16.Expression           = columnExpression16;
     selectQuery1.Columns.Add(column1);
     selectQuery1.Columns.Add(column2);
     selectQuery1.Columns.Add(column3);
     selectQuery1.Columns.Add(column4);
     selectQuery1.Columns.Add(column5);
     selectQuery1.Columns.Add(column6);
     selectQuery1.Columns.Add(column7);
     selectQuery1.Columns.Add(column8);
     selectQuery1.Columns.Add(column9);
     selectQuery1.Columns.Add(column10);
     selectQuery1.Columns.Add(column11);
     selectQuery1.Columns.Add(column12);
     selectQuery1.Columns.Add(column13);
     selectQuery1.Columns.Add(column14);
     selectQuery1.Columns.Add(column15);
     selectQuery1.Columns.Add(column16);
     selectQuery1.Name = "Complaints";
     selectQuery1.Tables.Add(table1);
     this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] {
         selectQuery1
     });
     this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable");
     //
     // crossTabGeneralStyle
     //
     this.crossTabGeneralStyle.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(230)))), ((int)(((byte)(232)))), ((int)(((byte)(234)))));
     this.crossTabGeneralStyle.Borders     = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top)
                                                                                     | DevExpress.XtraPrinting.BorderSide.Right)
                                                                                    | DevExpress.XtraPrinting.BorderSide.Bottom)));
     this.crossTabGeneralStyle.BorderWidth = 1F;
     this.crossTabGeneralStyle.Font        = new System.Drawing.Font("Arial", 9.75F);
     this.crossTabGeneralStyle.Name        = "crossTabGeneralStyle";
     this.crossTabGeneralStyle.Padding     = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F);
     //
     // crossTabDataStyle
     //
     this.crossTabDataStyle.Name          = "crossTabDataStyle";
     this.crossTabDataStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     //
     // crossTabHeaderStyle
     //
     this.crossTabHeaderStyle.BackColor     = System.Drawing.Color.FromArgb(((int)(((byte)(251)))), ((int)(((byte)(251)))), ((int)(((byte)(251)))));
     this.crossTabHeaderStyle.Font          = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold);
     this.crossTabHeaderStyle.Name          = "crossTabHeaderStyle";
     this.crossTabHeaderStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
     //
     // crossTabTotalStyle
     //
     this.crossTabTotalStyle.BackColor     = System.Drawing.Color.FromArgb(((int)(((byte)(251)))), ((int)(((byte)(251)))), ((int)(((byte)(251)))));
     this.crossTabTotalStyle.Font          = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold);
     this.crossTabTotalStyle.Name          = "crossTabTotalStyle";
     this.crossTabTotalStyle.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
     //
     // ReportHeader
     //
     this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.label1
     });
     this.ReportHeader.HeightF = 42.01302F;
     this.ReportHeader.Name    = "ReportHeader";
     //
     // Detail
     //
     this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.crossTab1
     });
     this.Detail.HeightF = 75F;
     this.Detail.Name    = "Detail";
     //
     // TopMargin
     //
     this.TopMargin.Name = "TopMargin";
     //
     // BottomMargin
     //
     this.BottomMargin.Name = "BottomMargin";
     //
     // label1
     //
     this.label1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 6F);
     this.label1.Name          = "label1";
     this.label1.SizeF         = new System.Drawing.SizeF(59.5786F, 30.01302F);
     this.label1.StyleName     = "TitleStyle";
     this.label1.Text          = "xTab";
     //
     // crossTab1
     //
     this.crossTab1.Cells.AddRange(new DevExpress.XtraReports.UI.XRControl[] {
         this.xrCrossTabCell1,
         this.xrCrossTabCell2,
         this.xrCrossTabCell3,
         this.xrCrossTabCell4,
         this.xrCrossTabCell5,
         this.xrCrossTabCell6,
         this.xrCrossTabCell7,
         this.xrCrossTabCell8,
         this.xrCrossTabCell9
     });
     crossTabColumnDefinition1.AutoWidthMode = DevExpress.XtraReports.UI.AutoSizeMode.ShrinkAndGrow;
     this.crossTab1.ColumnDefinitions.AddRange(new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition[] {
         crossTabColumnDefinition1,
         new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition(100F),
         new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnDefinition(100F)
     });
     crossTabColumnField1.FieldName = "DisputeNature";
     this.crossTab1.ColumnFields.AddRange(new DevExpress.XtraReports.UI.CrossTab.CrossTabColumnField[] {
         crossTabColumnField1
     });
     this.crossTab1.DataAreaStyleName   = "crossTabDataStyle";
     this.crossTab1.DataMember          = "Complaints";
     this.crossTab1.DataSource          = this.sqlDataSource1;
     this.crossTab1.GeneralStyleName    = "crossTabGeneralStyle";
     this.crossTab1.HeaderAreaStyleName = "crossTabHeaderStyle";
     this.crossTab1.LocationFloat       = new DevExpress.Utils.PointFloat(0F, 0F);
     this.crossTab1.Name = "crossTab1";
     this.crossTab1.RowDefinitions.AddRange(new DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition[] {
         new DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition(25F),
         new DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition(25F),
         new DevExpress.XtraReports.UI.CrossTab.CrossTabRowDefinition(25F)
     });
     crossTabRowField1.FieldName = "ComplaintId";
     this.crossTab1.RowFields.AddRange(new DevExpress.XtraReports.UI.CrossTab.CrossTabRowField[] {
         crossTabRowField1
     });
     this.crossTab1.SizeF = new System.Drawing.SizeF(300F, 75F);
     this.crossTab1.TotalAreaStyleName = "crossTabTotalStyle";
     //
     // xrCrossTabCell1
     //
     this.xrCrossTabCell1.ColumnIndex = 0;
     this.xrCrossTabCell1.Name        = "xrCrossTabCell1";
     this.xrCrossTabCell1.RowIndex    = 0;
     this.xrCrossTabCell1.Text        = "Complaint Id";
     //
     // xrCrossTabCell2
     //
     this.xrCrossTabCell2.ColumnIndex = 1;
     this.xrCrossTabCell2.Name        = "xrCrossTabCell2";
     this.xrCrossTabCell2.RowIndex    = 1;
     //
     // xrCrossTabCell3
     //
     this.xrCrossTabCell3.ColumnIndex = 1;
     this.xrCrossTabCell3.Name        = "xrCrossTabCell3";
     this.xrCrossTabCell3.RowIndex    = 0;
     //
     // xrCrossTabCell4
     //
     this.xrCrossTabCell4.ColumnIndex = 2;
     this.xrCrossTabCell4.Name        = "xrCrossTabCell4";
     this.xrCrossTabCell4.RowIndex    = 0;
     this.xrCrossTabCell4.Text        = "Grand Total";
     //
     // xrCrossTabCell5
     //
     this.xrCrossTabCell5.ColumnIndex = 2;
     this.xrCrossTabCell5.Name        = "xrCrossTabCell5";
     this.xrCrossTabCell5.RowIndex    = 1;
     //
     // xrCrossTabCell6
     //
     this.xrCrossTabCell6.ColumnIndex = 0;
     this.xrCrossTabCell6.Name        = "xrCrossTabCell6";
     this.xrCrossTabCell6.RowIndex    = 1;
     //
     // xrCrossTabCell7
     //
     this.xrCrossTabCell7.ColumnIndex = 0;
     this.xrCrossTabCell7.Name        = "xrCrossTabCell7";
     this.xrCrossTabCell7.RowIndex    = 2;
     this.xrCrossTabCell7.Text        = "Grand Total";
     //
     // xrCrossTabCell8
     //
     this.xrCrossTabCell8.ColumnIndex = 1;
     this.xrCrossTabCell8.Name        = "xrCrossTabCell8";
     this.xrCrossTabCell8.RowIndex    = 2;
     //
     // xrCrossTabCell9
     //
     this.xrCrossTabCell9.ColumnIndex = 2;
     this.xrCrossTabCell9.Name        = "xrCrossTabCell9";
     this.xrCrossTabCell9.RowIndex    = 2;
     //
     // TitleStyle
     //
     this.TitleStyle.Font    = new System.Drawing.Font("Arial", 18F);
     this.TitleStyle.Name    = "TitleStyle";
     this.TitleStyle.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F);
     //
     // xTab
     //
     this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] {
         this.ReportHeader,
         this.Detail,
         this.TopMargin,
         this.BottomMargin
     });
     this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] {
         this.sqlDataSource1
     });
     this.Font = new System.Drawing.Font("Arial", 9.75F);
     this.HorizontalContentSplitting = DevExpress.XtraPrinting.HorizontalContentSplitting.Smart;
     this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] {
         this.TitleStyle,
         this.crossTabGeneralStyle,
         this.crossTabHeaderStyle,
         this.crossTabDataStyle,
         this.crossTabTotalStyle
     });
     this.Version = "19.2";
     this.VerticalContentSplitting = DevExpress.XtraPrinting.VerticalContentSplitting.Smart;
     ((System.ComponentModel.ISupportInitialize)(this.crossTab1)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this)).EndInit();
 }