/// <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(); }
/// <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(); }