/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { DevExpress.DataAccess.ConnectionParameters.CustomStringConnectionParameters customStringConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.CustomStringConnectionParameters(); 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 table3 = 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(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(MainReport)); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.table1 = new DevExpress.XtraReports.UI.XRTable(); this.tableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.tableCell1 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.table2 = new DevExpress.XtraReports.UI.XRTable(); this.tableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.tableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); ((System.ComponentModel.ISupportInitialize)(this.table1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.table2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // TopMargin // this.TopMargin.Name = "TopMargin"; // // BottomMargin // this.BottomMargin.Name = "BottomMargin"; // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.table2 }); this.Detail.HeightF = 36.45833F; this.Detail.Name = "Detail"; // // sqlDataSource1 // this.sqlDataSource1.ConnectionName = "NWind.mdf"; customStringConnectionParameters1.ConnectionString = "xpoprovider=MSSqlServer;data source=(LocalDB)\\MSSQLLocalDB;attachdbfilename=|Data" + "Directory|\\NWind.mdf;integrated security=True"; this.sqlDataSource1.ConnectionParameters = customStringConnectionParameters1; this.sqlDataSource1.Name = "sqlDataSource1"; columnExpression1.ColumnName = "CategoryID"; table3.Name = "Categories"; columnExpression1.Table = table3; column1.Expression = columnExpression1; columnExpression2.ColumnName = "CategoryName"; columnExpression2.Table = table3; column2.Expression = columnExpression2; columnExpression3.ColumnName = "Description"; columnExpression3.Table = table3; column3.Expression = columnExpression3; columnExpression4.ColumnName = "Picture"; columnExpression4.Table = table3; column4.Expression = columnExpression4; selectQuery1.Columns.Add(column1); selectQuery1.Columns.Add(column2); selectQuery1.Columns.Add(column3); selectQuery1.Columns.Add(column4); selectQuery1.Name = "Categories"; selectQuery1.Tables.Add(table3); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { selectQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1 }); this.ReportHeader.HeightF = 57.29167F; this.ReportHeader.Name = "ReportHeader"; // // xrLabel1 // this.xrLabel1.Font = new System.Drawing.Font("Arial", 22F, System.Drawing.FontStyle.Bold); this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 10.00001F); this.xrLabel1.Multiline = true; this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.xrLabel1.SizeF = new System.Drawing.SizeF(387.5F, 42.49998F); this.xrLabel1.StylePriority.UseFont = false; this.xrLabel1.Text = "Categories "; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.table1 }); this.GroupHeader1.HeightF = 45.83333F; this.GroupHeader1.Name = "GroupHeader1"; // // table1 // this.table1.BackColor = System.Drawing.Color.DimGray; this.table1.Font = new System.Drawing.Font("Times New Roman", 14F, System.Drawing.FontStyle.Bold); this.table1.ForeColor = System.Drawing.Color.White; this.table1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.table1.Name = "table1"; this.table1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.table1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.tableRow1 }); this.table1.SizeF = new System.Drawing.SizeF(650F, 41.14583F); this.table1.StylePriority.UseBackColor = false; this.table1.StylePriority.UseFont = false; this.table1.StylePriority.UseForeColor = false; this.table1.StylePriority.UseTextAlignment = false; this.table1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // tableRow1 // this.tableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.tableCell1, this.tableCell2, this.tableCell3, this.tableCell4 }); this.tableRow1.Name = "tableRow1"; this.tableRow1.Weight = 18.927082748413085D; // // tableCell1 // this.tableCell1.Multiline = true; this.tableCell1.Name = "tableCell1"; this.tableCell1.StylePriority.UseTextAlignment = false; this.tableCell1.Text = "Category ID"; this.tableCell1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.tableCell1.Weight = 0.2857142857142857D; // // tableCell2 // this.tableCell2.Multiline = true; this.tableCell2.Name = "tableCell2"; this.tableCell2.Text = "Category Name"; this.tableCell2.Weight = 0.2857142857142857D; // // tableCell3 // this.tableCell3.Multiline = true; this.tableCell3.Name = "tableCell3"; this.tableCell3.Text = "Description"; this.tableCell3.Weight = 0.2857142857142857D; // // tableCell4 // this.tableCell4.Multiline = true; this.tableCell4.Name = "tableCell4"; this.tableCell4.Text = "Show Details"; this.tableCell4.Weight = 0.2857142857142857D; // // table2 // this.table2.Font = new System.Drawing.Font("Times New Roman", 10.5F); this.table2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.table2.Name = "table2"; this.table2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.tableRow2 }); this.table2.SizeF = new System.Drawing.SizeF(650F, 34.45832F); this.table2.StylePriority.UseFont = false; this.table2.StylePriority.UseTextAlignment = false; this.table2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // tableRow2 // this.tableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.tableCell5, this.tableCell6, this.tableCell7, this.tableCell8 }); this.tableRow2.Name = "tableRow2"; this.tableRow2.Weight = 1.4981878529424253D; // // tableCell5 // this.tableCell5.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[CategoryID]") }); this.tableCell5.Multiline = true; this.tableCell5.Name = "tableCell5"; this.tableCell5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.tableCell5.StylePriority.UseTextAlignment = false; this.tableCell5.Text = "label3"; this.tableCell5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; this.tableCell5.Weight = 162.5D; // // tableCell6 // this.tableCell6.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[CategoryName]") }); this.tableCell6.Multiline = true; this.tableCell6.Name = "tableCell6"; this.tableCell6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.tableCell6.Text = "label4"; this.tableCell6.Weight = 162.5D; // // tableCell7 // this.tableCell7.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Description]") }); this.tableCell7.Font = new System.Drawing.Font("Times New Roman", 9.5F); this.tableCell7.Multiline = true; this.tableCell7.Name = "tableCell7"; this.tableCell7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.tableCell7.StylePriority.UseFont = false; this.tableCell7.Text = "label5"; this.tableCell7.Weight = 162.5D; // // tableCell8 // this.tableCell8.AllowMarkupText = true; this.tableCell8.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Tag", "[CategoryID]"), new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "NavigateUrl", "\'details\'\n"), new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "\'<size=12><u><b><color=maroon>Show Details</color></b></u></size>\'") }); this.tableCell8.Multiline = true; this.tableCell8.Name = "tableCell8"; this.tableCell8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.tableCell8.StylePriority.UseFont = false; this.tableCell8.Text = "label1"; this.tableCell8.Weight = 162.5D; // // MainReport // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.TopMargin, this.BottomMargin, this.Detail, this.ReportHeader, this.GroupHeader1 }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "Categories"; this.DataSource = this.sqlDataSource1; this.Font = new System.Drawing.Font("Arial", 9.75F); this.Version = "20.2"; ((System.ComponentModel.ISupportInitialize)(this.table1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.table2)).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.ConnectionParameters.CustomStringConnectionParameters customStringConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.CustomStringConnectionParameters(); DevExpress.DataAccess.Sql.CustomSqlQuery customSqlQuery1 = new DevExpress.DataAccess.Sql.CustomSqlQuery(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(getCertificate)); DevExpress.DataAccess.Sql.CustomSqlQuery customSqlQuery2 = new DevExpress.DataAccess.Sql.CustomSqlQuery(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); this.groupHeaderBand1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel12 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel(); this.pageFooterBand1 = new DevExpress.XtraReports.UI.PageFooterBand(); this.Title = new DevExpress.XtraReports.UI.XRControlStyle(); this.FieldCaption = new DevExpress.XtraReports.UI.XRControlStyle(); this.PageInfo = new DevExpress.XtraReports.UI.XRControlStyle(); this.DataField = new DevExpress.XtraReports.UI.XRControlStyle(); this.eServiceId = new DevExpress.XtraReports.Parameters.Parameter(); this.UserId = new DevExpress.XtraReports.Parameters.Parameter(); this.sqlDataSource2 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Dpi = 100F; this.Detail.HeightF = 0F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.StyleName = "DataField"; this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // TopMargin // this.TopMargin.Dpi = 100F; this.TopMargin.HeightF = 0F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // BottomMargin // this.BottomMargin.Dpi = 100F; this.BottomMargin.HeightF = 0F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // sqlDataSource1 // this.sqlDataSource1.ConnectionName = "DefaultConnection (DXWebMRCS)"; customStringConnectionParameters1.ConnectionString = "XpoProvider=MSSqlServer;Data Source=198.71.225.145;Initial Catalog=mrcs;User ID=m" + "rcs;Password=Pa$$word123;MultipleActiveResultSets=True"; this.sqlDataSource1.ConnectionParameters = customStringConnectionParameters1; this.sqlDataSource1.Name = "sqlDataSource1"; customSqlQuery1.Name = "Query"; customSqlQuery1.Sql = resources.GetString("customSqlQuery1.Sql"); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { customSqlQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // groupHeaderBand1 // this.groupHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1, this.xrLabel9, this.xrLabel12, this.xrLabel10, this.xrLabel11 }); this.groupHeaderBand1.Dpi = 100F; this.groupHeaderBand1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("UserId", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("eServiceID", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Score", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Name", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("LessonName", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Datetime", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.groupHeaderBand1.HeightF = 948.4736F; this.groupHeaderBand1.Name = "groupHeaderBand1"; this.groupHeaderBand1.StyleName = "DataField"; // // xrLabel1 // this.xrLabel1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "Query.Datetime") }); this.xrLabel1.Dpi = 100F; this.xrLabel1.Font = new System.Drawing.Font("Times New Roman", 12.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(289.378F, 647.4662F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(147.9999F, 23F); this.xrLabel1.StylePriority.UseFont = false; this.xrLabel1.StylePriority.UseTextAlignment = false; this.xrLabel1.Text = "xrLabel12"; this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrLabel9 // this.xrLabel9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "Query.Score") }); this.xrLabel9.Dpi = 100F; this.xrLabel9.Font = new System.Drawing.Font("Times New Roman", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel9.ForeColor = System.Drawing.Color.Red; this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(257.3118F, 388.8962F); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel9.SizeF = new System.Drawing.SizeF(101.0159F, 23F); this.xrLabel9.StylePriority.UseFont = false; this.xrLabel9.StylePriority.UseForeColor = false; this.xrLabel9.StylePriority.UseTextAlignment = false; this.xrLabel9.Text = "xrLabel9"; this.xrLabel9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; // // xrLabel12 // this.xrLabel12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "Query.Datetime") }); this.xrLabel12.Dpi = 100F; this.xrLabel12.Font = new System.Drawing.Font("Times New Roman", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel12.ForeColor = System.Drawing.Color.Red; this.xrLabel12.LocationFloat = new DevExpress.Utils.PointFloat(228.1163F, 335.5341F); this.xrLabel12.Name = "xrLabel12"; this.xrLabel12.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel12.SizeF = new System.Drawing.SizeF(115.7082F, 23F); this.xrLabel12.StylePriority.UseFont = false; this.xrLabel12.StylePriority.UseForeColor = false; this.xrLabel12.StylePriority.UseTextAlignment = false; this.xrLabel12.Text = "xrLabel12"; this.xrLabel12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; // // xrLabel10 // this.xrLabel10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "Query.Name") }); this.xrLabel10.Dpi = 100F; this.xrLabel10.Font = new System.Drawing.Font("Times New Roman", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel10.ForeColor = System.Drawing.Color.Red; this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(348.8746F, 276.9886F); this.xrLabel10.Name = "xrLabel10"; this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel10.SizeF = new System.Drawing.SizeF(488.25F, 23F); this.xrLabel10.StylePriority.UseFont = false; this.xrLabel10.StylePriority.UseForeColor = false; this.xrLabel10.StylePriority.UseTextAlignment = false; this.xrLabel10.Text = "xrLabel10"; this.xrLabel10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrLabel11 // this.xrLabel11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "Query.LessonName") }); this.xrLabel11.Dpi = 100F; this.xrLabel11.Font = new System.Drawing.Font("Times New Roman", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.xrLabel11.ForeColor = System.Drawing.Color.Red; this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(428.5667F, 335.5341F); this.xrLabel11.Name = "xrLabel11"; this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel11.SizeF = new System.Drawing.SizeF(353.8408F, 23F); this.xrLabel11.StylePriority.UseFont = false; this.xrLabel11.StylePriority.UseForeColor = false; this.xrLabel11.StylePriority.UseTextAlignment = false; this.xrLabel11.Text = "xrLabel11"; this.xrLabel11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // pageFooterBand1 // this.pageFooterBand1.Dpi = 100F; this.pageFooterBand1.HeightF = 29F; this.pageFooterBand1.Name = "pageFooterBand1"; // // Title // this.Title.BackColor = System.Drawing.Color.Transparent; this.Title.BorderColor = System.Drawing.Color.Black; this.Title.Borders = DevExpress.XtraPrinting.BorderSide.None; this.Title.BorderWidth = 1F; this.Title.Font = new System.Drawing.Font("Times New Roman", 20F, System.Drawing.FontStyle.Bold); this.Title.ForeColor = System.Drawing.Color.Maroon; this.Title.Name = "Title"; // // FieldCaption // this.FieldCaption.BackColor = System.Drawing.Color.Transparent; this.FieldCaption.BorderColor = System.Drawing.Color.Black; this.FieldCaption.Borders = DevExpress.XtraPrinting.BorderSide.None; this.FieldCaption.BorderWidth = 1F; this.FieldCaption.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold); this.FieldCaption.ForeColor = System.Drawing.Color.Maroon; this.FieldCaption.Name = "FieldCaption"; // // PageInfo // this.PageInfo.BackColor = System.Drawing.Color.Transparent; this.PageInfo.BorderColor = System.Drawing.Color.Black; this.PageInfo.Borders = DevExpress.XtraPrinting.BorderSide.None; this.PageInfo.BorderWidth = 1F; this.PageInfo.Font = new System.Drawing.Font("Times New Roman", 10F, System.Drawing.FontStyle.Bold); this.PageInfo.ForeColor = System.Drawing.Color.Black; this.PageInfo.Name = "PageInfo"; // // DataField // this.DataField.BackColor = System.Drawing.Color.Transparent; this.DataField.BorderColor = System.Drawing.Color.Black; this.DataField.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DataField.BorderWidth = 1F; this.DataField.Font = new System.Drawing.Font("Times New Roman", 10F); this.DataField.ForeColor = System.Drawing.Color.Black; this.DataField.Name = "DataField"; this.DataField.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // eServiceId // this.eServiceId.Description = "eServiceId"; this.eServiceId.Name = "eServiceId"; this.eServiceId.Type = typeof(int); this.eServiceId.ValueInfo = "0"; this.eServiceId.Visible = false; // // UserId // this.UserId.Description = "UserId"; this.UserId.Name = "UserId"; this.UserId.Type = typeof(int); this.UserId.ValueInfo = "0"; this.UserId.Visible = false; // // sqlDataSource2 // this.sqlDataSource2.ConnectionName = "DefaultConnection"; this.sqlDataSource2.Name = "sqlDataSource2"; customSqlQuery2.Name = "Query"; customSqlQuery2.Sql = resources.GetString("customSqlQuery2.Sql"); this.sqlDataSource2.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { customSqlQuery2 }); this.sqlDataSource2.ResultSchemaSerializable = resources.GetString("sqlDataSource2.ResultSchemaSerializable"); // // getCertificate // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.groupHeaderBand1, this.pageFooterBand1 }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1, this.sqlDataSource2 }); this.DataMember = "Query"; this.DataSource = this.sqlDataSource2; this.Landscape = true; this.Margins = new System.Drawing.Printing.Margins(0, 0, 0, 0); this.PageHeight = 827; this.PageWidth = 1169; this.PaperKind = System.Drawing.Printing.PaperKind.A4; this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] { this.eServiceId, this.UserId }); this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.FieldCaption, this.PageInfo, this.DataField }); this.Version = "16.2"; this.Watermark.Image = ((System.Drawing.Image)(resources.GetObject("getCertificate.Watermark.Image"))); this.Watermark.ImageAlign = System.Drawing.ContentAlignment.TopCenter; this.Watermark.ImageTiling = true; this.Watermark.ImageViewMode = DevExpress.XtraPrinting.Drawing.ImageViewMode.Stretch; this.BeforePrint += new System.Drawing.Printing.PrintEventHandler(this.getCertificate_BeforePrint); ((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.ConnectionParameters.CustomStringConnectionParameters customStringConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.CustomStringConnectionParameters(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ReportStudentEmpyReport)); 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 table3 = 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.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings2 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); this.Title = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailCaption1 = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailData1 = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailData3_Odd = new DevExpress.XtraReports.UI.XRControlStyle(); this.PageInfo = new DevExpress.XtraReports.UI.XRControlStyle(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.pageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.pageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrRichText4 = new DevExpress.XtraReports.UI.XRRichText(); this.xrRichText3 = new DevExpress.XtraReports.UI.XRRichText(); this.xrRichText2 = new DevExpress.XtraReports.UI.XRRichText(); this.xrRichText1 = new DevExpress.XtraReports.UI.XRRichText(); this.label1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.table1 = new DevExpress.XtraReports.UI.XRTable(); this.tableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.tableCell1 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.table2 = new DevExpress.XtraReports.UI.XRTable(); this.tableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.tableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell10 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell12 = new DevExpress.XtraReports.UI.XRTableCell(); this.Gender = new DevExpress.XtraReports.Parameters.Parameter(); this.Batch = new DevExpress.XtraReports.Parameters.Parameter(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.table1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.table2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // sqlDataSource1 // this.sqlDataSource1.ConnectionName = "ec2amaz-1vsojpn.proadmin_v1.dbo"; customStringConnectionParameters1.ConnectionString = resources.GetString("customStringConnectionParameters1.ConnectionString"); this.sqlDataSource1.ConnectionParameters = customStringConnectionParameters1; this.sqlDataSource1.Name = "sqlDataSource1"; columnExpression1.ColumnName = "regid"; table3.Name = "basicdata_student"; columnExpression1.Table = table3; column1.Expression = columnExpression1; columnExpression2.ColumnName = "Firstname"; columnExpression2.Table = table3; column2.Expression = columnExpression2; columnExpression3.ColumnName = "Lastname"; columnExpression3.Table = table3; column3.Expression = columnExpression3; columnExpression4.ColumnName = "Batch"; columnExpression4.Table = table3; column4.Expression = columnExpression4; columnExpression5.ColumnName = "Al_school"; columnExpression5.Table = table3; column5.Expression = columnExpression5; columnExpression6.ColumnName = "Gender"; columnExpression6.Table = table3; column6.Expression = columnExpression6; 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.Name = "basicdata_student"; selectQuery1.Tables.Add(table3); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { selectQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // Title // this.Title.BackColor = System.Drawing.Color.Transparent; this.Title.BorderColor = System.Drawing.Color.Black; this.Title.Borders = DevExpress.XtraPrinting.BorderSide.None; this.Title.BorderWidth = 1F; this.Title.Font = new System.Drawing.Font("Arial", 14.25F); this.Title.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(70)))), ((int)(((byte)(80))))); this.Title.Name = "Title"; // // DetailCaption1 // this.DetailCaption1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(93)))), ((int)(((byte)(98)))), ((int)(((byte)(110))))); this.DetailCaption1.BorderColor = System.Drawing.Color.White; this.DetailCaption1.Borders = DevExpress.XtraPrinting.BorderSide.Left; this.DetailCaption1.BorderWidth = 2F; this.DetailCaption1.Font = new System.Drawing.Font("Arial", 8.25F, System.Drawing.FontStyle.Bold); this.DetailCaption1.ForeColor = System.Drawing.Color.White; this.DetailCaption1.Name = "DetailCaption1"; this.DetailCaption1.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailCaption1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // DetailData1 // this.DetailData1.BorderColor = System.Drawing.Color.Transparent; this.DetailData1.Borders = DevExpress.XtraPrinting.BorderSide.Left; this.DetailData1.BorderWidth = 2F; this.DetailData1.Font = new System.Drawing.Font("Arial", 8.25F); this.DetailData1.ForeColor = System.Drawing.Color.Black; this.DetailData1.Name = "DetailData1"; this.DetailData1.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailData1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // DetailData3_Odd // this.DetailData3_Odd.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(243)))), ((int)(((byte)(245)))), ((int)(((byte)(248))))); this.DetailData3_Odd.BorderColor = System.Drawing.Color.Transparent; this.DetailData3_Odd.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DetailData3_Odd.BorderWidth = 1F; this.DetailData3_Odd.Font = new System.Drawing.Font("Arial", 8.25F); this.DetailData3_Odd.ForeColor = System.Drawing.Color.Black; this.DetailData3_Odd.Name = "DetailData3_Odd"; this.DetailData3_Odd.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailData3_Odd.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // PageInfo // this.PageInfo.Font = new System.Drawing.Font("Arial", 8.25F, System.Drawing.FontStyle.Bold); this.PageInfo.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(70)))), ((int)(((byte)(80))))); this.PageInfo.Name = "PageInfo"; this.PageInfo.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // TopMargin // this.TopMargin.HeightF = 30F; this.TopMargin.Name = "TopMargin"; // // BottomMargin // this.BottomMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.pageInfo1, this.pageInfo2 }); this.BottomMargin.HeightF = 50F; this.BottomMargin.Name = "BottomMargin"; // // pageInfo1 // this.pageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 6F); this.pageInfo1.Name = "pageInfo1"; this.pageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.pageInfo1.SizeF = new System.Drawing.SizeF(301.5F, 23F); this.pageInfo1.StyleName = "PageInfo"; // // pageInfo2 // this.pageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(319F, 5.999979F); this.pageInfo2.Name = "pageInfo2"; this.pageInfo2.SizeF = new System.Drawing.SizeF(404.9999F, 23F); this.pageInfo2.StyleName = "PageInfo"; this.pageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; this.pageInfo2.TextFormatString = "Page {0} of {1}"; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrRichText4, this.xrRichText3, this.xrRichText2, this.xrRichText1, this.label1, this.xrLabel1 }); this.ReportHeader.HeightF = 63.83333F; this.ReportHeader.Name = "ReportHeader"; // // xrRichText4 // this.xrRichText4.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText4.LocationFloat = new DevExpress.Utils.PointFloat(642.682F, 30.83332F); this.xrRichText4.Name = "xrRichText4"; this.xrRichText4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText4.SerializableRtfString = resources.GetString("xrRichText4.SerializableRtfString"); this.xrRichText4.SizeF = new System.Drawing.SizeF(71.31799F, 23F); this.xrRichText4.StylePriority.UseFont = false; // // xrRichText3 // this.xrRichText3.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText3.LocationFloat = new DevExpress.Utils.PointFloat(558.2501F, 30.83332F); this.xrRichText3.Name = "xrRichText3"; this.xrRichText3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText3.SerializableRtfString = resources.GetString("xrRichText3.SerializableRtfString"); this.xrRichText3.SizeF = new System.Drawing.SizeF(100F, 23F); // // xrRichText2 // this.xrRichText2.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText2.LocationFloat = new DevExpress.Utils.PointFloat(56.20832F, 30.83332F); this.xrRichText2.Name = "xrRichText2"; this.xrRichText2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText2.SerializableRtfString = resources.GetString("xrRichText2.SerializableRtfString"); this.xrRichText2.SizeF = new System.Drawing.SizeF(100F, 23F); this.xrRichText2.StylePriority.UseFont = false; // // xrRichText1 // this.xrRichText1.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 32.52767F); this.xrRichText1.Name = "xrRichText1"; this.xrRichText1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText1.SerializableRtfString = resources.GetString("xrRichText1.SerializableRtfString"); this.xrRichText1.SizeF = new System.Drawing.SizeF(100F, 23F); // // label1 // this.label1.Font = new System.Drawing.Font("Arial", 14.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Underline)))); this.label1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.label1.Name = "label1"; this.label1.SizeF = new System.Drawing.SizeF(723.9999F, 32.52767F); this.label1.StyleName = "Title"; this.label1.StylePriority.UseFont = false; this.label1.StylePriority.UseTextAlignment = false; this.label1.Text = "NEW HIGHER EDUCATION CENTRE (PVT) LTD"; this.label1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrLabel1 // this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 23.94435F); 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(723.9999F, 31.33334F); this.xrLabel1.StylePriority.UseTextAlignment = false; this.xrLabel1.Text = "No 58, New Rosita Town Kotagala. T.P 0774009942"; this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.table1 }); this.GroupHeader1.GroupUnion = DevExpress.XtraReports.UI.GroupUnion.WithFirstDetail; this.GroupHeader1.HeightF = 28F; this.GroupHeader1.Name = "GroupHeader1"; // // table1 // this.table1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.table1.Name = "table1"; this.table1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.tableRow1 }); this.table1.SizeF = new System.Drawing.SizeF(724F, 28F); // // tableRow1 // this.tableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.tableCell1, this.tableCell2, this.tableCell3, this.tableCell4, this.tableCell5, this.tableCell6 }); this.tableRow1.Name = "tableRow1"; this.tableRow1.Weight = 1D; // // tableCell1 // this.tableCell1.Borders = DevExpress.XtraPrinting.BorderSide.None; this.tableCell1.Name = "tableCell1"; this.tableCell1.StyleName = "DetailCaption1"; this.tableCell1.StylePriority.UseBorders = false; this.tableCell1.Text = "regid"; this.tableCell1.Weight = 0.14553156376917154D; // // tableCell2 // this.tableCell2.Name = "tableCell2"; this.tableCell2.StyleName = "DetailCaption1"; this.tableCell2.Text = "Firstname"; this.tableCell2.Weight = 0.26143684953741486D; // // tableCell3 // this.tableCell3.Name = "tableCell3"; this.tableCell3.StyleName = "DetailCaption1"; this.tableCell3.Text = "Lastname"; this.tableCell3.Weight = 0.19295530924537757D; // // tableCell4 // this.tableCell4.Name = "tableCell4"; this.tableCell4.StyleName = "DetailCaption1"; this.tableCell4.Text = "School"; this.tableCell4.Weight = 0.24468229578031639D; // // tableCell5 // this.tableCell5.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224))))); this.tableCell5.Name = "tableCell5"; this.tableCell5.StyleName = "DetailCaption1"; this.tableCell5.StylePriority.UseBackColor = false; this.tableCell5.Weight = 0.15539403676157831D; // // tableCell6 // this.tableCell6.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224))))); this.tableCell6.Multiline = true; this.tableCell6.Name = "tableCell6"; this.tableCell6.StyleName = "DetailCaption1"; this.tableCell6.StylePriority.UseBackColor = false; this.tableCell6.Text = "\r\n"; this.tableCell6.Weight = 0.15470484693309708D; // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.table2 }); this.Detail.HeightF = 25F; this.Detail.Name = "Detail"; // // table2 // this.table2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.table2.Name = "table2"; this.table2.OddStyleName = "DetailData3_Odd"; this.table2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.tableRow2 }); this.table2.SizeF = new System.Drawing.SizeF(723.9999F, 25F); // // tableRow2 // this.tableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.tableCell7, this.tableCell8, this.tableCell9, this.tableCell10, this.tableCell12 }); this.tableRow2.Name = "tableRow2"; this.tableRow2.Weight = 11.5D; // // tableCell7 // this.tableCell7.Borders = DevExpress.XtraPrinting.BorderSide.None; this.tableCell7.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[regid]") }); this.tableCell7.Name = "tableCell7"; this.tableCell7.StyleName = "DetailData1"; this.tableCell7.StylePriority.UseBorders = false; this.tableCell7.Weight = 0.14553158938707506D; // // tableCell8 // this.tableCell8.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Firstname]") }); this.tableCell8.Name = "tableCell8"; this.tableCell8.StyleName = "DetailData1"; this.tableCell8.Weight = 0.26143686509289821D; // // tableCell9 // this.tableCell9.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Lastname]") }); this.tableCell9.Name = "tableCell9"; this.tableCell9.StyleName = "DetailData1"; this.tableCell9.Weight = 0.19295532123036779D; // // tableCell10 // this.tableCell10.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Al_school]") }); this.tableCell10.Multiline = true; this.tableCell10.Name = "tableCell10"; this.tableCell10.StyleName = "DetailData1"; this.tableCell10.Weight = 0.24468230191424095D; // // tableCell12 // this.tableCell12.Name = "tableCell12"; this.tableCell12.StyleName = "DetailData1"; this.tableCell12.Weight = 0.31009879068930568D; // // Gender // this.Gender.Description = "Gender"; this.Gender.Name = "Gender"; dynamicListLookUpSettings1.DataMember = "basicdata_student"; dynamicListLookUpSettings1.DataSource = this.sqlDataSource1; dynamicListLookUpSettings1.DisplayMember = "Gender"; dynamicListLookUpSettings1.SortMember = null; dynamicListLookUpSettings1.ValueMember = "Gender"; this.Gender.ValueSourceSettings = dynamicListLookUpSettings1; // // Batch // this.Batch.Description = "Batch"; this.Batch.Name = "Batch"; this.Batch.Type = typeof(int); this.Batch.ValueInfo = "0"; dynamicListLookUpSettings2.DataMember = "basicdata_student"; dynamicListLookUpSettings2.DataSource = this.sqlDataSource1; dynamicListLookUpSettings2.DisplayMember = "Batch"; dynamicListLookUpSettings2.SortMember = null; dynamicListLookUpSettings2.ValueMember = "Batch"; this.Batch.ValueSourceSettings = dynamicListLookUpSettings2; // // ReportStudentEmpyReport // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.TopMargin, this.BottomMargin, this.ReportHeader, this.GroupHeader1, this.Detail }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "basicdata_student"; this.DataSource = this.sqlDataSource1; this.FilterString = "[Batch] = ?Batch And [Gender] = ?Gender"; this.Font = new System.Drawing.Font("Arial", 9.75F); this.Margins = new System.Drawing.Printing.Margins(49, 54, 30, 50); this.PageHeight = 1169; this.PageWidth = 827; this.PaperKind = System.Drawing.Printing.PaperKind.A4; this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] { this.Gender, this.Batch }); this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.DetailCaption1, this.DetailData1, this.DetailData3_Odd, this.PageInfo }); this.Version = "19.2"; ((System.ComponentModel.ISupportInitialize)(this.xrRichText4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.table1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.table2)).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.ConnectionParameters.CustomStringConnectionParameters customStringConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.CustomStringConnectionParameters(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ReportExamResultSummary)); 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 table3 = 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(); DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings2 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); this.Title = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailCaption1 = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailData1 = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailData3_Odd = new DevExpress.XtraReports.UI.XRControlStyle(); this.PageInfo = new DevExpress.XtraReports.UI.XRControlStyle(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.pageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.pageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrRichText5 = new DevExpress.XtraReports.UI.XRRichText(); this.xrRichText4 = new DevExpress.XtraReports.UI.XRRichText(); this.xrRichText3 = new DevExpress.XtraReports.UI.XRRichText(); this.xrRichText2 = new DevExpress.XtraReports.UI.XRRichText(); this.xrRichText1 = new DevExpress.XtraReports.UI.XRRichText(); this.label1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.table1 = new DevExpress.XtraReports.UI.XRTable(); this.tableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.tableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell10 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell11 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell12 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell13 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell14 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell15 = new DevExpress.XtraReports.UI.XRTableCell(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.table2 = new DevExpress.XtraReports.UI.XRTable(); this.tableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.tableCell19 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell20 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell21 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell22 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell23 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell24 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell25 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell26 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell27 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell28 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell29 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell30 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell31 = new DevExpress.XtraReports.UI.XRTableCell(); this.Batch = new DevExpress.XtraReports.Parameters.Parameter(); this.Exam = new DevExpress.XtraReports.Parameters.Parameter(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.table1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.table2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // sqlDataSource1 // this.sqlDataSource1.ConnectionName = "ec2amaz-1vsojpn.proadmin_v1.dbo"; customStringConnectionParameters1.ConnectionString = resources.GetString("customStringConnectionParameters1.ConnectionString"); this.sqlDataSource1.ConnectionParameters = customStringConnectionParameters1; this.sqlDataSource1.Name = "sqlDataSource1"; columnExpression1.ColumnName = "batch"; table3.Name = "view_exam_results_summary"; columnExpression1.Table = table3; column1.Expression = columnExpression1; columnExpression2.ColumnName = "exam_date"; columnExpression2.Table = table3; column2.Expression = columnExpression2; columnExpression3.ColumnName = "regid"; columnExpression3.Table = table3; column3.Expression = columnExpression3; columnExpression4.ColumnName = "Firstname"; columnExpression4.Table = table3; column4.Expression = columnExpression4; columnExpression5.ColumnName = "Lastname"; columnExpression5.Table = table3; column5.Expression = columnExpression5; columnExpression6.ColumnName = "Al_school"; columnExpression6.Table = table3; column6.Expression = columnExpression6; columnExpression7.ColumnName = "subject_1"; columnExpression7.Table = table3; column7.Expression = columnExpression7; columnExpression8.ColumnName = "subject_2"; columnExpression8.Table = table3; column8.Expression = columnExpression8; columnExpression9.ColumnName = "subject_3"; columnExpression9.Table = table3; column9.Expression = columnExpression9; columnExpression10.ColumnName = "total_marks"; columnExpression10.Table = table3; column10.Expression = columnExpression10; columnExpression11.ColumnName = "rank"; columnExpression11.Table = table3; column11.Expression = columnExpression11; columnExpression12.ColumnName = "avg_state"; columnExpression12.Table = table3; column12.Expression = columnExpression12; columnExpression13.ColumnName = "average_marks"; columnExpression13.Table = table3; column13.Expression = columnExpression13; columnExpression14.ColumnName = "English"; columnExpression14.Table = table3; column14.Expression = columnExpression14; columnExpression15.ColumnName = "git"; columnExpression15.Table = table3; column15.Expression = columnExpression15; columnExpression16.ColumnName = "exam"; columnExpression16.Table = table3; 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 = "view_exam_results_summary"; selectQuery1.Tables.Add(table3); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { selectQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // Title // this.Title.BackColor = System.Drawing.Color.Transparent; this.Title.BorderColor = System.Drawing.Color.Black; this.Title.Borders = DevExpress.XtraPrinting.BorderSide.None; this.Title.BorderWidth = 1F; this.Title.Font = new System.Drawing.Font("Arial", 14.25F); this.Title.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(70)))), ((int)(((byte)(80))))); this.Title.Name = "Title"; // // DetailCaption1 // this.DetailCaption1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(93)))), ((int)(((byte)(98)))), ((int)(((byte)(110))))); this.DetailCaption1.BorderColor = System.Drawing.Color.White; this.DetailCaption1.Borders = DevExpress.XtraPrinting.BorderSide.Left; this.DetailCaption1.BorderWidth = 2F; this.DetailCaption1.Font = new System.Drawing.Font("Arial", 8.25F, System.Drawing.FontStyle.Bold); this.DetailCaption1.ForeColor = System.Drawing.Color.White; this.DetailCaption1.Name = "DetailCaption1"; this.DetailCaption1.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailCaption1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // DetailData1 // this.DetailData1.BorderColor = System.Drawing.Color.Transparent; this.DetailData1.Borders = DevExpress.XtraPrinting.BorderSide.Left; this.DetailData1.BorderWidth = 2F; this.DetailData1.Font = new System.Drawing.Font("Arial", 8.25F); this.DetailData1.ForeColor = System.Drawing.Color.Black; this.DetailData1.Name = "DetailData1"; this.DetailData1.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailData1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // DetailData3_Odd // this.DetailData3_Odd.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(243)))), ((int)(((byte)(245)))), ((int)(((byte)(248))))); this.DetailData3_Odd.BorderColor = System.Drawing.Color.Transparent; this.DetailData3_Odd.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DetailData3_Odd.BorderWidth = 1F; this.DetailData3_Odd.Font = new System.Drawing.Font("Arial", 8.25F); this.DetailData3_Odd.ForeColor = System.Drawing.Color.Black; this.DetailData3_Odd.Name = "DetailData3_Odd"; this.DetailData3_Odd.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailData3_Odd.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // PageInfo // this.PageInfo.Font = new System.Drawing.Font("Arial", 8.25F, System.Drawing.FontStyle.Bold); this.PageInfo.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(70)))), ((int)(((byte)(80))))); this.PageInfo.Name = "PageInfo"; this.PageInfo.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // TopMargin // this.TopMargin.HeightF = 27F; this.TopMargin.Name = "TopMargin"; // // BottomMargin // this.BottomMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.pageInfo1, this.pageInfo2 }); this.BottomMargin.HeightF = 47F; this.BottomMargin.Name = "BottomMargin"; // // pageInfo1 // this.pageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 6F); this.pageInfo1.Name = "pageInfo1"; this.pageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.pageInfo1.SizeF = new System.Drawing.SizeF(472.5F, 23F); this.pageInfo1.StyleName = "PageInfo"; // // pageInfo2 // this.pageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(490F, 5.999979F); this.pageInfo2.Name = "pageInfo2"; this.pageInfo2.SizeF = new System.Drawing.SizeF(605.9998F, 23F); this.pageInfo2.StyleName = "PageInfo"; this.pageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; this.pageInfo2.TextFormatString = "Page {0} of {1}"; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrRichText5, this.xrRichText4, this.xrRichText3, this.xrRichText2, this.xrRichText1, this.label1, this.xrLabel1 }); this.ReportHeader.HeightF = 75.79166F; this.ReportHeader.Name = "ReportHeader"; // // xrRichText5 // this.xrRichText5.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText5.LocationFloat = new DevExpress.Utils.PointFloat(6.00001F, 52.79166F); this.xrRichText5.Name = "xrRichText5"; this.xrRichText5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText5.SerializableRtfString = resources.GetString("xrRichText5.SerializableRtfString"); this.xrRichText5.SizeF = new System.Drawing.SizeF(1090F, 23F); // // xrRichText4 // this.xrRichText4.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText4.LocationFloat = new DevExpress.Utils.PointFloat(837.7083F, 29.79166F); this.xrRichText4.Name = "xrRichText4"; this.xrRichText4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText4.SerializableRtfString = resources.GetString("xrRichText4.SerializableRtfString"); this.xrRichText4.SizeF = new System.Drawing.SizeF(258.2914F, 23F); // // xrRichText3 // this.xrRichText3.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText3.LocationFloat = new DevExpress.Utils.PointFloat(59.99997F, 32.52767F); this.xrRichText3.Name = "xrRichText3"; this.xrRichText3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText3.SerializableRtfString = resources.GetString("xrRichText3.SerializableRtfString"); this.xrRichText3.SizeF = new System.Drawing.SizeF(100F, 23F); // // xrRichText2 // this.xrRichText2.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText2.LocationFloat = new DevExpress.Utils.PointFloat(796.0045F, 29.79166F); this.xrRichText2.Name = "xrRichText2"; this.xrRichText2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText2.SerializableRtfString = resources.GetString("xrRichText2.SerializableRtfString"); this.xrRichText2.SizeF = new System.Drawing.SizeF(100F, 23F); // // xrRichText1 // this.xrRichText1.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 32.52767F); this.xrRichText1.Name = "xrRichText1"; this.xrRichText1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText1.SerializableRtfString = resources.GetString("xrRichText1.SerializableRtfString"); this.xrRichText1.SizeF = new System.Drawing.SizeF(100F, 23F); // // label1 // this.label1.Font = new System.Drawing.Font("Arial", 14.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Underline)))); this.label1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 6.00001F); this.label1.Name = "label1"; this.label1.SizeF = new System.Drawing.SizeF(1102F, 24.19433F); this.label1.StyleName = "Title"; this.label1.StylePriority.UseFont = false; this.label1.StylePriority.UseTextAlignment = false; this.label1.Text = "NEW HIGHER EDUCATION CENTRE (PVT) LTD"; this.label1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrLabel1 // this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 30.19434F); 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(1102F, 23F); this.xrLabel1.StylePriority.UseTextAlignment = false; this.xrLabel1.Text = "No 58, New Rosita Town Kotagala. T.P 0774009942"; this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.table1 }); this.GroupHeader1.GroupUnion = DevExpress.XtraReports.UI.GroupUnion.WithFirstDetail; this.GroupHeader1.HeightF = 28F; this.GroupHeader1.Name = "GroupHeader1"; // // table1 // this.table1.LocationFloat = new DevExpress.Utils.PointFloat(10.00002F, 0F); this.table1.Name = "table1"; this.table1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.tableRow1 }); this.table1.SizeF = new System.Drawing.SizeF(1086F, 28F); // // tableRow1 // this.tableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.tableCell3, this.tableCell4, this.tableCell5, this.tableCell6, this.tableCell7, this.tableCell8, this.tableCell9, this.tableCell10, this.tableCell11, this.tableCell12, this.tableCell13, this.tableCell14, this.tableCell15 }); this.tableRow1.Name = "tableRow1"; this.tableRow1.Weight = 1D; // // tableCell3 // this.tableCell3.Name = "tableCell3"; this.tableCell3.StyleName = "DetailCaption1"; this.tableCell3.Text = "Student ID"; this.tableCell3.Weight = 0.079774768669009D; // // tableCell4 // this.tableCell4.Name = "tableCell4"; this.tableCell4.StyleName = "DetailCaption1"; this.tableCell4.Text = "Firstname"; this.tableCell4.Weight = 0.10266375389109997D; // // tableCell5 // this.tableCell5.Name = "tableCell5"; this.tableCell5.StyleName = "DetailCaption1"; this.tableCell5.Text = "Lastname"; this.tableCell5.Weight = 0.095950193909662668D; // // tableCell6 // this.tableCell6.Name = "tableCell6"; this.tableCell6.StyleName = "DetailCaption1"; this.tableCell6.Text = "School"; this.tableCell6.Weight = 0.14284460073837038D; // // tableCell7 // this.tableCell7.Name = "tableCell7"; this.tableCell7.StyleName = "DetailCaption1"; this.tableCell7.StylePriority.UseTextAlignment = false; this.tableCell7.Text = "Economics"; this.tableCell7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell7.Weight = 0.081172662606911D; // // tableCell8 // this.tableCell8.Name = "tableCell8"; this.tableCell8.StyleName = "DetailCaption1"; this.tableCell8.StylePriority.UseTextAlignment = false; this.tableCell8.Text = "Business"; this.tableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell8.Weight = 0.067197651273149417D; // // tableCell9 // this.tableCell9.Name = "tableCell9"; this.tableCell9.StyleName = "DetailCaption1"; this.tableCell9.StylePriority.UseTextAlignment = false; this.tableCell9.Text = "Accounts"; this.tableCell9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell9.Weight = 0.079280691294467839D; // // tableCell10 // this.tableCell10.Name = "tableCell10"; this.tableCell10.StyleName = "DetailCaption1"; this.tableCell10.StylePriority.UseTextAlignment = false; this.tableCell10.Text = "total marks"; this.tableCell10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell10.Weight = 0.0849242074857192D; // // tableCell11 // this.tableCell11.Name = "tableCell11"; this.tableCell11.StyleName = "DetailCaption1"; this.tableCell11.StylePriority.UseTextAlignment = false; this.tableCell11.Text = "Rank"; this.tableCell11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell11.Weight = 0.069379326833895D; // // tableCell12 // this.tableCell12.Name = "tableCell12"; this.tableCell12.StyleName = "DetailCaption1"; this.tableCell12.Text = "Pass State"; this.tableCell12.Weight = 0.11116139427665917D; // // tableCell13 // this.tableCell13.Name = "tableCell13"; this.tableCell13.StyleName = "DetailCaption1"; this.tableCell13.StylePriority.UseTextAlignment = false; this.tableCell13.Text = "Average marks"; this.tableCell13.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell13.Weight = 0.10171524525298425D; // // tableCell14 // this.tableCell14.Name = "tableCell14"; this.tableCell14.StyleName = "DetailCaption1"; this.tableCell14.StylePriority.UseTextAlignment = false; this.tableCell14.Text = "English"; this.tableCell14.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell14.Weight = 0.065806881584006258D; // // tableCell15 // this.tableCell15.Name = "tableCell15"; this.tableCell15.StyleName = "DetailCaption1"; this.tableCell15.StylePriority.UseTextAlignment = false; this.tableCell15.Text = "GIT"; this.tableCell15.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell15.Weight = 0.038871500937304196D; // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.table2 }); this.Detail.HeightF = 25F; this.Detail.Name = "Detail"; this.Detail.SortFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("average_marks", DevExpress.XtraReports.UI.XRColumnSortOrder.Descending) }); // // table2 // this.table2.LocationFloat = new DevExpress.Utils.PointFloat(10.00007F, 0F); this.table2.Name = "table2"; this.table2.OddStyleName = "DetailData3_Odd"; this.table2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.tableRow2 }); this.table2.SizeF = new System.Drawing.SizeF(1086F, 25F); // // tableRow2 // this.tableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.tableCell19, this.tableCell20, this.tableCell21, this.tableCell22, this.tableCell23, this.tableCell24, this.tableCell25, this.tableCell26, this.tableCell27, this.tableCell28, this.tableCell29, this.tableCell30, this.tableCell31 }); this.tableRow2.Name = "tableRow2"; this.tableRow2.Weight = 11.5D; // // tableCell19 // this.tableCell19.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[regid]") }); this.tableCell19.Name = "tableCell19"; this.tableCell19.StyleName = "DetailData1"; this.tableCell19.Weight = 0.0797747140068075D; // // tableCell20 // this.tableCell20.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Firstname]") }); this.tableCell20.Name = "tableCell20"; this.tableCell20.StyleName = "DetailData1"; this.tableCell20.Weight = 0.10266376115911594D; // // tableCell21 // this.tableCell21.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Lastname]") }); this.tableCell21.Name = "tableCell21"; this.tableCell21.StyleName = "DetailData1"; this.tableCell21.Weight = 0.095950193412323651D; // // tableCell22 // this.tableCell22.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Al_school]") }); this.tableCell22.Name = "tableCell22"; this.tableCell22.StyleName = "DetailData1"; this.tableCell22.Weight = 0.1568195471743325D; // // tableCell23 // this.tableCell23.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[subject_1]") }); this.tableCell23.Name = "tableCell23"; this.tableCell23.StyleName = "DetailData1"; this.tableCell23.StylePriority.UseTextAlignment = false; this.tableCell23.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell23.TextFormatString = "{0:#.00}"; this.tableCell23.Weight = 0.067197722916263539D; // // tableCell24 // this.tableCell24.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[subject_2]") }); this.tableCell24.Name = "tableCell24"; this.tableCell24.StyleName = "DetailData1"; this.tableCell24.StylePriority.UseTextAlignment = false; this.tableCell24.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell24.TextFormatString = "{0:#.00}"; this.tableCell24.Weight = 0.067197600877450567D; // // tableCell25 // this.tableCell25.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[subject_3]") }); this.tableCell25.Name = "tableCell25"; this.tableCell25.StyleName = "DetailData1"; this.tableCell25.StylePriority.UseTextAlignment = false; this.tableCell25.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell25.TextFormatString = "{0:#.00}"; this.tableCell25.Weight = 0.079280821218360845D; // // tableCell26 // this.tableCell26.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[total_marks]") }); this.tableCell26.Name = "tableCell26"; this.tableCell26.StyleName = "DetailData1"; this.tableCell26.StylePriority.UseTextAlignment = false; this.tableCell26.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell26.TextFormatString = "{0:#.00}"; this.tableCell26.Weight = 0.084924089389064109D; // // tableCell27 // this.tableCell27.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[DataSource.CurrentRowIndex]+1\n") }); this.tableCell27.Name = "tableCell27"; this.tableCell27.StyleName = "DetailData1"; this.tableCell27.StylePriority.UseTextAlignment = false; this.tableCell27.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell27.Weight = 0.069379456774063583D; // // tableCell28 // this.tableCell28.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[avg_state]") }); this.tableCell28.Name = "tableCell28"; this.tableCell28.StyleName = "DetailData1"; this.tableCell28.Weight = 0.11116138644541714D; // // tableCell29 // this.tableCell29.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[average_marks]") }); this.tableCell29.Name = "tableCell29"; this.tableCell29.StyleName = "DetailData1"; this.tableCell29.StylePriority.UseTextAlignment = false; this.tableCell29.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell29.TextFormatString = "{0:#.00}"; this.tableCell29.Weight = 0.10171523738169033D; // // tableCell30 // this.tableCell30.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[English]") }); this.tableCell30.Name = "tableCell30"; this.tableCell30.StyleName = "DetailData1"; this.tableCell30.StylePriority.UseTextAlignment = false; this.tableCell30.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell30.TextFormatString = "{0:#.00}"; this.tableCell30.Weight = 0.065806759552253041D; // // tableCell31 // this.tableCell31.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[git]") }); this.tableCell31.Name = "tableCell31"; this.tableCell31.StyleName = "DetailData1"; this.tableCell31.StylePriority.UseTextAlignment = false; this.tableCell31.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight; this.tableCell31.TextFormatString = "{0:#.00}"; this.tableCell31.Weight = 0.038871313951257591D; // // Batch // this.Batch.Description = "Batch"; this.Batch.Name = "Batch"; dynamicListLookUpSettings1.DataMember = "view_exam_results_summary"; dynamicListLookUpSettings1.DataSource = this.sqlDataSource1; dynamicListLookUpSettings1.DisplayMember = "batch"; dynamicListLookUpSettings1.SortMember = null; dynamicListLookUpSettings1.ValueMember = "batch"; this.Batch.ValueSourceSettings = dynamicListLookUpSettings1; // // Exam // this.Exam.Description = "Exam"; this.Exam.Name = "Exam"; dynamicListLookUpSettings2.DataMember = "view_exam_results_summary"; dynamicListLookUpSettings2.DataSource = this.sqlDataSource1; dynamicListLookUpSettings2.DisplayMember = "exam"; dynamicListLookUpSettings2.FilterString = "[batch] = ?Batch"; dynamicListLookUpSettings2.ValueMember = "exam"; this.Exam.ValueSourceSettings = dynamicListLookUpSettings2; // // ReportExamResultSummary // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.TopMargin, this.BottomMargin, this.ReportHeader, this.GroupHeader1, this.Detail }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "view_exam_results_summary"; this.DataSource = this.sqlDataSource1; this.FilterString = "[batch] = ?Batch And [exam] = ?Exam"; this.Font = new System.Drawing.Font("Arial", 9.75F); this.Landscape = true; this.Margins = new System.Drawing.Printing.Margins(25, 38, 27, 47); this.PageHeight = 827; this.PageWidth = 1169; this.PaperKind = System.Drawing.Printing.PaperKind.A4; this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] { this.Batch, this.Exam }); this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.DetailCaption1, this.DetailData1, this.DetailData3_Odd, this.PageInfo }); this.Version = "19.2"; ((System.ComponentModel.ISupportInitialize)(this.xrRichText5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.table1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.table2)).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.ConnectionParameters.CustomStringConnectionParameters customStringConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.CustomStringConnectionParameters(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ReportFeePayment)); 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 table3 = 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.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings2 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings3 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings4 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); this.Title = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailCaption1 = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailData1 = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailData3_Odd = new DevExpress.XtraReports.UI.XRControlStyle(); this.PageInfo = new DevExpress.XtraReports.UI.XRControlStyle(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrRichText4 = new DevExpress.XtraReports.UI.XRRichText(); this.label1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.pageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.pageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrRichText3 = new DevExpress.XtraReports.UI.XRRichText(); this.xrRichText2 = new DevExpress.XtraReports.UI.XRRichText(); this.xrRichText1 = new DevExpress.XtraReports.UI.XRRichText(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.table1 = new DevExpress.XtraReports.UI.XRTable(); this.tableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.tableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell10 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell11 = new DevExpress.XtraReports.UI.XRTableCell(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.table2 = new DevExpress.XtraReports.UI.XRTable(); this.tableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.tableCell16 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell17 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell18 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell20 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell21 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell22 = new DevExpress.XtraReports.UI.XRTableCell(); this.Batch = new DevExpress.XtraReports.Parameters.Parameter(); this.Year = new DevExpress.XtraReports.Parameters.Parameter(); this.Month = new DevExpress.XtraReports.Parameters.Parameter(); this.Payment_state = new DevExpress.XtraReports.Parameters.Parameter(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.table1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.table2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // sqlDataSource1 // this.sqlDataSource1.ConnectionName = "ec2amaz-1vsojpn.proadmin_v1.dbo"; customStringConnectionParameters1.ConnectionString = resources.GetString("customStringConnectionParameters1.ConnectionString"); this.sqlDataSource1.ConnectionParameters = customStringConnectionParameters1; this.sqlDataSource1.Name = "sqlDataSource1"; columnExpression1.ColumnName = "id"; table3.Name = "view_payment_summary"; columnExpression1.Table = table3; column1.Expression = columnExpression1; columnExpression2.ColumnName = "feeschedule"; columnExpression2.Table = table3; column2.Expression = columnExpression2; columnExpression3.ColumnName = "year"; columnExpression3.Table = table3; column3.Expression = columnExpression3; columnExpression4.ColumnName = "batch"; columnExpression4.Table = table3; column4.Expression = columnExpression4; columnExpression5.ColumnName = "regid"; columnExpression5.Table = table3; column5.Expression = columnExpression5; columnExpression6.ColumnName = "Firstname"; columnExpression6.Table = table3; column6.Expression = columnExpression6; columnExpression7.ColumnName = "Lastname"; columnExpression7.Table = table3; column7.Expression = columnExpression7; columnExpression8.ColumnName = "payment"; columnExpression8.Table = table3; column8.Expression = columnExpression8; columnExpression9.ColumnName = "amount"; columnExpression9.Table = table3; column9.Expression = columnExpression9; columnExpression10.ColumnName = "payment_date"; columnExpression10.Table = table3; column10.Expression = columnExpression10; columnExpression11.ColumnName = "Al_school"; columnExpression11.Table = table3; column11.Expression = columnExpression11; 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.Name = "view_payment_summary"; selectQuery1.Tables.Add(table3); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { selectQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // Title // this.Title.BackColor = System.Drawing.Color.Transparent; this.Title.BorderColor = System.Drawing.Color.Black; this.Title.Borders = DevExpress.XtraPrinting.BorderSide.None; this.Title.BorderWidth = 1F; this.Title.Font = new System.Drawing.Font("Arial", 14.25F); this.Title.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(70)))), ((int)(((byte)(80))))); this.Title.Name = "Title"; // // DetailCaption1 // this.DetailCaption1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(93)))), ((int)(((byte)(98)))), ((int)(((byte)(110))))); this.DetailCaption1.BorderColor = System.Drawing.Color.White; this.DetailCaption1.Borders = DevExpress.XtraPrinting.BorderSide.Left; this.DetailCaption1.BorderWidth = 2F; this.DetailCaption1.Font = new System.Drawing.Font("Arial", 8.25F, System.Drawing.FontStyle.Bold); this.DetailCaption1.ForeColor = System.Drawing.Color.White; this.DetailCaption1.Name = "DetailCaption1"; this.DetailCaption1.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailCaption1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // DetailData1 // this.DetailData1.BorderColor = System.Drawing.Color.Transparent; this.DetailData1.Borders = DevExpress.XtraPrinting.BorderSide.Left; this.DetailData1.BorderWidth = 2F; this.DetailData1.Font = new System.Drawing.Font("Arial", 8.25F); this.DetailData1.ForeColor = System.Drawing.Color.Black; this.DetailData1.Name = "DetailData1"; this.DetailData1.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailData1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // DetailData3_Odd // this.DetailData3_Odd.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(243)))), ((int)(((byte)(245)))), ((int)(((byte)(248))))); this.DetailData3_Odd.BorderColor = System.Drawing.Color.Transparent; this.DetailData3_Odd.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DetailData3_Odd.BorderWidth = 1F; this.DetailData3_Odd.Font = new System.Drawing.Font("Arial", 8.25F); this.DetailData3_Odd.ForeColor = System.Drawing.Color.Black; this.DetailData3_Odd.Name = "DetailData3_Odd"; this.DetailData3_Odd.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailData3_Odd.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // PageInfo // this.PageInfo.Font = new System.Drawing.Font("Arial", 8.25F, System.Drawing.FontStyle.Bold); this.PageInfo.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(70)))), ((int)(((byte)(80))))); this.PageInfo.Name = "PageInfo"; this.PageInfo.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // TopMargin // this.TopMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel5, this.xrRichText4, this.label1, this.xrLabel4 }); this.TopMargin.HeightF = 114.5833F; this.TopMargin.Name = "TopMargin"; // // xrLabel5 // this.xrLabel5.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[payment]") }); this.xrLabel5.Font = new System.Drawing.Font("Arial", 9.75F, ((System.Drawing.FontStyle)(((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic) | System.Drawing.FontStyle.Underline)))); this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(308.2993F, 80.19434F); this.xrLabel5.Multiline = true; this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel5.SizeF = new System.Drawing.SizeF(100F, 23F); this.xrLabel5.StylePriority.UseFont = false; this.xrLabel5.StylePriority.UseTextAlignment = false; this.xrLabel5.Text = "xrLabel5"; this.xrLabel5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrRichText4 // this.xrRichText4.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText4.LocationFloat = new DevExpress.Utils.PointFloat(250.125F, 57.19434F); this.xrRichText4.Name = "xrRichText4"; this.xrRichText4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText4.SerializableRtfString = resources.GetString("xrRichText4.SerializableRtfString"); this.xrRichText4.SizeF = new System.Drawing.SizeF(230.2083F, 23F); // // label1 // this.label1.Font = new System.Drawing.Font("Arial", 14.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Underline)))); this.label1.LocationFloat = new DevExpress.Utils.PointFloat(48.04166F, 10.00001F); this.label1.Name = "label1"; this.label1.SizeF = new System.Drawing.SizeF(625.6593F, 24.19433F); this.label1.StyleName = "Title"; this.label1.StylePriority.UseFont = false; this.label1.StylePriority.UseTextAlignment = false; this.label1.Text = "NEW HIGHER EDUCATION CENTRE (PVT) LTD"; this.label1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrLabel4 // this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(48.04166F, 34.19434F); this.xrLabel4.Multiline = true; this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(625.6593F, 23F); this.xrLabel4.StylePriority.UseTextAlignment = false; this.xrLabel4.Text = "No 58, New Rosita Town Kotagala. T.P 0774009942"; this.xrLabel4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // BottomMargin // this.BottomMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.pageInfo1, this.pageInfo2 }); this.BottomMargin.Name = "BottomMargin"; // // pageInfo1 // this.pageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 6F); this.pageInfo1.Name = "pageInfo1"; this.pageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.pageInfo1.SizeF = new System.Drawing.SizeF(301.5F, 23F); this.pageInfo1.StyleName = "PageInfo"; // // pageInfo2 // this.pageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(417.5F, 0F); this.pageInfo2.Name = "pageInfo2"; this.pageInfo2.SizeF = new System.Drawing.SizeF(301.5F, 23F); this.pageInfo2.StyleName = "PageInfo"; this.pageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; this.pageInfo2.TextFormatString = "Page {0} of {1}"; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel3, this.xrLabel2, this.xrLabel1, this.xrRichText3, this.xrRichText2, this.xrRichText1 }); this.ReportHeader.HeightF = 60F; this.ReportHeader.Name = "ReportHeader"; // // xrLabel3 // this.xrLabel3.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[year]") }); this.xrLabel3.Font = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold); this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(598.0417F, 18.75F); this.xrLabel3.Multiline = true; this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(100F, 23F); this.xrLabel3.StylePriority.UseFont = false; this.xrLabel3.Text = "xrLabel3"; // // xrLabel2 // this.xrLabel2.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[feeschedule]") }); this.xrLabel2.Font = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold); this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(349.5148F, 18.75F); this.xrLabel2.Multiline = true; this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(100F, 23F); this.xrLabel2.StylePriority.UseFont = false; this.xrLabel2.Text = "xrLabel2"; // // xrLabel1 // this.xrLabel1.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[batch]") }); this.xrLabel1.Font = new System.Drawing.Font("Arial", 9.75F, System.Drawing.FontStyle.Bold); this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(74.83355F, 18.75F); 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(100F, 23F); this.xrLabel1.StylePriority.UseFont = false; this.xrLabel1.Text = "xrLabel1"; // // xrRichText3 // this.xrRichText3.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText3.LocationFloat = new DevExpress.Utils.PointFloat(539.3881F, 18.75F); this.xrRichText3.Name = "xrRichText3"; this.xrRichText3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText3.SerializableRtfString = resources.GetString("xrRichText3.SerializableRtfString"); this.xrRichText3.SizeF = new System.Drawing.SizeF(100F, 23F); this.xrRichText3.StylePriority.UseFont = false; // // xrRichText2 // this.xrRichText2.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText2.LocationFloat = new DevExpress.Utils.PointFloat(295.0907F, 18.75F); this.xrRichText2.Name = "xrRichText2"; this.xrRichText2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText2.SerializableRtfString = resources.GetString("xrRichText2.SerializableRtfString"); this.xrRichText2.SizeF = new System.Drawing.SizeF(100F, 23F); this.xrRichText2.StylePriority.UseFont = false; // // xrRichText1 // this.xrRichText1.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText1.LocationFloat = new DevExpress.Utils.PointFloat(23.04166F, 18.75F); this.xrRichText1.Name = "xrRichText1"; this.xrRichText1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText1.SerializableRtfString = resources.GetString("xrRichText1.SerializableRtfString"); this.xrRichText1.SizeF = new System.Drawing.SizeF(100F, 23F); this.xrRichText1.StylePriority.UseFont = false; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.table1 }); this.GroupHeader1.GroupUnion = DevExpress.XtraReports.UI.GroupUnion.WithFirstDetail; this.GroupHeader1.HeightF = 28F; this.GroupHeader1.Name = "GroupHeader1"; // // table1 // this.table1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.table1.Name = "table1"; this.table1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.tableRow1 }); this.table1.SizeF = new System.Drawing.SizeF(719F, 28F); // // tableRow1 // this.tableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.tableCell5, this.tableCell6, this.tableCell7, this.tableCell9, this.tableCell10, this.tableCell11 }); this.tableRow1.Name = "tableRow1"; this.tableRow1.Weight = 1D; // // tableCell5 // this.tableCell5.Name = "tableCell5"; this.tableCell5.StyleName = "DetailCaption1"; this.tableCell5.Text = "Student ID"; this.tableCell5.Weight = 0.119351750633908D; // // tableCell6 // this.tableCell6.Name = "tableCell6"; this.tableCell6.StyleName = "DetailCaption1"; this.tableCell6.Text = "Firstname"; this.tableCell6.Weight = 0.21130971911834021D; // // tableCell7 // this.tableCell7.Name = "tableCell7"; this.tableCell7.StyleName = "DetailCaption1"; this.tableCell7.Text = "Lastname"; this.tableCell7.Weight = 0.16104379550920558D; // // tableCell9 // this.tableCell9.Name = "tableCell9"; this.tableCell9.StyleName = "DetailCaption1"; this.tableCell9.Text = "Amount"; this.tableCell9.Weight = 0.11391394906189276D; // // tableCell10 // this.tableCell10.Name = "tableCell10"; this.tableCell10.StyleName = "DetailCaption1"; this.tableCell10.Text = "Payment Date Time"; this.tableCell10.Weight = 0.22972875176224578D; // // tableCell11 // this.tableCell11.Name = "tableCell11"; this.tableCell11.StyleName = "DetailCaption1"; this.tableCell11.Text = "School"; this.tableCell11.Weight = 0.31138260938355833D; // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.table2 }); this.Detail.HeightF = 25F; this.Detail.Name = "Detail"; // // table2 // this.table2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.table2.Name = "table2"; this.table2.OddStyleName = "DetailData3_Odd"; this.table2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.tableRow2 }); this.table2.SizeF = new System.Drawing.SizeF(719F, 25F); // // tableRow2 // this.tableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.tableCell16, this.tableCell17, this.tableCell18, this.tableCell20, this.tableCell21, this.tableCell22 }); this.tableRow2.Name = "tableRow2"; this.tableRow2.Weight = 11.5D; // // tableCell16 // this.tableCell16.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[regid]") }); this.tableCell16.Name = "tableCell16"; this.tableCell16.StyleName = "DetailData1"; this.tableCell16.Weight = 0.11935176166329391D; // // tableCell17 // this.tableCell17.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Firstname]") }); this.tableCell17.Name = "tableCell17"; this.tableCell17.StyleName = "DetailData1"; this.tableCell17.Weight = 0.21130970472244476D; // // tableCell18 // this.tableCell18.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Lastname]") }); this.tableCell18.Name = "tableCell18"; this.tableCell18.StyleName = "DetailData1"; this.tableCell18.Weight = 0.16104389170355996D; // // tableCell20 // this.tableCell20.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[amount]") }); this.tableCell20.Name = "tableCell20"; this.tableCell20.StyleName = "DetailData1"; this.tableCell20.Weight = 0.1139137592398341D; // // tableCell21 // this.tableCell21.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[payment_date]") }); this.tableCell21.Name = "tableCell21"; this.tableCell21.StyleName = "DetailData1"; this.tableCell21.Weight = 0.2297288473322375D; // // tableCell22 // this.tableCell22.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Al_school]") }); this.tableCell22.Name = "tableCell22"; this.tableCell22.StyleName = "DetailData1"; this.tableCell22.Weight = 0.31138258415109188D; // // Batch // this.Batch.Description = "Batch"; this.Batch.Name = "Batch"; dynamicListLookUpSettings1.DataMember = "view_payment_summary"; dynamicListLookUpSettings1.DataSource = this.sqlDataSource1; dynamicListLookUpSettings1.DisplayMember = "batch"; dynamicListLookUpSettings1.SortMember = null; dynamicListLookUpSettings1.ValueMember = "batch"; this.Batch.ValueSourceSettings = dynamicListLookUpSettings1; // // Year // this.Year.Description = "Year"; this.Year.Name = "Year"; dynamicListLookUpSettings2.DataMember = "view_payment_summary"; dynamicListLookUpSettings2.DataSource = this.sqlDataSource1; dynamicListLookUpSettings2.DisplayMember = "year"; dynamicListLookUpSettings2.FilterString = "[batch] = ?Batch"; dynamicListLookUpSettings2.ValueMember = "year"; this.Year.ValueSourceSettings = dynamicListLookUpSettings2; // // Month // this.Month.Description = "Month"; this.Month.Name = "Month"; dynamicListLookUpSettings3.DataMember = "view_payment_summary"; dynamicListLookUpSettings3.DataSource = this.sqlDataSource1; dynamicListLookUpSettings3.DisplayMember = "feeschedule"; dynamicListLookUpSettings3.FilterString = "[batch] = ?Batch And [year] = ?Year"; dynamicListLookUpSettings3.ValueMember = "feeschedule"; this.Month.ValueSourceSettings = dynamicListLookUpSettings3; // // Payment_state // this.Payment_state.Description = "Payment_state"; this.Payment_state.Name = "Payment_state"; dynamicListLookUpSettings4.DataMember = "view_payment_summary"; dynamicListLookUpSettings4.DataSource = this.sqlDataSource1; dynamicListLookUpSettings4.DisplayMember = "payment"; dynamicListLookUpSettings4.SortMember = null; dynamicListLookUpSettings4.ValueMember = "payment"; this.Payment_state.ValueSourceSettings = dynamicListLookUpSettings4; // // ReportFeePayment // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.TopMargin, this.BottomMargin, this.ReportHeader, this.GroupHeader1, this.Detail }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "view_payment_summary"; this.DataSource = this.sqlDataSource1; this.FilterString = "[batch] = ?Batch And [year] = ?Year And [feeschedule] = ?Month And [payment] = ?P" + "ayment_state"; this.Font = new System.Drawing.Font("Arial", 9.75F); this.Margins = new System.Drawing.Printing.Margins(53, 55, 115, 100); this.PageHeight = 1169; this.PageWidth = 827; this.PaperKind = System.Drawing.Printing.PaperKind.A4; this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] { this.Batch, this.Year, this.Month, this.Payment_state }); this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.DetailCaption1, this.DetailData1, this.DetailData3_Odd, this.PageInfo }); this.Version = "19.2"; ((System.ComponentModel.ISupportInitialize)(this.xrRichText4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.table1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.table2)).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(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(rep_liste_equipements_sortis)); DevExpress.DataAccess.ConnectionParameters.CustomStringConnectionParameters customStringConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.CustomStringConnectionParameters(); DevExpress.DataAccess.Sql.StoredProcQuery storedProcQuery1 = new DevExpress.DataAccess.Sql.StoredProcQuery(); DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.QueryParameter queryParameter2 = new DevExpress.DataAccess.Sql.QueryParameter(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel10 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel12 = new DevExpress.XtraReports.UI.XRLabel(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.xrPictureBox2 = new DevExpress.XtraReports.UI.XRPictureBox(); this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); this.groupHeaderBand1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.groupHeaderBand2 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.pageFooterBand1 = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrLine2 = new DevExpress.XtraReports.UI.XRLine(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.reportHeaderBand1 = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel13 = new DevExpress.XtraReports.UI.XRLabel(); this.Title = new DevExpress.XtraReports.UI.XRControlStyle(); this.FieldCaption = new DevExpress.XtraReports.UI.XRControlStyle(); this.PageInfo = new DevExpress.XtraReports.UI.XRControlStyle(); this.DataField = new DevExpress.XtraReports.UI.XRControlStyle(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel8, this.xrLabel9, this.xrLabel10, this.xrLabel11, this.xrLabel12 }); this.Detail.HeightF = 25.33334F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.StyleName = "DataField"; this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrLabel6 // this.xrLabel6.BackColor = System.Drawing.Color.Black; this.xrLabel6.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel6.Font = new System.Drawing.Font("Arial Narrow", 12F, System.Drawing.FontStyle.Bold); this.xrLabel6.ForeColor = System.Drawing.Color.White; this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(809.3751F, 0F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel6.SizeF = new System.Drawing.SizeF(90.62488F, 25.33334F); this.xrLabel6.StylePriority.UseBackColor = false; this.xrLabel6.StylePriority.UseBorders = false; this.xrLabel6.StylePriority.UseFont = false; this.xrLabel6.StylePriority.UseForeColor = false; this.xrLabel6.StylePriority.UseTextAlignment = false; this.xrLabel6.Text = "QTE"; this.xrLabel6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrLabel5 // this.xrLabel5.BackColor = System.Drawing.Color.Black; this.xrLabel5.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel5.Font = new System.Drawing.Font("Arial Narrow", 12F, System.Drawing.FontStyle.Bold); this.xrLabel5.ForeColor = System.Drawing.Color.White; this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(565.6251F, 0F); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel5.SizeF = new System.Drawing.SizeF(243.75F, 25.33334F); this.xrLabel5.StylePriority.UseBackColor = false; this.xrLabel5.StylePriority.UseBorders = false; this.xrLabel5.StylePriority.UseFont = false; this.xrLabel5.StylePriority.UseForeColor = false; this.xrLabel5.StylePriority.UseTextAlignment = false; this.xrLabel5.Text = "MOTIF SORTIE"; this.xrLabel5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrLabel4 // this.xrLabel4.BackColor = System.Drawing.Color.Black; this.xrLabel4.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel4.Font = new System.Drawing.Font("Arial Narrow", 12F, System.Drawing.FontStyle.Bold); this.xrLabel4.ForeColor = System.Drawing.Color.White; this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(351.0417F, 0F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(214.5834F, 25.33334F); this.xrLabel4.StylePriority.UseBackColor = false; this.xrLabel4.StylePriority.UseBorders = false; this.xrLabel4.StylePriority.UseFont = false; this.xrLabel4.StylePriority.UseForeColor = false; this.xrLabel4.StylePriority.UseTextAlignment = false; this.xrLabel4.Text = "PERSONNEL"; this.xrLabel4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrLabel3 // this.xrLabel3.BackColor = System.Drawing.Color.Black; this.xrLabel3.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel3.Font = new System.Drawing.Font("Arial Narrow", 12F, System.Drawing.FontStyle.Bold); this.xrLabel3.ForeColor = System.Drawing.Color.White; this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(151.0417F, 0F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(200F, 25.33334F); this.xrLabel3.StylePriority.UseBackColor = false; this.xrLabel3.StylePriority.UseBorders = false; this.xrLabel3.StylePriority.UseFont = false; this.xrLabel3.StylePriority.UseForeColor = false; this.xrLabel3.StylePriority.UseTextAlignment = false; this.xrLabel3.Text = "EQUIPEMENT"; this.xrLabel3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrLabel8 // this.xrLabel8.BackColor = System.Drawing.Color.White; this.xrLabel8.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "liste_equipements_sorties.code_attribution") }); this.xrLabel8.Font = new System.Drawing.Font("Arial Narrow", 10F, System.Drawing.FontStyle.Bold); this.xrLabel8.ForeColor = System.Drawing.Color.Black; this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel8.SizeF = new System.Drawing.SizeF(151.0417F, 25.33334F); this.xrLabel8.StylePriority.UseBackColor = false; this.xrLabel8.StylePriority.UseBorders = false; this.xrLabel8.StylePriority.UseFont = false; this.xrLabel8.StylePriority.UseForeColor = false; this.xrLabel8.StylePriority.UseTextAlignment = false; this.xrLabel8.Text = "xrLabel8"; this.xrLabel8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrLabel9 // this.xrLabel9.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.xrLabel9.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "liste_equipements_sorties.code_produit") }); this.xrLabel9.Font = new System.Drawing.Font("Arial Narrow", 10F, System.Drawing.FontStyle.Bold); this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(151.0417F, 0F); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel9.SizeF = new System.Drawing.SizeF(200F, 25.33334F); this.xrLabel9.StylePriority.UseBorderDashStyle = false; this.xrLabel9.StylePriority.UseBorders = false; this.xrLabel9.StylePriority.UseFont = false; this.xrLabel9.StylePriority.UseTextAlignment = false; this.xrLabel9.Text = "xrLabel9"; this.xrLabel9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrLabel10 // this.xrLabel10.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.xrLabel10.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "liste_equipements_sorties.concerne_demande") }); this.xrLabel10.Font = new System.Drawing.Font("Arial Narrow", 10F, System.Drawing.FontStyle.Bold); this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(565.6251F, 0F); this.xrLabel10.Name = "xrLabel10"; this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel10.SizeF = new System.Drawing.SizeF(243.75F, 25.33334F); this.xrLabel10.StylePriority.UseBorderDashStyle = false; this.xrLabel10.StylePriority.UseBorders = false; this.xrLabel10.StylePriority.UseFont = false; this.xrLabel10.StylePriority.UseTextAlignment = false; this.xrLabel10.Text = "xrLabel10"; this.xrLabel10.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrLabel11 // this.xrLabel11.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.xrLabel11.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "liste_equipements_sorties.noms_agent") }); this.xrLabel11.Font = new System.Drawing.Font("Arial Narrow", 10F, System.Drawing.FontStyle.Bold); this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(351.0417F, 0F); this.xrLabel11.Name = "xrLabel11"; this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel11.SizeF = new System.Drawing.SizeF(214.5834F, 25.33334F); this.xrLabel11.StylePriority.UseBorderDashStyle = false; this.xrLabel11.StylePriority.UseBorders = false; this.xrLabel11.StylePriority.UseFont = false; this.xrLabel11.StylePriority.UseTextAlignment = false; this.xrLabel11.Text = "xrLabel11"; this.xrLabel11.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // xrLabel12 // this.xrLabel12.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.xrLabel12.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "liste_equipements_sorties.qte_attribue") }); this.xrLabel12.Font = new System.Drawing.Font("Arial Narrow", 10F, System.Drawing.FontStyle.Bold); this.xrLabel12.LocationFloat = new DevExpress.Utils.PointFloat(809.3749F, 0F); this.xrLabel12.Name = "xrLabel12"; this.xrLabel12.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel12.SizeF = new System.Drawing.SizeF(90.62512F, 25.33333F); this.xrLabel12.StylePriority.UseBorderDashStyle = false; this.xrLabel12.StylePriority.UseBorders = false; this.xrLabel12.StylePriority.UseFont = false; this.xrLabel12.StylePriority.UseTextAlignment = false; this.xrLabel12.Text = "xrLabel12"; this.xrLabel12.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // TopMargin // this.TopMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPictureBox2, this.xrPictureBox1 }); this.TopMargin.HeightF = 104.1667F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrPictureBox2 // this.xrPictureBox2.Image = ((System.Drawing.Image)(resources.GetObject("xrPictureBox2.Image"))); this.xrPictureBox2.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 10.00001F); this.xrPictureBox2.Name = "xrPictureBox2"; this.xrPictureBox2.SizeF = new System.Drawing.SizeF(111.7083F, 94.16666F); this.xrPictureBox2.Sizing = DevExpress.XtraPrinting.ImageSizeMode.StretchImage; // // xrPictureBox1 // this.xrPictureBox1.Image = ((System.Drawing.Image)(resources.GetObject("xrPictureBox1.Image"))); this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(782.2917F, 10.00001F); this.xrPictureBox1.Name = "xrPictureBox1"; this.xrPictureBox1.SizeF = new System.Drawing.SizeF(111.7083F, 94.16666F); this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.StretchImage; // // BottomMargin // this.BottomMargin.HeightF = 78.87497F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // sqlDataSource1 // this.sqlDataSource1.ConnectionName = "DESKTOP-PO0I2OH.db_logisitik.dbo"; customStringConnectionParameters1.ConnectionString = "XpoProvider=MSSqlServer;Data Source=DESKTOP-PO0I2OH;Initial Catalog=db_logisti" + "k;User ID=sa;[email protected]?"; this.sqlDataSource1.ConnectionParameters = customStringConnectionParameters1; this.sqlDataSource1.Name = "sqlDataSource1"; storedProcQuery1.Name = "liste_equipements_sorties"; queryParameter1.Name = "@date_un"; queryParameter1.Type = typeof(System.DateTime); queryParameter1.ValueInfo = "2017-01-01"; queryParameter2.Name = "@date_deux"; queryParameter2.Type = typeof(System.DateTime); queryParameter2.ValueInfo = "2017-07-01"; storedProcQuery1.Parameters.Add(queryParameter1); storedProcQuery1.Parameters.Add(queryParameter2); storedProcQuery1.StoredProcName = "liste_equipements_sorties"; this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { storedProcQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // groupHeaderBand1 // this.groupHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel2 }); this.groupHeaderBand1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("date_attribution", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.groupHeaderBand1.HeightF = 23.41668F; this.groupHeaderBand1.Level = 1; this.groupHeaderBand1.Name = "groupHeaderBand1"; // // xrLabel2 // this.xrLabel2.BackColor = System.Drawing.Color.Black; this.xrLabel2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "liste_equipements_sorties.date_attribution", "{0:d MMMM yyyy}") }); this.xrLabel2.Font = new System.Drawing.Font("Arial Narrow", 13F, System.Drawing.FontStyle.Bold); this.xrLabel2.ForeColor = System.Drawing.Color.White; this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(151.0417F, 20.70835F); this.xrLabel2.StyleName = "DataField"; this.xrLabel2.StylePriority.UseBackColor = false; this.xrLabel2.StylePriority.UseFont = false; this.xrLabel2.StylePriority.UseForeColor = false; this.xrLabel2.StylePriority.UseTextAlignment = false; this.xrLabel2.Text = "xrLabel2"; this.xrLabel2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // groupHeaderBand2 // this.groupHeaderBand2.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1, this.xrLabel3, this.xrLabel4, this.xrLabel5, this.xrLabel6 }); this.groupHeaderBand2.HeightF = 25.33334F; this.groupHeaderBand2.Name = "groupHeaderBand2"; this.groupHeaderBand2.StyleName = "FieldCaption"; // // pageFooterBand1 // this.pageFooterBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLine2, this.xrPageInfo1, this.xrPageInfo2 }); this.pageFooterBand1.HeightF = 31F; this.pageFooterBand1.Name = "pageFooterBand1"; // // xrLine2 // this.xrLine2.LocationFloat = new DevExpress.Utils.PointFloat(6F, 0F); this.xrLine2.Name = "xrLine2"; this.xrLine2.SizeF = new System.Drawing.SizeF(888F, 2F); // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 8F); this.xrPageInfo1.Name = "xrPageInfo1"; this.xrPageInfo1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.xrPageInfo1.SizeF = new System.Drawing.SizeF(438F, 23F); this.xrPageInfo1.StyleName = "PageInfo"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Page {0} of {1}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(456F, 8F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(438F, 23F); this.xrPageInfo2.StyleName = "PageInfo"; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // reportHeaderBand1 // this.reportHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel13 }); this.reportHeaderBand1.HeightF = 39.45834F; this.reportHeaderBand1.Name = "reportHeaderBand1"; // // xrLabel13 // this.xrLabel13.Font = new System.Drawing.Font("Arial Narrow", 18F, System.Drawing.FontStyle.Bold); this.xrLabel13.LocationFloat = new DevExpress.Utils.PointFloat(181.1667F, 0F); this.xrLabel13.Name = "xrLabel13"; this.xrLabel13.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel13.SizeF = new System.Drawing.SizeF(450.5F, 35F); this.xrLabel13.StyleName = "Title"; this.xrLabel13.StylePriority.UseFont = false; this.xrLabel13.StylePriority.UseTextAlignment = false; this.xrLabel13.Text = "MOUVEMENT DE SORTIE D\'EQUIPEMENTS"; this.xrLabel13.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // Title // this.Title.BackColor = System.Drawing.Color.Transparent; this.Title.BorderColor = System.Drawing.Color.Black; this.Title.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.Title.Borders = DevExpress.XtraPrinting.BorderSide.None; this.Title.BorderWidth = 1F; this.Title.Font = new System.Drawing.Font("Times New Roman", 21F); this.Title.ForeColor = System.Drawing.Color.Black; this.Title.Name = "Title"; // // FieldCaption // this.FieldCaption.BackColor = System.Drawing.Color.Transparent; this.FieldCaption.BorderColor = System.Drawing.Color.Black; this.FieldCaption.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.FieldCaption.Borders = DevExpress.XtraPrinting.BorderSide.None; this.FieldCaption.BorderWidth = 1F; this.FieldCaption.Font = new System.Drawing.Font("Times New Roman", 10F); this.FieldCaption.ForeColor = System.Drawing.Color.Black; this.FieldCaption.Name = "FieldCaption"; // // PageInfo // this.PageInfo.BackColor = System.Drawing.Color.Transparent; this.PageInfo.BorderColor = System.Drawing.Color.Black; this.PageInfo.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.PageInfo.Borders = DevExpress.XtraPrinting.BorderSide.None; this.PageInfo.BorderWidth = 1F; this.PageInfo.Font = new System.Drawing.Font("Arial", 8F); this.PageInfo.ForeColor = System.Drawing.Color.Black; this.PageInfo.Name = "PageInfo"; // // DataField // this.DataField.BackColor = System.Drawing.Color.Transparent; this.DataField.BorderColor = System.Drawing.Color.Black; this.DataField.BorderDashStyle = DevExpress.XtraPrinting.BorderDashStyle.Solid; this.DataField.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DataField.BorderWidth = 1F; this.DataField.Font = new System.Drawing.Font("Arial", 9F); this.DataField.ForeColor = System.Drawing.Color.Black; this.DataField.Name = "DataField"; // // xrLabel1 // this.xrLabel1.BackColor = System.Drawing.Color.Black; this.xrLabel1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel1.Font = new System.Drawing.Font("Arial Narrow", 12F, System.Drawing.FontStyle.Bold); this.xrLabel1.ForeColor = System.Drawing.Color.White; this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(151.0417F, 25.33334F); this.xrLabel1.StylePriority.UseBackColor = false; this.xrLabel1.StylePriority.UseBorders = false; this.xrLabel1.StylePriority.UseFont = false; this.xrLabel1.StylePriority.UseForeColor = false; this.xrLabel1.StylePriority.UseTextAlignment = false; this.xrLabel1.Text = "ID ATTRIBUTION"; this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter; // // rep_liste_equipements_sortis // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.groupHeaderBand1, this.groupHeaderBand2, this.pageFooterBand1, this.reportHeaderBand1 }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "liste_equipements_sorties"; this.DataSource = this.sqlDataSource1; this.Landscape = true; this.Margins = new System.Drawing.Printing.Margins(100, 100, 104, 79); this.PageHeight = 850; this.PageWidth = 1100; this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.FieldCaption, this.PageInfo, this.DataField }); this.Version = "15.2"; ((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.ConnectionParameters.CustomStringConnectionParameters customStringConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.CustomStringConnectionParameters(); DevExpress.DataAccess.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.TableInfo tableInfo1 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo1 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo2 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo3 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo4 = new DevExpress.DataAccess.Sql.ColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraReport1)); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrPictureBox1 = new DevExpress.XtraReports.UI.XRPictureBox(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // xrLabel2 // this.xrLabel2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "Categories.Description") }); this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 47.60415F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(335.9167F, 51.08334F); this.xrLabel2.Text = "xrLabel2"; // // xrLabel1 // this.xrLabel1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "Categories.CategoryName") }); this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 8.687496F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(335.9167F, 23F); this.xrLabel1.Text = "xrLabel1"; // // xrPictureBox1 // this.xrPictureBox1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Image", null, "Categories.Picture") }); this.xrPictureBox1.LocationFloat = new DevExpress.Utils.PointFloat(345.9167F, 7.375018F); this.xrPictureBox1.Name = "xrPictureBox1"; this.xrPictureBox1.SizeF = new System.Drawing.SizeF(127.0833F, 89.99999F); this.xrPictureBox1.Sizing = DevExpress.XtraPrinting.ImageSizeMode.ZoomImage; // // TopMargin // this.TopMargin.HeightF = 50F; this.TopMargin.Name = "TopMargin"; this.TopMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.TopMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // BottomMargin // this.BottomMargin.HeightF = 50F; this.BottomMargin.Name = "BottomMargin"; this.BottomMargin.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.BottomMargin.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1, this.xrLabel2, this.xrPictureBox1 }); this.Detail.HeightF = 107.375F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // sqlDataSource1 // this.sqlDataSource1.ConnectionName = "nwind.mdb"; customStringConnectionParameters1.ConnectionString = "XpoProvider=MSAccess;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|" + "\\Data\\nwind.mdb;Persist Security Info=True"; this.sqlDataSource1.ConnectionParameters = customStringConnectionParameters1; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.Name = "Categories"; tableInfo1.Name = "Categories"; columnInfo1.Name = "CategoryID"; columnInfo2.Name = "CategoryName"; columnInfo3.Name = "Description"; columnInfo4.Name = "Picture"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1, columnInfo2, columnInfo3, columnInfo4 }); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1 }); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // XtraReport1 // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "Categories"; this.DataSource = this.sqlDataSource1; this.Margins = new System.Drawing.Printing.Margins(50, 50, 50, 50); this.PageHeight = 827; this.PageWidth = 583; this.PaperKind = System.Drawing.Printing.PaperKind.A5; this.Version = "15.1"; ((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.ConnectionParameters.CustomStringConnectionParameters customStringConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.CustomStringConnectionParameters(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ReportAttdanceSummary)); 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 table3 = 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.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings1 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings2 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); DevExpress.XtraReports.Parameters.DynamicListLookUpSettings dynamicListLookUpSettings3 = new DevExpress.XtraReports.Parameters.DynamicListLookUpSettings(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); this.Title = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailCaption1 = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailData1 = new DevExpress.XtraReports.UI.XRControlStyle(); this.DetailData3_Odd = new DevExpress.XtraReports.UI.XRControlStyle(); this.PageInfo = new DevExpress.XtraReports.UI.XRControlStyle(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.pageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.pageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrRichText5 = new DevExpress.XtraReports.UI.XRRichText(); this.xrRichText4 = new DevExpress.XtraReports.UI.XRRichText(); this.xrRichText3 = new DevExpress.XtraReports.UI.XRRichText(); this.xrRichText2 = new DevExpress.XtraReports.UI.XRRichText(); this.xrRichText1 = new DevExpress.XtraReports.UI.XRRichText(); this.label1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.GroupHeader1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.table1 = new DevExpress.XtraReports.UI.XRTable(); this.tableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.tableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.table2 = new DevExpress.XtraReports.UI.XRTable(); this.tableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.tableCell11 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell12 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell13 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell15 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell16 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell17 = new DevExpress.XtraReports.UI.XRTableCell(); this.tableCell18 = new DevExpress.XtraReports.UI.XRTableCell(); this.Batch = new DevExpress.XtraReports.Parameters.Parameter(); this.Class_date = new DevExpress.XtraReports.Parameters.Parameter(); this.Summary_by = new DevExpress.XtraReports.Parameters.Parameter(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText5)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText4)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText3)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.table1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.table2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // sqlDataSource1 // this.sqlDataSource1.ConnectionName = "ec2amaz-1vsojpn.proadmin_v1.dbo"; customStringConnectionParameters1.ConnectionString = resources.GetString("customStringConnectionParameters1.ConnectionString"); this.sqlDataSource1.ConnectionParameters = customStringConnectionParameters1; this.sqlDataSource1.Name = "sqlDataSource1"; columnExpression1.ColumnName = "id"; table3.Name = "view_attandance_summary"; columnExpression1.Table = table3; column1.Expression = columnExpression1; columnExpression2.ColumnName = "batch"; columnExpression2.Table = table3; column2.Expression = columnExpression2; columnExpression3.ColumnName = "regid"; columnExpression3.Table = table3; column3.Expression = columnExpression3; columnExpression4.ColumnName = "Firstname"; columnExpression4.Table = table3; column4.Expression = columnExpression4; columnExpression5.ColumnName = "Lastname"; columnExpression5.Table = table3; column5.Expression = columnExpression5; columnExpression6.ColumnName = "classdate"; columnExpression6.Table = table3; column6.Expression = columnExpression6; columnExpression7.ColumnName = "intime"; columnExpression7.Table = table3; column7.Expression = columnExpression7; columnExpression8.ColumnName = "attandance"; columnExpression8.Table = table3; column8.Expression = columnExpression8; columnExpression9.ColumnName = "Al_school"; columnExpression9.Table = table3; column9.Expression = columnExpression9; columnExpression10.ColumnName = "Parents_contact"; columnExpression10.Table = table3; column10.Expression = columnExpression10; 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.Name = "view_attandance_summary"; selectQuery1.Tables.Add(table3); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { selectQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // Title // this.Title.BackColor = System.Drawing.Color.Transparent; this.Title.BorderColor = System.Drawing.Color.Black; this.Title.Borders = DevExpress.XtraPrinting.BorderSide.None; this.Title.BorderWidth = 1F; this.Title.Font = new System.Drawing.Font("Arial", 14.25F); this.Title.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(70)))), ((int)(((byte)(80))))); this.Title.Name = "Title"; // // DetailCaption1 // this.DetailCaption1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(93)))), ((int)(((byte)(98)))), ((int)(((byte)(110))))); this.DetailCaption1.BorderColor = System.Drawing.Color.White; this.DetailCaption1.Borders = DevExpress.XtraPrinting.BorderSide.Left; this.DetailCaption1.BorderWidth = 2F; this.DetailCaption1.Font = new System.Drawing.Font("Arial", 8.25F, System.Drawing.FontStyle.Bold); this.DetailCaption1.ForeColor = System.Drawing.Color.White; this.DetailCaption1.Name = "DetailCaption1"; this.DetailCaption1.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailCaption1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // DetailData1 // this.DetailData1.BorderColor = System.Drawing.Color.Transparent; this.DetailData1.Borders = DevExpress.XtraPrinting.BorderSide.Left; this.DetailData1.BorderWidth = 2F; this.DetailData1.Font = new System.Drawing.Font("Arial", 8.25F); this.DetailData1.ForeColor = System.Drawing.Color.Black; this.DetailData1.Name = "DetailData1"; this.DetailData1.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailData1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // DetailData3_Odd // this.DetailData3_Odd.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(243)))), ((int)(((byte)(245)))), ((int)(((byte)(248))))); this.DetailData3_Odd.BorderColor = System.Drawing.Color.Transparent; this.DetailData3_Odd.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DetailData3_Odd.BorderWidth = 1F; this.DetailData3_Odd.Font = new System.Drawing.Font("Arial", 8.25F); this.DetailData3_Odd.ForeColor = System.Drawing.Color.Black; this.DetailData3_Odd.Name = "DetailData3_Odd"; this.DetailData3_Odd.Padding = new DevExpress.XtraPrinting.PaddingInfo(6, 6, 0, 0, 100F); this.DetailData3_Odd.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft; // // PageInfo // this.PageInfo.Font = new System.Drawing.Font("Arial", 8.25F, System.Drawing.FontStyle.Bold); this.PageInfo.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(70)))), ((int)(((byte)(80))))); this.PageInfo.Name = "PageInfo"; this.PageInfo.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // TopMargin // this.TopMargin.HeightF = 30F; this.TopMargin.Name = "TopMargin"; // // BottomMargin // this.BottomMargin.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.pageInfo1, this.pageInfo2 }); this.BottomMargin.Name = "BottomMargin"; // // pageInfo1 // this.pageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 6F); this.pageInfo1.Name = "pageInfo1"; this.pageInfo1.PageInfo = DevExpress.XtraPrinting.PageInfo.DateTime; this.pageInfo1.SizeF = new System.Drawing.SizeF(301.5F, 23F); this.pageInfo1.StyleName = "PageInfo"; // // pageInfo2 // this.pageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(319F, 6F); this.pageInfo2.Name = "pageInfo2"; this.pageInfo2.SizeF = new System.Drawing.SizeF(301.5F, 23F); this.pageInfo2.StyleName = "PageInfo"; this.pageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; this.pageInfo2.TextFormatString = "Page {0} of {1}"; // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrRichText5, this.xrRichText4, this.xrRichText3, this.xrRichText2, this.xrRichText1, this.label1, this.xrLabel1 }); this.ReportHeader.HeightF = 78.27769F; this.ReportHeader.Name = "ReportHeader"; // // xrRichText5 // this.xrRichText5.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText5.LocationFloat = new DevExpress.Utils.PointFloat(0F, 55.27768F); this.xrRichText5.Name = "xrRichText5"; this.xrRichText5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText5.SerializableRtfString = resources.GetString("xrRichText5.SerializableRtfString"); this.xrRichText5.SizeF = new System.Drawing.SizeF(723.9999F, 23F); // // xrRichText4 // this.xrRichText4.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText4.LocationFloat = new DevExpress.Utils.PointFloat(620.5001F, 55.27769F); this.xrRichText4.Name = "xrRichText4"; this.xrRichText4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText4.SerializableRtfString = resources.GetString("xrRichText4.SerializableRtfString"); this.xrRichText4.SizeF = new System.Drawing.SizeF(78.62506F, 23F); // // xrRichText3 // this.xrRichText3.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText3.LocationFloat = new DevExpress.Utils.PointFloat(523.125F, 55.27768F); this.xrRichText3.Name = "xrRichText3"; this.xrRichText3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText3.SerializableRtfString = resources.GetString("xrRichText3.SerializableRtfString"); this.xrRichText3.SizeF = new System.Drawing.SizeF(97.37494F, 23F); // // xrRichText2 // this.xrRichText2.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText2.LocationFloat = new DevExpress.Utils.PointFloat(68.11956F, 53.58336F); this.xrRichText2.Name = "xrRichText2"; this.xrRichText2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText2.SerializableRtfString = resources.GetString("xrRichText2.SerializableRtfString"); this.xrRichText2.SizeF = new System.Drawing.SizeF(87.23666F, 23F); // // xrRichText1 // this.xrRichText1.Font = new System.Drawing.Font("Arial", 9.75F); this.xrRichText1.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 55.27769F); this.xrRichText1.Name = "xrRichText1"; this.xrRichText1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrRichText1.SerializableRtfString = resources.GetString("xrRichText1.SerializableRtfString"); this.xrRichText1.SizeF = new System.Drawing.SizeF(58.11955F, 23F); // // label1 // this.label1.Font = new System.Drawing.Font("Arial", 14.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Underline)))); this.label1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.label1.Name = "label1"; this.label1.SizeF = new System.Drawing.SizeF(723.9999F, 32.52767F); this.label1.StyleName = "Title"; this.label1.StylePriority.UseFont = false; this.label1.StylePriority.UseTextAlignment = false; this.label1.Text = "NEW HIGHER EDUCATION CENTRE (PVT) LTD"; this.label1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrLabel1 // this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 23.94435F); 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(723.9999F, 31.33334F); this.xrLabel1.StylePriority.UseTextAlignment = false; this.xrLabel1.Text = "No 58, New Rosita Town Kotagala. T.P 0774009942"; this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // GroupHeader1 // this.GroupHeader1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.table1 }); this.GroupHeader1.GroupUnion = DevExpress.XtraReports.UI.GroupUnion.WithFirstDetail; this.GroupHeader1.HeightF = 28F; this.GroupHeader1.Name = "GroupHeader1"; // // table1 // this.table1.LocationFloat = new DevExpress.Utils.PointFloat(7.629395E-06F, 0F); this.table1.Name = "table1"; this.table1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.tableRow1 }); this.table1.SizeF = new System.Drawing.SizeF(720.9999F, 28F); // // tableRow1 // this.tableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.tableCell2, this.tableCell3, this.tableCell4, this.tableCell6, this.tableCell7, this.tableCell8, this.tableCell9 }); this.tableRow1.Name = "tableRow1"; this.tableRow1.Weight = 1D; // // tableCell2 // this.tableCell2.Name = "tableCell2"; this.tableCell2.StyleName = "DetailCaption1"; this.tableCell2.Text = "regid"; this.tableCell2.Weight = 0.10864363765069794D; // // tableCell3 // this.tableCell3.Name = "tableCell3"; this.tableCell3.StyleName = "DetailCaption1"; this.tableCell3.Text = "Firstname"; this.tableCell3.Weight = 0.13913350769280583D; // // tableCell4 // this.tableCell4.Name = "tableCell4"; this.tableCell4.StyleName = "DetailCaption1"; this.tableCell4.Text = "Lastname"; this.tableCell4.Weight = 0.15520960285282798D; // // tableCell6 // this.tableCell6.Multiline = true; this.tableCell6.Name = "tableCell6"; this.tableCell6.StyleName = "DetailCaption1"; this.tableCell6.Text = "Time\r\n"; this.tableCell6.Weight = 0.20076014674884102D; // // tableCell7 // this.tableCell7.Name = "tableCell7"; this.tableCell7.StyleName = "DetailCaption1"; this.tableCell7.Text = "Attandance"; this.tableCell7.Weight = 0.12745542392960124D; // // tableCell8 // this.tableCell8.Name = "tableCell8"; this.tableCell8.StyleName = "DetailCaption1"; this.tableCell8.Text = "School"; this.tableCell8.Weight = 0.28976935288818567D; // // tableCell9 // this.tableCell9.Name = "tableCell9"; this.tableCell9.StyleName = "DetailCaption1"; this.tableCell9.Text = "Parents contact"; this.tableCell9.Weight = 0.1289483637695576D; // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.table2 }); this.Detail.HeightF = 25F; this.Detail.Name = "Detail"; // // table2 // this.table2.LocationFloat = new DevExpress.Utils.PointFloat(7.629395E-06F, 0F); this.table2.Name = "table2"; this.table2.OddStyleName = "DetailData3_Odd"; this.table2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.tableRow2 }); this.table2.SizeF = new System.Drawing.SizeF(720.9998F, 25F); // // tableRow2 // this.tableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.tableCell11, this.tableCell12, this.tableCell13, this.tableCell15, this.tableCell16, this.tableCell17, this.tableCell18 }); this.tableRow2.Name = "tableRow2"; this.tableRow2.Weight = 11.5D; // // tableCell11 // this.tableCell11.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[regid]") }); this.tableCell11.Name = "tableCell11"; this.tableCell11.StyleName = "DetailData1"; this.tableCell11.Weight = 0.10864363765069823D; // // tableCell12 // this.tableCell12.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Firstname]") }); this.tableCell12.Name = "tableCell12"; this.tableCell12.StyleName = "DetailData1"; this.tableCell12.Weight = 0.139133410348061D; // // tableCell13 // this.tableCell13.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Lastname]") }); this.tableCell13.Name = "tableCell13"; this.tableCell13.StyleName = "DetailData1"; this.tableCell13.Weight = 0.15520960285282773D; // // tableCell15 // this.tableCell15.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[intime]") }); this.tableCell15.Name = "tableCell15"; this.tableCell15.StyleName = "DetailData1"; this.tableCell15.Weight = 0.20076034143832955D; // // tableCell16 // this.tableCell16.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[attandance]") }); this.tableCell16.Name = "tableCell16"; this.tableCell16.StyleName = "DetailData1"; this.tableCell16.Weight = 0.1274554239296013D; // // tableCell17 // this.tableCell17.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Al_school]") }); this.tableCell17.Name = "tableCell17"; this.tableCell17.StyleName = "DetailData1"; this.tableCell17.Weight = 0.28976945023292916D; // // tableCell18 // this.tableCell18.ExpressionBindings.AddRange(new DevExpress.XtraReports.UI.ExpressionBinding[] { new DevExpress.XtraReports.UI.ExpressionBinding("BeforePrint", "Text", "[Parents_contact]") }); this.tableCell18.Name = "tableCell18"; this.tableCell18.StyleName = "DetailData1"; this.tableCell18.Weight = 0.12894797439057276D; // // Batch // this.Batch.Description = "Batch"; this.Batch.Name = "Batch"; dynamicListLookUpSettings1.DataMember = "view_attandance_summary"; dynamicListLookUpSettings1.DataSource = this.sqlDataSource1; dynamicListLookUpSettings1.DisplayMember = "batch"; dynamicListLookUpSettings1.SortMember = null; dynamicListLookUpSettings1.ValueMember = "batch"; this.Batch.ValueSourceSettings = dynamicListLookUpSettings1; // // Class_date // this.Class_date.Description = "Class_Date"; this.Class_date.Name = "Class_date"; dynamicListLookUpSettings2.DataMember = "view_attandance_summary"; dynamicListLookUpSettings2.DataSource = this.sqlDataSource1; dynamicListLookUpSettings2.DisplayMember = "classdate"; dynamicListLookUpSettings2.FilterString = "[batch] = ?Batch"; dynamicListLookUpSettings2.ValueMember = "classdate"; this.Class_date.ValueSourceSettings = dynamicListLookUpSettings2; // // Summary_by // this.Summary_by.Description = "Summary By"; this.Summary_by.Name = "Summary_by"; dynamicListLookUpSettings3.DataMember = "view_attandance_summary"; dynamicListLookUpSettings3.DataSource = this.sqlDataSource1; dynamicListLookUpSettings3.DisplayMember = "attandance"; dynamicListLookUpSettings3.SortMember = null; dynamicListLookUpSettings3.ValueMember = "attandance"; this.Summary_by.ValueSourceSettings = dynamicListLookUpSettings3; // // ReportAttdanceSummary // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.TopMargin, this.BottomMargin, this.ReportHeader, this.GroupHeader1, this.Detail }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "view_attandance_summary"; this.DataSource = this.sqlDataSource1; this.FilterString = "[batch] = ?Batch And [classdate] = ?Class_date And [attandance] = ?Summary_by"; this.Font = new System.Drawing.Font("Arial", 9.75F); this.Margins = new System.Drawing.Printing.Margins(46, 50, 30, 100); this.PageHeight = 1169; this.PageWidth = 827; this.PaperKind = System.Drawing.Printing.PaperKind.A4; this.Parameters.AddRange(new DevExpress.XtraReports.Parameters.Parameter[] { this.Batch, this.Class_date, this.Summary_by }); this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.DetailCaption1, this.DetailData1, this.DetailData3_Odd, this.PageInfo }); this.Version = "19.2"; ((System.ComponentModel.ISupportInitialize)(this.xrRichText5)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText4)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText3)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrRichText1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.table1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.table2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }