/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); DevExpress.DataAccess.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.RelationInfo relationInfo1 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.SortingInfo sortingInfo1 = new DevExpress.DataAccess.Sql.SortingInfo(); 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.TableInfo tableInfo2 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo4 = new DevExpress.DataAccess.Sql.ColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ProductosporExistensiaMinima)); 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.pageHeaderBand1 = new DevExpress.XtraReports.UI.PageHeaderBand(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine1 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine2 = new DevExpress.XtraReports.UI.XRLine(); this.groupHeaderBand1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel(); this.pageFooterBand1 = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.reportHeaderBand1 = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel9 = 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(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel5, this.xrLabel7, this.xrLabel6, this.xrLabel8 }); this.Detail.HeightF = 23F; 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.HeightF = 100F; 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 = 100F; 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 = "POSIXConnectionString"; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.Name = "PRODUCTOS"; relationColumnInfo1.NestedKeyColumn = "IdCategoria"; relationColumnInfo1.ParentKeyColumn = "IdCategoria"; relationInfo1.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo1 }); relationInfo1.NestedTable = "CATEGORIAS_PRODUCTOS"; relationInfo1.ParentTable = "PRODUCTOS"; tableQuery1.Relations.AddRange(new DevExpress.DataAccess.Sql.RelationInfo[] { relationInfo1 }); sortingInfo1.Column = "Existecia_Min"; sortingInfo1.Table = "PRODUCTOS"; tableQuery1.Sorting.AddRange(new DevExpress.DataAccess.Sql.SortingInfo[] { sortingInfo1 }); tableInfo1.Name = "PRODUCTOS"; columnInfo1.Name = "Nombre_Producto"; columnInfo2.Name = "Cod_Barra"; columnInfo3.Name = "Existecia_Min"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1, columnInfo2, columnInfo3 }); tableInfo2.Name = "CATEGORIAS_PRODUCTOS"; columnInfo4.Name = "Categoria"; tableInfo2.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo4 }); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1, tableInfo2 }); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // pageHeaderBand1 // this.pageHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1, this.xrLabel2, this.xrLabel3, this.xrLabel4, this.xrLine1, this.xrLine2 }); this.pageHeaderBand1.HeightF = 45F; this.pageHeaderBand1.Name = "pageHeaderBand1"; // // xrLabel1 // this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 7F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(132.2683F, 36F); this.xrLabel1.StyleName = "FieldCaption"; this.xrLabel1.Text = "Cod Barra"; // // xrLabel2 // this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(138.2683F, 7F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(215.9085F, 36F); this.xrLabel2.StyleName = "FieldCaption"; this.xrLabel2.Text = "Nombre Producto"; // // xrLabel3 // this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(354.1768F, 7F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(167.2805F, 36F); this.xrLabel3.StyleName = "FieldCaption"; this.xrLabel3.Text = "Existecia Min"; // // xrLabel4 // this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(521.4573F, 7F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(122.5427F, 36F); this.xrLabel4.StyleName = "FieldCaption"; this.xrLabel4.Text = "Categoria"; // // xrLine1 // this.xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 5F); this.xrLine1.Name = "xrLine1"; this.xrLine1.SizeF = new System.Drawing.SizeF(638F, 2F); // // xrLine2 // this.xrLine2.LocationFloat = new DevExpress.Utils.PointFloat(6F, 43F); this.xrLine2.Name = "xrLine2"; this.xrLine2.SizeF = new System.Drawing.SizeF(638F, 2F); // // groupHeaderBand1 // this.groupHeaderBand1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("Cod_Barra", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.groupHeaderBand1.HeightF = 23F; this.groupHeaderBand1.Name = "groupHeaderBand1"; this.groupHeaderBand1.StyleName = "DataField"; // // xrLabel5 // this.xrLabel5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "PRODUCTOS.Cod_Barra") }); this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel5.SizeF = new System.Drawing.SizeF(132.2683F, 23F); this.xrLabel5.Text = "xrLabel5"; // // xrLabel6 // this.xrLabel6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "PRODUCTOS.Nombre_Producto") }); this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(132.2683F, 0F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel6.SizeF = new System.Drawing.SizeF(191.9502F, 23F); this.xrLabel6.Text = "xrLabel6"; // // xrLabel7 // this.xrLabel7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "PRODUCTOS.Existecia_Min") }); this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(325F, 0F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel7.SizeF = new System.Drawing.SizeF(167.2805F, 23F); this.xrLabel7.Text = "xrLabel7"; // // xrLabel8 // this.xrLabel8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "PRODUCTOS.Categoria") }); this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(492.2805F, 0F); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel8.SizeF = new System.Drawing.SizeF(122.5427F, 23F); this.xrLabel8.Text = "xrLabel8"; // // pageFooterBand1 // this.pageFooterBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo1, this.xrPageInfo2 }); this.pageFooterBand1.HeightF = 29F; this.pageFooterBand1.Name = "pageFooterBand1"; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 6F); 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(313F, 23F); this.xrPageInfo1.StyleName = "PageInfo"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Página {0} de {1}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(331F, 6F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(313F, 23F); this.xrPageInfo2.StyleName = "PageInfo"; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // reportHeaderBand1 // this.reportHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel9 }); this.reportHeaderBand1.HeightF = 57F; this.reportHeaderBand1.Name = "reportHeaderBand1"; // // xrLabel9 // this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(88.29168F, 1.999998F); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel9.SizeF = new System.Drawing.SizeF(485.9166F, 39F); this.xrLabel9.StyleName = "Title"; this.xrLabel9.Text = "Productos por Existencia Minima"; // // 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", 24F); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.FieldCaption.BorderWidth = 1F; this.FieldCaption.Font = new System.Drawing.Font("Times New Roman", 10F, System.Drawing.FontStyle.Bold); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.PageInfo.BorderWidth = 1F; this.PageInfo.Font = new System.Drawing.Font("Times New Roman", 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DataField.BorderWidth = 1F; this.DataField.Font = new System.Drawing.Font("Times New Roman", 8F); this.DataField.ForeColor = System.Drawing.Color.Black; this.DataField.Name = "DataField"; this.DataField.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // ProductosporExistensiaMinima // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.pageHeaderBand1, this.groupHeaderBand1, this.pageFooterBand1, this.reportHeaderBand1 }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "PRODUCTOS"; this.DataSource = this.sqlDataSource1; this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.FieldCaption, this.PageInfo, this.DataField }); 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.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.RelationInfo relationInfo1 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.SortingInfo sortingInfo1 = new DevExpress.DataAccess.Sql.SortingInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo1 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo1 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo2 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo2 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo3 = new DevExpress.DataAccess.Sql.ColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(VentasporClientes)); 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.pageHeaderBand1 = new DevExpress.XtraReports.UI.PageHeaderBand(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine1 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine2 = new DevExpress.XtraReports.UI.XRLine(); this.groupHeaderBand1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.pageFooterBand1 = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.reportHeaderBand1 = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine3 = new DevExpress.XtraReports.UI.XRLine(); 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(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.HeightF = 23F; 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.HeightF = 100F; 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 = 100F; 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 = "POSIXConnectionString"; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.Name = "VENTAS"; relationColumnInfo1.NestedKeyColumn = "IdCliente"; relationColumnInfo1.ParentKeyColumn = "IdCliente"; relationInfo1.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo1 }); relationInfo1.NestedTable = "CLIENTES"; relationInfo1.ParentTable = "VENTAS"; tableQuery1.Relations.AddRange(new DevExpress.DataAccess.Sql.RelationInfo[] { relationInfo1 }); sortingInfo1.Column = "Total"; sortingInfo1.Table = "VENTAS"; tableQuery1.Sorting.AddRange(new DevExpress.DataAccess.Sql.SortingInfo[] { sortingInfo1 }); tableInfo1.Name = "VENTAS"; columnInfo1.Name = "Total"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1 }); tableInfo2.Name = "CLIENTES"; columnInfo2.Name = "Nombres"; columnInfo3.Name = "Apellidos"; tableInfo2.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo2, columnInfo3 }); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1, tableInfo2 }); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // pageHeaderBand1 // this.pageHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1, this.xrLabel2, this.xrLabel3, this.xrLine1, this.xrLine2 }); this.pageHeaderBand1.HeightF = 45F; this.pageHeaderBand1.Name = "pageHeaderBand1"; // // xrLabel1 // this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 7F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(242.8516F, 36F); this.xrLabel1.StyleName = "FieldCaption"; this.xrLabel1.Text = "Nombres"; // // xrLabel2 // this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(248.8516F, 7F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(246.9677F, 36F); this.xrLabel2.StyleName = "FieldCaption"; this.xrLabel2.Text = "Apellidos"; // // xrLabel3 // this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(495.8193F, 7F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(148.1807F, 36F); this.xrLabel3.StyleName = "FieldCaption"; this.xrLabel3.Text = "Total"; // // xrLine1 // this.xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 5F); this.xrLine1.Name = "xrLine1"; this.xrLine1.SizeF = new System.Drawing.SizeF(638F, 2F); // // xrLine2 // this.xrLine2.LocationFloat = new DevExpress.Utils.PointFloat(6F, 43F); this.xrLine2.Name = "xrLine2"; this.xrLine2.SizeF = new System.Drawing.SizeF(638F, 2F); // // groupHeaderBand1 // this.groupHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel4, this.xrLabel5, this.xrLabel6 }); this.groupHeaderBand1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("Nombres", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.groupHeaderBand1.HeightF = 23F; this.groupHeaderBand1.Name = "groupHeaderBand1"; this.groupHeaderBand1.StyleName = "DataField"; // // xrLabel4 // this.xrLabel4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "VENTAS.Nombres") }); this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(6F, 0F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(242.8516F, 23F); this.xrLabel4.Text = "xrLabel4"; // // xrLabel5 // this.xrLabel5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "VENTAS.Apellidos") }); this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(248.8516F, 0F); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel5.SizeF = new System.Drawing.SizeF(246.9677F, 23F); this.xrLabel5.Text = "xrLabel5"; // // xrLabel6 // this.xrLabel6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "VENTAS.Total", "{0:C2}") }); this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(495.8193F, 0F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel6.SizeF = new System.Drawing.SizeF(148.1807F, 23F); this.xrLabel6.Text = "xrLabel6"; // // pageFooterBand1 // this.pageFooterBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo1, this.xrPageInfo2 }); this.pageFooterBand1.HeightF = 29F; this.pageFooterBand1.Name = "pageFooterBand1"; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 6F); 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(313F, 23F); this.xrPageInfo1.StyleName = "PageInfo"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Página {0} de {1}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(331F, 6F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(313F, 23F); this.xrPageInfo2.StyleName = "PageInfo"; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // reportHeaderBand1 // this.reportHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel7, this.xrLine3 }); this.reportHeaderBand1.HeightF = 57F; this.reportHeaderBand1.Name = "reportHeaderBand1"; // // xrLabel7 // this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(173.7083F, 7.999992F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel7.SizeF = new System.Drawing.SizeF(285.9167F, 39F); this.xrLabel7.StyleName = "Title"; this.xrLabel7.Text = "Ventas por Clientes"; // // xrLine3 // this.xrLine3.LocationFloat = new DevExpress.Utils.PointFloat(6F, 0F); this.xrLine3.Name = "xrLine3"; this.xrLine3.SizeF = new System.Drawing.SizeF(638F, 2F); // // 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", 24F); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.FieldCaption.BorderWidth = 1F; this.FieldCaption.Font = new System.Drawing.Font("Times New Roman", 10F, System.Drawing.FontStyle.Bold); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.PageInfo.BorderWidth = 1F; this.PageInfo.Font = new System.Drawing.Font("Times New Roman", 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DataField.BorderWidth = 1F; this.DataField.Font = new System.Drawing.Font("Times New Roman", 8F); this.DataField.ForeColor = System.Drawing.Color.Black; this.DataField.Name = "DataField"; this.DataField.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // VentasporClientes // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.pageHeaderBand1, this.groupHeaderBand1, this.pageFooterBand1, this.reportHeaderBand1 }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "VENTAS"; this.DataSource = this.sqlDataSource1; this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.FieldCaption, this.PageInfo, this.DataField }); 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.MySqlConnectionParameters mySqlConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.MySqlConnectionParameters(); DevExpress.DataAccess.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.RelationInfo relationInfo1 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo2 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.SortingInfo sortingInfo1 = new DevExpress.DataAccess.Sql.SortingInfo(); 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.TableInfo tableInfo2 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo4 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo3 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo5 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo6 = new DevExpress.DataAccess.Sql.ColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(reporteComprasProveedores)); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrTable1 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2 }); this.Detail.HeightF = 25F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // xrTable2 // this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2 }); this.xrTable2.SizeF = new System.Drawing.SizeF(650.0001F, 25F); this.xrTable2.StylePriority.UseBorders = false; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell6, this.xrTableCell7, this.xrTableCell8, this.xrTableCell9 }); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1D; // // xrTableCell6 // this.xrTableCell6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblCompra.id_compra") }); this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.Weight = 1D; // // xrTableCell7 // this.xrTableCell7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblCompra.Fecha", "{0:d/MM/yyyy}") }); this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.Weight = 0.97916687011718739D; // // xrTableCell8 // this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblCompra.Total", "{0:Q0.00}") }); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.Weight = 0.86458297729492162D; // // xrTableCell9 // this.xrTableCell9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblCompra.Sucursal") }); this.xrTableCell9.Name = "xrTableCell9"; this.xrTableCell9.Weight = 3.6562507629394529D; // // 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 = 100F; 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 = "dbsur_Connection"; mySqlConnectionParameters1.DatabaseName = "u983648979_dbsur"; mySqlConnectionParameters1.Password = "******"; mySqlConnectionParameters1.ServerName = "185.224.137.20"; mySqlConnectionParameters1.UserName = "******"; this.sqlDataSource1.ConnectionParameters = mySqlConnectionParameters1; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.FilterString = "[tblCompra.id_proveedor] = ?idProveedor"; tableQuery1.GroupFilterString = ""; tableQuery1.Name = "tblCompra"; queryParameter1.Name = "idProveedor"; queryParameter1.Type = typeof(int); queryParameter1.ValueInfo = "1"; tableQuery1.Parameters.Add(queryParameter1); relationColumnInfo1.NestedKeyColumn = "id_sucursal"; relationColumnInfo1.ParentKeyColumn = "id_sucursal"; relationInfo1.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo1 }); relationInfo1.NestedTable = "tblSucursal"; relationInfo1.ParentTable = "tblCompra"; relationColumnInfo2.NestedKeyColumn = "id_proveedor"; relationColumnInfo2.ParentKeyColumn = "id_proveedor"; relationInfo2.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo2 }); relationInfo2.NestedTable = "tblProveedor"; relationInfo2.ParentTable = "tblCompra"; tableQuery1.Relations.AddRange(new DevExpress.DataAccess.Sql.RelationInfo[] { relationInfo1, relationInfo2 }); sortingInfo1.Column = "fecha"; sortingInfo1.Table = "tblCompra"; tableQuery1.Sorting.AddRange(new DevExpress.DataAccess.Sql.SortingInfo[] { sortingInfo1 }); tableInfo1.Name = "tblCompra"; columnInfo1.Alias = "Fecha"; columnInfo1.Name = "fecha"; columnInfo2.Alias = "Total"; columnInfo2.Name = "total_documento"; columnInfo3.Name = "id_compra"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1, columnInfo2, columnInfo3 }); tableInfo2.Name = "tblSucursal"; columnInfo4.Alias = "Sucursal"; columnInfo4.Name = "nombre_sucursal"; tableInfo2.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo4 }); tableInfo3.Name = "tblProveedor"; columnInfo5.Alias = "Proveedor"; columnInfo5.Name = "nombre_proveedor"; columnInfo6.Alias = "NIT"; columnInfo6.Name = "nit"; tableInfo3.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo5, columnInfo6 }); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1, tableInfo2, tableInfo3 }); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable1, this.xrLabel5, this.xrLabel4, this.xrLabel3, this.xrLabel2, this.xrLabel1 }); this.ReportHeader.HeightF = 100F; this.ReportHeader.Name = "ReportHeader"; // // xrTable1 // this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 75F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1 }); this.xrTable1.SizeF = new System.Drawing.SizeF(650F, 25F); this.xrTable1.StylePriority.UseBorders = false; // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell1, this.xrTableCell2, this.xrTableCell4, this.xrTableCell5 }); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1D; // // xrTableCell1 // this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.Text = "# Compra"; this.xrTableCell1.Weight = 1D; // // xrTableCell2 // this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.Text = "Fecha"; this.xrTableCell2.Weight = 0.97916686573666878D; // // xrTableCell4 // this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.Text = "Total"; this.xrTableCell4.Weight = 0.86458327699506665D; // // xrTableCell5 // this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.Text = "Sucursal"; this.xrTableCell5.Weight = 3.6562496294815681D; // // xrLabel5 // this.xrLabel5.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblCompra.NIT") }); this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(100F, 46.91668F); 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.UseBorders = false; // // xrLabel4 // this.xrLabel4.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Top | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblCompra.Proveedor") }); this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(100F, 23.91667F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(100F, 23F); this.xrLabel4.StylePriority.UseBorders = false; // // xrLabel3 // this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(215.625F, 0F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(160.4167F, 23F); this.xrLabel3.Text = "COMPRA A PROVEEDOR"; // // xrLabel2 // this.xrLabel2.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 46.91668F); 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.UseBorders = false; this.xrLabel2.Text = "NIT:"; // // xrLabel1 // this.xrLabel1.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel1.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 23.91667F); 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.UseBorders = false; this.xrLabel1.StylePriority.UseFont = false; this.xrLabel1.Text = "Proveedor:"; // // reporteComprasProveedores // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.ReportHeader }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "tblCompra"; this.DataSource = this.sqlDataSource1; this.Margins = new System.Drawing.Printing.Margins(100, 100, 50, 100); this.Version = "15.2"; ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).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.MySqlConnectionParameters mySqlConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.MySqlConnectionParameters(); DevExpress.DataAccess.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.RelationInfo relationInfo1 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo2 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.SortingInfo sortingInfo1 = new DevExpress.DataAccess.Sql.SortingInfo(); 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(); DevExpress.DataAccess.Sql.TableInfo tableInfo2 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo5 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo6 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo7 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo3 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo8 = new DevExpress.DataAccess.Sql.ColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(reporteVentasClieneEmpleado)); 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.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrTable1 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell9 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell10 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2 }); this.Detail.HeightF = 25F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // TopMargin // this.TopMargin.HeightF = 40.625F; 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 = 100F; 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 = "dbsur_Connection"; mySqlConnectionParameters1.DatabaseName = "u983648979_dbsur"; mySqlConnectionParameters1.Password = "******"; mySqlConnectionParameters1.ServerName = "185.224.137.20"; mySqlConnectionParameters1.UserName = "******"; this.sqlDataSource1.ConnectionParameters = mySqlConnectionParameters1; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.FilterString = "[tblCliente.id_cliente] = ?idCliente"; tableQuery1.GroupFilterString = ""; tableQuery1.Name = "tblVenta"; queryParameter1.Name = "idCliente"; queryParameter1.Type = typeof(int); queryParameter1.ValueInfo = "165"; tableQuery1.Parameters.Add(queryParameter1); relationColumnInfo1.NestedKeyColumn = "id_cliente"; relationColumnInfo1.ParentKeyColumn = "id_cliente"; relationInfo1.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo1 }); relationInfo1.NestedTable = "tblCliente"; relationInfo1.ParentTable = "tblVenta"; relationColumnInfo2.NestedKeyColumn = "id_sucursal"; relationColumnInfo2.ParentKeyColumn = "id_sucursal"; relationInfo2.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo2 }); relationInfo2.NestedTable = "tblSucursal"; relationInfo2.ParentTable = "tblVenta"; tableQuery1.Relations.AddRange(new DevExpress.DataAccess.Sql.RelationInfo[] { relationInfo1, relationInfo2 }); sortingInfo1.Column = "fecha"; sortingInfo1.Table = "tblVenta"; tableQuery1.Sorting.AddRange(new DevExpress.DataAccess.Sql.SortingInfo[] { sortingInfo1 }); tableInfo1.Name = "tblVenta"; columnInfo1.Name = "id_venta"; columnInfo2.Name = "fecha"; columnInfo3.Name = "total"; columnInfo4.Name = "documento"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1, columnInfo2, columnInfo3, columnInfo4 }); tableInfo2.Name = "tblCliente"; columnInfo5.Name = "nit"; columnInfo6.Name = "nombre"; columnInfo7.Name = "apellido"; tableInfo2.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo5, columnInfo6, columnInfo7 }); tableInfo3.Name = "tblSucursal"; columnInfo8.Name = "nombre_sucursal"; tableInfo3.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo8 }); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1, tableInfo2, tableInfo3 }); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel7, this.xrLabel6, this.xrLabel5, this.xrTable1, this.xrLabel4, this.xrLabel3, this.xrLabel2, this.xrLabel1 }); this.ReportHeader.HeightF = 100F; this.ReportHeader.Name = "ReportHeader"; // // xrLabel1 // this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 23.95833F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.xrLabel1.SizeF = new System.Drawing.SizeF(100F, 23F); this.xrLabel1.Text = "Nombre:"; // // xrLabel2 // this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 46.95834F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.xrLabel2.SizeF = new System.Drawing.SizeF(100F, 23F); this.xrLabel2.Text = "Apellido:"; // // xrLabel3 // this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(469.7917F, 23.95833F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.xrLabel3.SizeF = new System.Drawing.SizeF(52.08331F, 23F); this.xrLabel3.Text = "NIT:"; // // xrLabel4 // this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(121.875F, 0F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.xrLabel4.SizeF = new System.Drawing.SizeF(326.0417F, 23F); this.xrLabel4.StylePriority.UseTextAlignment = false; this.xrLabel4.Text = "REPORTE DE VENTAS DE CLIENTE"; this.xrLabel4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrTable1 // this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 75F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1 }); this.xrTable1.SizeF = new System.Drawing.SizeF(650.0001F, 25F); this.xrTable1.StylePriority.UseBorders = false; this.xrTable1.StylePriority.UseTextAlignment = false; this.xrTable1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell1, this.xrTableCell2, this.xrTableCell3, this.xrTableCell4, this.xrTableCell5 }); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1D; // // xrTableCell1 // this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.Text = "# VENTA"; this.xrTableCell1.Weight = 0.3557691838191106D; // // xrTableCell2 // this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.Text = "FECHA"; this.xrTableCell2.Weight = 0.51923067533052869D; // // xrTableCell3 // this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.Text = "DOCUMENTO"; this.xrTableCell3.Weight = 0.92307724789694368D; // // xrTableCell4 // this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.Text = "TOTAL"; this.xrTableCell4.Weight = 0.37019212273592772D; // // xrTableCell5 // this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.Text = "SUCURSAL"; this.xrTableCell5.Weight = 0.83173129740025342D; // // xrTable2 // this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2 }); this.xrTable2.SizeF = new System.Drawing.SizeF(650F, 25F); this.xrTable2.StylePriority.UseBorders = false; this.xrTable2.StylePriority.UseTextAlignment = false; this.xrTable2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell6, this.xrTableCell7, this.xrTableCell8, this.xrTableCell9, this.xrTableCell10 }); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1D; // // xrTableCell6 // this.xrTableCell6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.id_venta") }); this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.Weight = 0.77083328247070315D; // // xrTableCell7 // this.xrTableCell7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.fecha", "{0:d/MM/yyyy}") }); this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.Weight = 1.1249996948242187D; // // xrTableCell8 // this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.documento") }); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.Weight = 2.0000010681152345D; // // xrTableCell9 // this.xrTableCell9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.total", "{0:Q0.00}") }); this.xrTableCell9.Name = "xrTableCell9"; this.xrTableCell9.Weight = 0.80208251953125009D; // // xrTableCell10 // this.xrTableCell10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.nombre_sucursal") }); this.xrTableCell10.Name = "xrTableCell10"; this.xrTableCell10.Weight = 1.8020834350585937D; // // xrLabel5 // this.xrLabel5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.nombre") }); this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(100F, 23.95833F); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.xrLabel5.SizeF = new System.Drawing.SizeF(260.4167F, 23F); // // xrLabel6 // this.xrLabel6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.apellido") }); this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(100F, 46.95834F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.xrLabel6.SizeF = new System.Drawing.SizeF(260.4167F, 23F); // // xrLabel7 // this.xrLabel7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.nit") }); this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(521.875F, 23.95833F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.xrLabel7.SizeF = new System.Drawing.SizeF(128.125F, 23F); // // reporteVentasClieneEmpleado // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.ReportHeader }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "tblVenta"; this.DataSource = this.sqlDataSource1; this.Margins = new System.Drawing.Printing.Margins(100, 100, 41, 100); this.Version = "15.2"; ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).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.MySqlConnectionParameters mySqlConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.MySqlConnectionParameters(); DevExpress.DataAccess.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.QueryParameter queryParameter2 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.RelationInfo relationInfo1 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo2 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo3 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo3 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.SortingInfo sortingInfo1 = new DevExpress.DataAccess.Sql.SortingInfo(); 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.TableInfo tableInfo2 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo4 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo5 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo3 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo6 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo4 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo7 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo8 = new DevExpress.DataAccess.Sql.ColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(reporteComprasFechas)); 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.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.xrLabel13 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel14 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel15 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel16 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine1 = new DevExpress.XtraReports.UI.XRLine(); 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.xrLabel17 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine3 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine4 = new DevExpress.XtraReports.UI.XRLine(); 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(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel9, this.xrLabel10, this.xrLabel11, this.xrLabel12, this.xrLabel13, this.xrLabel14, this.xrLabel15, this.xrLabel16 }); this.Detail.HeightF = 40F; 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.HeightF = 35.41667F; 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 = 100F; 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 = "dbsur_Connection"; mySqlConnectionParameters1.DatabaseName = "u983648979_dbsur"; mySqlConnectionParameters1.Password = "******"; mySqlConnectionParameters1.ServerName = "185.224.137.20"; mySqlConnectionParameters1.UserName = "******"; this.sqlDataSource1.ConnectionParameters = mySqlConnectionParameters1; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.FilterString = "[tblCompra.fecha] Between(?fechadesde, ?fechaHasta)"; tableQuery1.GroupFilterString = ""; tableQuery1.Name = "tblCompra"; queryParameter1.Name = "fechadesde"; queryParameter1.Type = typeof(System.DateTime); queryParameter1.ValueInfo = "2018-04-15"; queryParameter2.Name = "fechaHasta"; queryParameter2.Type = typeof(System.DateTime); queryParameter2.ValueInfo = "2018-04-30"; tableQuery1.Parameters.Add(queryParameter1); tableQuery1.Parameters.Add(queryParameter2); relationColumnInfo1.NestedKeyColumn = "id_proveedor"; relationColumnInfo1.ParentKeyColumn = "id_proveedor"; relationInfo1.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo1 }); relationInfo1.NestedTable = "tblProveedor"; relationInfo1.ParentTable = "tblCompra"; relationColumnInfo2.NestedKeyColumn = "id_sucursal"; relationColumnInfo2.ParentKeyColumn = "id_sucursal"; relationInfo2.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo2 }); relationInfo2.NestedTable = "tblSucursal"; relationInfo2.ParentTable = "tblCompra"; relationColumnInfo3.NestedKeyColumn = "id_empleado"; relationColumnInfo3.ParentKeyColumn = "id_empleado"; relationInfo3.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo3 }); relationInfo3.NestedTable = "tblEmpleado"; relationInfo3.ParentTable = "tblCompra"; tableQuery1.Relations.AddRange(new DevExpress.DataAccess.Sql.RelationInfo[] { relationInfo1, relationInfo2, relationInfo3 }); sortingInfo1.Column = "id_compra"; sortingInfo1.Table = "tblCompra"; tableQuery1.Sorting.AddRange(new DevExpress.DataAccess.Sql.SortingInfo[] { sortingInfo1 }); tableInfo1.Name = "tblCompra"; columnInfo1.Alias = "IDCompra"; columnInfo1.Name = "id_compra"; columnInfo2.Alias = "Fecha"; columnInfo2.Name = "fecha"; columnInfo3.Alias = "Total"; columnInfo3.Name = "total_documento"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1, columnInfo2, columnInfo3 }); tableInfo2.Name = "tblProveedor"; columnInfo4.Alias = "Proveedor"; columnInfo4.Name = "nombre_proveedor"; columnInfo5.Alias = "NIT"; columnInfo5.Name = "nit"; tableInfo2.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo4, columnInfo5 }); tableInfo3.Name = "tblSucursal"; columnInfo6.Alias = "Sucursal"; columnInfo6.Name = "nombre_sucursal"; tableInfo3.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo6 }); tableInfo4.Name = "tblEmpleado"; columnInfo7.Alias = "Nombre"; columnInfo7.Name = "nombre"; columnInfo8.Alias = "Apellido"; columnInfo8.Name = "apellido"; tableInfo4.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo7, columnInfo8 }); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1, tableInfo2, tableInfo3, tableInfo4 }); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // groupHeaderBand1 // this.groupHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLine1 }); this.groupHeaderBand1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("IDCompra", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Fecha", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("NIT", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Proveedor", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Total", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Nombre", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Apellido", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Sucursal", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.groupHeaderBand1.HeightF = 44.08334F; this.groupHeaderBand1.Level = 1; this.groupHeaderBand1.Name = "groupHeaderBand1"; // // xrLabel9 // this.xrLabel9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblCompra.IDCompra") }); this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel9.SizeF = new System.Drawing.SizeF(88.79037F, 40F); this.xrLabel9.StyleName = "DataField"; this.xrLabel9.Text = "xrLabel9"; // // xrLabel10 // this.xrLabel10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblCompra.Fecha", "{0:d/MM/yyyy}") }); this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(88.79038F, 0F); this.xrLabel10.Name = "xrLabel10"; this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel10.SizeF = new System.Drawing.SizeF(85.34911F, 40F); this.xrLabel10.StyleName = "DataField"; this.xrLabel10.Text = "xrLabel10"; // // xrLabel11 // this.xrLabel11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblCompra.NIT") }); this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(174.1395F, 0F); this.xrLabel11.Name = "xrLabel11"; this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel11.SizeF = new System.Drawing.SizeF(70.054F, 40F); this.xrLabel11.StyleName = "DataField"; this.xrLabel11.Text = "xrLabel11"; // // xrLabel12 // this.xrLabel12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblCompra.Proveedor") }); this.xrLabel12.LocationFloat = new DevExpress.Utils.PointFloat(244.1935F, 0F); this.xrLabel12.Name = "xrLabel12"; this.xrLabel12.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel12.SizeF = new System.Drawing.SizeF(109.7015F, 40F); this.xrLabel12.StyleName = "DataField"; this.xrLabel12.Text = "xrLabel12"; // // xrLabel13 // this.xrLabel13.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblCompra.Total", "{0:C2}") }); this.xrLabel13.LocationFloat = new DevExpress.Utils.PointFloat(353.895F, 0F); this.xrLabel13.Name = "xrLabel13"; this.xrLabel13.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel13.SizeF = new System.Drawing.SizeF(102.105F, 40F); this.xrLabel13.StyleName = "DataField"; this.xrLabel13.Text = "xrLabel13"; // // xrLabel14 // this.xrLabel14.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblCompra.Nombre") }); this.xrLabel14.LocationFloat = new DevExpress.Utils.PointFloat(456F, 0F); this.xrLabel14.Name = "xrLabel14"; this.xrLabel14.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel14.SizeF = new System.Drawing.SizeF(153.517F, 40F); this.xrLabel14.StyleName = "DataField"; this.xrLabel14.Text = "xrLabel14"; // // xrLabel15 // this.xrLabel15.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblCompra.Apellido") }); this.xrLabel15.LocationFloat = new DevExpress.Utils.PointFloat(609.517F, 0F); this.xrLabel15.Name = "xrLabel15"; this.xrLabel15.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel15.SizeF = new System.Drawing.SizeF(134.2397F, 40F); this.xrLabel15.StyleName = "DataField"; this.xrLabel15.Text = "xrLabel15"; // // xrLabel16 // this.xrLabel16.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblCompra.Sucursal") }); this.xrLabel16.LocationFloat = new DevExpress.Utils.PointFloat(743.7568F, 0F); this.xrLabel16.Name = "xrLabel16"; this.xrLabel16.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel16.SizeF = new System.Drawing.SizeF(150.2432F, 40F); this.xrLabel16.StyleName = "DataField"; this.xrLabel16.Text = "xrLabel16"; // // xrLabel1 // this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(6.00001F, 36.99999F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(82.79035F, 40F); this.xrLabel1.StyleName = "FieldCaption"; this.xrLabel1.Text = "IDCompra"; // // xrLabel2 // this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(88.79038F, 36.99999F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(85.34914F, 40F); this.xrLabel2.StyleName = "FieldCaption"; this.xrLabel2.Text = "Fecha"; // // xrLabel3 // this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(174.1395F, 36.99999F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(70.05403F, 40F); this.xrLabel3.StyleName = "FieldCaption"; this.xrLabel3.Text = "NIT"; // // xrLabel4 // this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(244.1935F, 36.99999F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(109.7015F, 40F); this.xrLabel4.StyleName = "FieldCaption"; this.xrLabel4.Text = "Proveedor"; // // xrLabel5 // this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(353.8951F, 36.99999F); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel5.SizeF = new System.Drawing.SizeF(102.1049F, 40F); this.xrLabel5.StyleName = "FieldCaption"; this.xrLabel5.Text = "Total"; // // xrLabel6 // this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(456F, 36.99999F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel6.SizeF = new System.Drawing.SizeF(153.517F, 40F); this.xrLabel6.StyleName = "FieldCaption"; this.xrLabel6.Text = "Nombre"; // // xrLabel7 // this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(609.517F, 36.99999F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel7.SizeF = new System.Drawing.SizeF(134.2398F, 40F); this.xrLabel7.StyleName = "FieldCaption"; this.xrLabel7.Text = "Apellido"; // // xrLabel8 // this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(743.7568F, 37F); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel8.SizeF = new System.Drawing.SizeF(150.2432F, 40F); this.xrLabel8.StyleName = "FieldCaption"; this.xrLabel8.Text = "Sucursal"; // // xrLine1 // this.xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(5.867842F, 0F); this.xrLine1.Name = "xrLine1"; this.xrLine1.SizeF = new System.Drawing.SizeF(882.1321F, 2F); // // groupHeaderBand2 // this.groupHeaderBand2.HeightF = 6F; 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 = "Página {0} de {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.xrLabel17, this.xrLine3, this.xrLine4, this.xrLabel1, this.xrLabel2, this.xrLabel3, this.xrLabel4, this.xrLabel5, this.xrLabel6, this.xrLabel7, this.xrLabel8 }); this.reportHeaderBand1.HeightF = 77F; this.reportHeaderBand1.Name = "reportHeaderBand1"; // // xrLabel17 // this.xrLabel17.LocationFloat = new DevExpress.Utils.PointFloat(6F, 2F); this.xrLabel17.Name = "xrLabel17"; this.xrLabel17.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel17.SizeF = new System.Drawing.SizeF(888F, 33F); this.xrLabel17.StyleName = "Title"; this.xrLabel17.Text = "Compras entre rango de Fechas"; // // xrLine3 // this.xrLine3.LocationFloat = new DevExpress.Utils.PointFloat(6F, 0F); this.xrLine3.Name = "xrLine3"; this.xrLine3.SizeF = new System.Drawing.SizeF(888F, 2F); // // xrLine4 // this.xrLine4.LocationFloat = new DevExpress.Utils.PointFloat(6F, 35F); this.xrLine4.Name = "xrLine4"; this.xrLine4.SizeF = new System.Drawing.SizeF(888F, 2F); // // 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)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic)))); this.Title.ForeColor = System.Drawing.Color.Navy; 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("Times New Roman", 11F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic)))); this.FieldCaption.ForeColor = System.Drawing.Color.Navy; 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", 9F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic)))); this.PageInfo.ForeColor = System.Drawing.Color.Navy; 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("Arial", 8F); this.DataField.ForeColor = System.Drawing.Color.Black; this.DataField.Name = "DataField"; this.DataField.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // reporteComprasFechas // 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 = "tblCompra"; this.DataSource = this.sqlDataSource1; this.Landscape = true; this.Margins = new System.Drawing.Printing.Margins(100, 100, 35, 100); 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.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.RelationInfo relationInfo1 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo2 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.SortingInfo sortingInfo1 = new DevExpress.DataAccess.Sql.SortingInfo(); DevExpress.DataAccess.Sql.SortingInfo sortingInfo2 = new DevExpress.DataAccess.Sql.SortingInfo(); 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.TableInfo tableInfo2 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo3 = new DevExpress.DataAccess.Sql.TableInfo(); 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(PistasdeAuditoria)); 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.pageHeaderBand1 = new DevExpress.XtraReports.UI.PageHeaderBand(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine1 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine2 = new DevExpress.XtraReports.UI.XRLine(); this.groupHeaderBand1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel(); this.pageFooterBand1 = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.reportHeaderBand1 = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine3 = new DevExpress.XtraReports.UI.XRLine(); 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(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.HeightF = 23F; 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.HeightF = 100F; 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 = 100F; 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 = "POSIXConnectionString"; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.Name = "PISTAS_DE_AUDITORIA"; relationColumnInfo1.NestedKeyColumn = "IdUsuario"; relationColumnInfo1.ParentKeyColumn = "IdUsuario"; relationInfo1.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo1 }); relationInfo1.NestedTable = "USUARIOS"; relationInfo1.ParentTable = "PISTAS_DE_AUDITORIA"; relationColumnInfo2.NestedKeyColumn = "IdEmpleado"; relationColumnInfo2.ParentKeyColumn = "IdEmpleado"; relationInfo2.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo2 }); relationInfo2.NestedTable = "EMPLEADOS"; relationInfo2.ParentTable = "USUARIOS"; tableQuery1.Relations.AddRange(new DevExpress.DataAccess.Sql.RelationInfo[] { relationInfo1, relationInfo2 }); sortingInfo1.Column = "Fecha"; sortingInfo1.Table = "PISTAS_DE_AUDITORIA"; sortingInfo2.Column = "Actividad"; sortingInfo2.Table = "PISTAS_DE_AUDITORIA"; tableQuery1.Sorting.AddRange(new DevExpress.DataAccess.Sql.SortingInfo[] { sortingInfo1, sortingInfo2 }); tableInfo1.Name = "PISTAS_DE_AUDITORIA"; columnInfo1.Name = "Actividad"; columnInfo2.Name = "Fecha"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1, columnInfo2 }); tableInfo2.Name = "USUARIOS"; tableInfo3.Name = "EMPLEADOS"; columnInfo3.Name = "Nombres"; columnInfo4.Name = "Apellidos"; tableInfo3.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo3, columnInfo4 }); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1, tableInfo2, tableInfo3 }); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // pageHeaderBand1 // this.pageHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1, this.xrLabel2, this.xrLabel3, this.xrLabel4, this.xrLine1, this.xrLine2 }); this.pageHeaderBand1.HeightF = 45F; this.pageHeaderBand1.Name = "pageHeaderBand1"; // // xrLabel1 // this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 7F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(170.3258F, 36F); this.xrLabel1.StyleName = "FieldCaption"; this.xrLabel1.Text = "Nombres"; // // xrLabel2 // this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(176.3258F, 7F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(173.2127F, 36F); this.xrLabel2.StyleName = "FieldCaption"; this.xrLabel2.Text = "Apellidos"; // // xrLabel3 // this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(349.5385F, 7F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(115.4751F, 36F); this.xrLabel3.StyleName = "FieldCaption"; this.xrLabel3.Text = "Fecha"; // // xrLabel4 // this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(465.0135F, 7F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(178.9865F, 36F); this.xrLabel4.StyleName = "FieldCaption"; this.xrLabel4.Text = "Actividad"; // // xrLine1 // this.xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 5F); this.xrLine1.Name = "xrLine1"; this.xrLine1.SizeF = new System.Drawing.SizeF(638F, 2F); // // xrLine2 // this.xrLine2.LocationFloat = new DevExpress.Utils.PointFloat(6F, 43F); this.xrLine2.Name = "xrLine2"; this.xrLine2.SizeF = new System.Drawing.SizeF(638F, 2F); // // groupHeaderBand1 // this.groupHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel5, this.xrLabel6, this.xrLabel7, this.xrLabel8 }); this.groupHeaderBand1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("Nombres", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.groupHeaderBand1.HeightF = 23F; this.groupHeaderBand1.Name = "groupHeaderBand1"; this.groupHeaderBand1.StyleName = "DataField"; // // xrLabel5 // this.xrLabel5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "PISTAS_DE_AUDITORIA.Nombres") }); this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(6.00001F, 0F); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel5.SizeF = new System.Drawing.SizeF(146.3675F, 23F); this.xrLabel5.Text = "xrLabel5"; // // xrLabel6 // this.xrLabel6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "PISTAS_DE_AUDITORIA.Apellidos") }); this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(152.3675F, 0F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel6.SizeF = new System.Drawing.SizeF(145.0877F, 23F); this.xrLabel6.Text = "xrLabel6"; // // xrLabel7 // this.xrLabel7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "PISTAS_DE_AUDITORIA.Fecha") }); this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(297.4551F, 0F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel7.SizeF = new System.Drawing.SizeF(115.4751F, 23F); this.xrLabel7.Text = "xrLabel7"; // // xrLabel8 // this.xrLabel8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "PISTAS_DE_AUDITORIA.Actividad") }); this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(412.9302F, 0F); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel8.SizeF = new System.Drawing.SizeF(178.9865F, 23F); this.xrLabel8.Text = "xrLabel8"; // // pageFooterBand1 // this.pageFooterBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo1, this.xrPageInfo2 }); this.pageFooterBand1.HeightF = 29F; this.pageFooterBand1.Name = "pageFooterBand1"; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 6F); 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(313F, 23F); this.xrPageInfo1.StyleName = "PageInfo"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Página {0} de {1}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(331F, 6F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(313F, 23F); this.xrPageInfo2.StyleName = "PageInfo"; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // reportHeaderBand1 // this.reportHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel9, this.xrLine3 }); this.reportHeaderBand1.HeightF = 57F; this.reportHeaderBand1.Name = "reportHeaderBand1"; // // xrLabel9 // this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(152.3675F, 1.999998F); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel9.SizeF = new System.Drawing.SizeF(279.6667F, 39F); this.xrLabel9.StyleName = "Title"; this.xrLabel9.Text = "Pistas de Auditoria"; // // xrLine3 // this.xrLine3.LocationFloat = new DevExpress.Utils.PointFloat(6F, 0F); this.xrLine3.Name = "xrLine3"; this.xrLine3.SizeF = new System.Drawing.SizeF(638F, 2F); // // 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", 24F); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.FieldCaption.BorderWidth = 1F; this.FieldCaption.Font = new System.Drawing.Font("Times New Roman", 10F, System.Drawing.FontStyle.Bold); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.PageInfo.BorderWidth = 1F; this.PageInfo.Font = new System.Drawing.Font("Times New Roman", 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DataField.BorderWidth = 1F; this.DataField.Font = new System.Drawing.Font("Times New Roman", 8F); this.DataField.ForeColor = System.Drawing.Color.Black; this.DataField.Name = "DataField"; this.DataField.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // PistasdeAuditoria // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.pageHeaderBand1, this.groupHeaderBand1, this.pageFooterBand1, this.reportHeaderBand1 }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "PISTAS_DE_AUDITORIA"; this.DataSource = this.sqlDataSource1; this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.FieldCaption, this.PageInfo, this.DataField }); 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.MySqlConnectionParameters mySqlConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.MySqlConnectionParameters(); DevExpress.DataAccess.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.QueryParameter queryParameter2 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.QueryParameter queryParameter3 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.RelationInfo relationInfo1 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo2 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo3 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo3 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.SortingInfo sortingInfo1 = new DevExpress.DataAccess.Sql.SortingInfo(); 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(); DevExpress.DataAccess.Sql.TableInfo tableInfo2 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo5 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo3 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo6 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo4 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo7 = new DevExpress.DataAccess.Sql.ColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(XtraReportVentas)); 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.pageHeaderBand1 = new DevExpress.XtraReports.UI.PageHeaderBand(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine1 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine2 = new DevExpress.XtraReports.UI.XRLine(); this.groupHeaderBand1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); 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.xrLabel13 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel14 = new DevExpress.XtraReports.UI.XRLabel(); this.pageFooterBand1 = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.reportHeaderBand1 = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel16 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel15 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine3 = new DevExpress.XtraReports.UI.XRLine(); 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.xrLabel17 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel18 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel19 = new DevExpress.XtraReports.UI.XRLabel(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.Detail.HeightF = 23.00002F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.StyleName = "DataField"; this.Detail.StylePriority.UseBorders = false; this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // TopMargin // this.TopMargin.HeightF = 68.75F; 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 = 100F; 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 = "dbsur_Connection"; mySqlConnectionParameters1.DatabaseName = "u983648979_dbsur"; mySqlConnectionParameters1.Password = "******"; mySqlConnectionParameters1.ServerName = "185.224.137.20"; mySqlConnectionParameters1.UserName = "******"; this.sqlDataSource1.ConnectionParameters = mySqlConnectionParameters1; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.FilterString = "[tblVenta.id_sucursal] = ?idSucursal And [tblVenta.fecha] Between(?dateFrom, ?dat" + "eTo)"; tableQuery1.GroupFilterString = ""; tableQuery1.Name = "tblVenta"; queryParameter1.Name = "dateTo"; queryParameter1.Type = typeof(System.DateTime); queryParameter1.ValueInfo = "2018-04-26"; queryParameter2.Name = "dateFrom"; queryParameter2.Type = typeof(System.DateTime); queryParameter2.ValueInfo = "2018-04-15"; queryParameter3.Name = "idSucursal"; queryParameter3.Type = typeof(int); queryParameter3.ValueInfo = "1"; tableQuery1.Parameters.Add(queryParameter1); tableQuery1.Parameters.Add(queryParameter2); tableQuery1.Parameters.Add(queryParameter3); relationColumnInfo1.NestedKeyColumn = "id_cliente"; relationColumnInfo1.ParentKeyColumn = "id_cliente"; relationInfo1.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo1 }); relationInfo1.NestedTable = "tblCliente"; relationInfo1.ParentTable = "tblVenta"; relationColumnInfo2.NestedKeyColumn = "id_empleado"; relationColumnInfo2.ParentKeyColumn = "id_empleado"; relationInfo2.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo2 }); relationInfo2.NestedTable = "tblEmpleado"; relationInfo2.ParentTable = "tblVenta"; relationColumnInfo3.NestedKeyColumn = "id_sucursal"; relationColumnInfo3.ParentKeyColumn = "id_sucursal"; relationInfo3.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo3 }); relationInfo3.NestedTable = "tblSucursal"; relationInfo3.ParentTable = "tblVenta"; tableQuery1.Relations.AddRange(new DevExpress.DataAccess.Sql.RelationInfo[] { relationInfo1, relationInfo2, relationInfo3 }); sortingInfo1.Column = "fecha"; sortingInfo1.Table = "tblVenta"; tableQuery1.Sorting.AddRange(new DevExpress.DataAccess.Sql.SortingInfo[] { sortingInfo1 }); tableInfo1.Name = "tblVenta"; columnInfo1.Alias = "Cod. Venta"; columnInfo1.Name = "id_venta"; columnInfo2.Alias = "Documento"; columnInfo2.Name = "documento"; columnInfo3.Alias = "Total Venta"; columnInfo3.Name = "total"; columnInfo4.Alias = "Fecha de Venta"; columnInfo4.Name = "fecha"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1, columnInfo2, columnInfo3, columnInfo4 }); tableInfo2.Name = "tblCliente"; columnInfo5.Alias = "Nit Cliente"; columnInfo5.Name = "nit"; tableInfo2.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo5 }); tableInfo3.Name = "tblEmpleado"; columnInfo6.Alias = "Encargado"; columnInfo6.Name = "nombre"; tableInfo3.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo6 }); tableInfo4.Name = "tblSucursal"; columnInfo7.Alias = "Sucursal"; columnInfo7.Name = "nombre_sucursal"; tableInfo4.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo7 }); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1, tableInfo2, tableInfo3, tableInfo4 }); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // pageHeaderBand1 // this.pageHeaderBand1.BackColor = System.Drawing.Color.DarkGray; this.pageHeaderBand1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.pageHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1, this.xrLabel2, this.xrLabel3, this.xrLabel4, this.xrLabel5, this.xrLabel6, this.xrLabel7, this.xrLine1, this.xrLine2 }); this.pageHeaderBand1.HeightF = 45F; this.pageHeaderBand1.Name = "pageHeaderBand1"; this.pageHeaderBand1.StylePriority.UseBackColor = false; this.pageHeaderBand1.StylePriority.UseBorders = false; // // xrLabel1 // this.xrLabel1.BackColor = System.Drawing.Color.Teal; this.xrLabel1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(6.00001F, 7.000001F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(64.55699F, 36F); this.xrLabel1.StyleName = "FieldCaption"; this.xrLabel1.StylePriority.UseBackColor = false; this.xrLabel1.StylePriority.UseBorders = false; this.xrLabel1.StylePriority.UseTextAlignment = false; this.xrLabel1.Text = "Cod Venta"; this.xrLabel1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrLabel2 // this.xrLabel2.BackColor = System.Drawing.Color.Teal; this.xrLabel2.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(70.55701F, 7.000001F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(103.5302F, 36F); this.xrLabel2.StyleName = "FieldCaption"; this.xrLabel2.StylePriority.UseBackColor = false; this.xrLabel2.StylePriority.UseBorders = false; this.xrLabel2.StylePriority.UseTextAlignment = false; this.xrLabel2.Text = "Documento"; this.xrLabel2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrLabel3 // this.xrLabel3.BackColor = System.Drawing.Color.Teal; this.xrLabel3.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(174.0872F, 7.000001F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(85.60603F, 36F); this.xrLabel3.StyleName = "FieldCaption"; this.xrLabel3.StylePriority.UseBackColor = false; this.xrLabel3.StylePriority.UseBorders = false; this.xrLabel3.StylePriority.UseTextAlignment = false; this.xrLabel3.Text = "Total Venta"; this.xrLabel3.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrLabel4 // this.xrLabel4.BackColor = System.Drawing.Color.Teal; this.xrLabel4.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(259.6932F, 7.000001F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(108.3107F, 36F); this.xrLabel4.StyleName = "FieldCaption"; this.xrLabel4.StylePriority.UseBackColor = false; this.xrLabel4.StylePriority.UseBorders = false; this.xrLabel4.StylePriority.UseTextAlignment = false; this.xrLabel4.Text = "Fecha de Venta"; this.xrLabel4.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrLabel5 // this.xrLabel5.BackColor = System.Drawing.Color.Teal; this.xrLabel5.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(368.004F, 7.000001F); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel5.SizeF = new System.Drawing.SizeF(83.91702F, 36F); this.xrLabel5.StyleName = "FieldCaption"; this.xrLabel5.StylePriority.UseBackColor = false; this.xrLabel5.StylePriority.UseBorders = false; this.xrLabel5.StylePriority.UseTextAlignment = false; this.xrLabel5.Text = "Nit Cliente"; this.xrLabel5.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrLabel6 // this.xrLabel6.BackColor = System.Drawing.Color.Teal; this.xrLabel6.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(451.921F, 7.000001F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel6.SizeF = new System.Drawing.SizeF(102.9907F, 36F); this.xrLabel6.StyleName = "FieldCaption"; this.xrLabel6.StylePriority.UseBackColor = false; this.xrLabel6.StylePriority.UseBorders = false; this.xrLabel6.StylePriority.UseTextAlignment = false; this.xrLabel6.Text = "Encargado"; this.xrLabel6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrLabel7 // this.xrLabel7.BackColor = System.Drawing.Color.Teal; this.xrLabel7.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(554.9117F, 7.000001F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel7.SizeF = new System.Drawing.SizeF(89.08826F, 36F); this.xrLabel7.StyleName = "FieldCaption"; this.xrLabel7.StylePriority.UseBackColor = false; this.xrLabel7.StylePriority.UseBorders = false; this.xrLabel7.StylePriority.UseTextAlignment = false; this.xrLabel7.Text = "Sucursal"; this.xrLabel7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrLine1 // this.xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 5F); this.xrLine1.Name = "xrLine1"; this.xrLine1.SizeF = new System.Drawing.SizeF(638F, 2F); // // xrLine2 // this.xrLine2.LocationFloat = new DevExpress.Utils.PointFloat(6F, 43F); this.xrLine2.Name = "xrLine2"; this.xrLine2.SizeF = new System.Drawing.SizeF(638F, 2F); // // groupHeaderBand1 // this.groupHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel8, this.xrLabel9, this.xrLabel10, this.xrLabel11, this.xrLabel12, this.xrLabel13, this.xrLabel14 }); this.groupHeaderBand1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("Cod. Venta", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Documento", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Total Venta", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Fecha de Venta", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Nit Cliente", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Encargado", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending), new DevExpress.XtraReports.UI.GroupField("Sucursal", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.groupHeaderBand1.HeightF = 23.00002F; this.groupHeaderBand1.Name = "groupHeaderBand1"; this.groupHeaderBand1.StyleName = "DataField"; // // xrLabel8 // this.xrLabel8.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.Cod. Venta") }); this.xrLabel8.Font = new System.Drawing.Font("Calibri", 9F); this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(6.00001F, 0F); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel8.SizeF = new System.Drawing.SizeF(64.557F, 23F); this.xrLabel8.StylePriority.UseBorders = false; this.xrLabel8.StylePriority.UseFont = false; this.xrLabel8.Text = "xrLabel8"; // // xrLabel9 // this.xrLabel9.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.Documento") }); this.xrLabel9.Font = new System.Drawing.Font("Calibri", 9F); this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(70.55701F, 0F); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel9.SizeF = new System.Drawing.SizeF(103.5302F, 23F); this.xrLabel9.StylePriority.UseBorders = false; this.xrLabel9.StylePriority.UseFont = false; this.xrLabel9.Text = "xrLabel9"; // // xrLabel10 // this.xrLabel10.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.Total Venta", "{0:Q0.00}") }); this.xrLabel10.Font = new System.Drawing.Font("Calibri", 9F); this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(174.0872F, 0F); this.xrLabel10.Name = "xrLabel10"; this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel10.SizeF = new System.Drawing.SizeF(85.60603F, 23F); this.xrLabel10.StylePriority.UseBorders = false; this.xrLabel10.StylePriority.UseFont = false; this.xrLabel10.Text = "xrLabel10"; // // xrLabel11 // this.xrLabel11.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.Fecha de Venta", "{0:d/MM/yyyy}") }); this.xrLabel11.Font = new System.Drawing.Font("Calibri", 9F); this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(259.6932F, 0F); this.xrLabel11.Name = "xrLabel11"; this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel11.SizeF = new System.Drawing.SizeF(108.3108F, 23F); this.xrLabel11.StylePriority.UseBorders = false; this.xrLabel11.StylePriority.UseFont = false; this.xrLabel11.Text = "xrLabel11"; // // xrLabel12 // this.xrLabel12.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.Nit Cliente") }); this.xrLabel12.Font = new System.Drawing.Font("Calibri", 9F); this.xrLabel12.LocationFloat = new DevExpress.Utils.PointFloat(368.004F, 0F); this.xrLabel12.Name = "xrLabel12"; this.xrLabel12.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel12.SizeF = new System.Drawing.SizeF(83.91702F, 23F); this.xrLabel12.StylePriority.UseBorders = false; this.xrLabel12.StylePriority.UseFont = false; this.xrLabel12.Text = "xrLabel12"; // // xrLabel13 // this.xrLabel13.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel13.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.Encargado") }); this.xrLabel13.Font = new System.Drawing.Font("Calibri", 9F); this.xrLabel13.LocationFloat = new DevExpress.Utils.PointFloat(451.9211F, 0F); this.xrLabel13.Name = "xrLabel13"; this.xrLabel13.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel13.SizeF = new System.Drawing.SizeF(102.9907F, 23F); this.xrLabel13.StylePriority.UseBorders = false; this.xrLabel13.StylePriority.UseFont = false; this.xrLabel13.Text = "xrLabel13"; // // xrLabel14 // this.xrLabel14.Borders = ((DevExpress.XtraPrinting.BorderSide)(((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrLabel14.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.Sucursal") }); this.xrLabel14.Font = new System.Drawing.Font("Calibri", 9F); this.xrLabel14.LocationFloat = new DevExpress.Utils.PointFloat(554.9117F, 0F); this.xrLabel14.Name = "xrLabel14"; this.xrLabel14.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel14.SizeF = new System.Drawing.SizeF(89.08826F, 23F); this.xrLabel14.StylePriority.UseBorders = false; this.xrLabel14.StylePriority.UseFont = false; this.xrLabel14.Text = "xrLabel14"; // // pageFooterBand1 // this.pageFooterBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo2 }); this.pageFooterBand1.HeightF = 29.00001F; this.pageFooterBand1.Name = "pageFooterBand1"; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(327F, 61.41668F); 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(313F, 23F); this.xrPageInfo1.StyleName = "PageInfo"; this.xrPageInfo1.StylePriority.UseTextAlignment = false; this.xrPageInfo1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // xrPageInfo2 // this.xrPageInfo2.Format = "Página {0} de {1}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(485.1667F, 6.00001F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(158.8333F, 23F); this.xrPageInfo2.StyleName = "PageInfo"; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // reportHeaderBand1 // this.reportHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel19, this.xrLabel18, this.xrLabel17, this.xrLabel16, this.xrLabel15, this.xrLine3, this.xrPageInfo1 }); this.reportHeaderBand1.HeightF = 147.4584F; this.reportHeaderBand1.Name = "reportHeaderBand1"; // // xrLabel16 // this.xrLabel16.Font = new System.Drawing.Font("Tahoma", 20F, System.Drawing.FontStyle.Bold); this.xrLabel16.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 61.41668F); this.xrLabel16.Name = "xrLabel16"; this.xrLabel16.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel16.SizeF = new System.Drawing.SizeF(140.1288F, 39.66667F); this.xrLabel16.StylePriority.UseFont = false; this.xrLabel16.Text = "Sucursal: "; // // xrLabel15 // this.xrLabel15.LocationFloat = new DevExpress.Utils.PointFloat(6F, 2F); this.xrLabel15.Name = "xrLabel15"; this.xrLabel15.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel15.SizeF = new System.Drawing.SizeF(638F, 43F); this.xrLabel15.StyleName = "Title"; this.xrLabel15.Text = "Reporte de Ventas"; // // xrLine3 // this.xrLine3.LocationFloat = new DevExpress.Utils.PointFloat(6F, 0F); this.xrLine3.Name = "xrLine3"; this.xrLine3.SizeF = new System.Drawing.SizeF(638F, 2F); // // 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("Tahoma", 24F, System.Drawing.FontStyle.Bold); this.Title.ForeColor = System.Drawing.Color.Teal; 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.Black; 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("Arial", 9F); 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("Arial", 10F); this.DataField.ForeColor = System.Drawing.Color.Black; this.DataField.Name = "DataField"; this.DataField.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // xrLabel17 // this.xrLabel17.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.Sucursal") }); this.xrLabel17.Font = new System.Drawing.Font("Tahoma", 20F, System.Drawing.FontStyle.Bold); this.xrLabel17.LocationFloat = new DevExpress.Utils.PointFloat(150.1288F, 61.41668F); this.xrLabel17.Name = "xrLabel17"; this.xrLabel17.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel17.SizeF = new System.Drawing.SizeF(140.1288F, 39.66667F); this.xrLabel17.StylePriority.UseFont = false; // // xrLabel18 // this.xrLabel18.Font = new System.Drawing.Font("Tahoma", 18F, System.Drawing.FontStyle.Bold); this.xrLabel18.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 101.0834F); this.xrLabel18.Name = "xrLabel18"; this.xrLabel18.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.xrLabel18.SizeF = new System.Drawing.SizeF(164.0872F, 36.37498F); this.xrLabel18.StylePriority.UseFont = false; this.xrLabel18.Text = "Encargado: "; // // xrLabel19 // this.xrLabel19.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.Encargado") }); this.xrLabel19.Font = new System.Drawing.Font("Tahoma", 18F, System.Drawing.FontStyle.Bold); this.xrLabel19.LocationFloat = new DevExpress.Utils.PointFloat(174.0872F, 101.0834F); this.xrLabel19.Name = "xrLabel19"; this.xrLabel19.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel19.SizeF = new System.Drawing.SizeF(207.8372F, 36.37498F); this.xrLabel19.StylePriority.UseFont = false; // // XtraReportVentas // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.pageHeaderBand1, this.groupHeaderBand1, this.pageFooterBand1, this.reportHeaderBand1 }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "tblVenta"; this.DataSource = this.sqlDataSource1; this.Margins = new System.Drawing.Printing.Margins(100, 100, 69, 100); 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.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.RelationInfo relationInfo1 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo2 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo3 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo3 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.SortingInfo sortingInfo1 = new DevExpress.DataAccess.Sql.SortingInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo1 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo1 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo2 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo2 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo3 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo3 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo4 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo4 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo5 = new DevExpress.DataAccess.Sql.ColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(VentasCategoriasporProducto)); 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.pageHeaderBand1 = new DevExpress.XtraReports.UI.PageHeaderBand(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine1 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine2 = new DevExpress.XtraReports.UI.XRLine(); this.groupHeaderBand1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel7 = 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.pageFooterBand1 = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.reportHeaderBand1 = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel11 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine3 = new DevExpress.XtraReports.UI.XRLine(); 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(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.HeightF = 23F; 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.HeightF = 100F; 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 = 100F; 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 = "POSIXConnectionString"; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.Name = "VENTAS"; relationColumnInfo1.NestedKeyColumn = "IdVenta"; relationColumnInfo1.ParentKeyColumn = "IdVenta"; relationInfo1.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo1 }); relationInfo1.NestedTable = "DETALLE_VENTAS"; relationInfo1.ParentTable = "VENTAS"; relationColumnInfo2.NestedKeyColumn = "IdProducto"; relationColumnInfo2.ParentKeyColumn = "IdProducto"; relationInfo2.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo2 }); relationInfo2.NestedTable = "PRODUCTOS"; relationInfo2.ParentTable = "DETALLE_VENTAS"; relationColumnInfo3.NestedKeyColumn = "IdCategoria"; relationColumnInfo3.ParentKeyColumn = "IdCategoria"; relationInfo3.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo3 }); relationInfo3.NestedTable = "CATEGORIAS_PRODUCTOS"; relationInfo3.ParentTable = "PRODUCTOS"; tableQuery1.Relations.AddRange(new DevExpress.DataAccess.Sql.RelationInfo[] { relationInfo1, relationInfo2, relationInfo3 }); sortingInfo1.Column = "Categoria"; sortingInfo1.Table = "CATEGORIAS_PRODUCTOS"; tableQuery1.Sorting.AddRange(new DevExpress.DataAccess.Sql.SortingInfo[] { sortingInfo1 }); tableInfo1.Name = "VENTAS"; columnInfo1.Name = "Total"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1 }); tableInfo2.Name = "DETALLE_VENTAS"; columnInfo2.Name = "Cantidad"; tableInfo2.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo2 }); tableInfo3.Name = "PRODUCTOS"; columnInfo3.Name = "Nombre_Producto"; columnInfo4.Name = "Precio_Costo"; tableInfo3.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo3, columnInfo4 }); tableInfo4.Name = "CATEGORIAS_PRODUCTOS"; columnInfo5.Name = "Categoria"; tableInfo4.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo5 }); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1, tableInfo2, tableInfo3, tableInfo4 }); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // pageHeaderBand1 // this.pageHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1, this.xrLabel2, this.xrLabel3, this.xrLabel4, this.xrLabel5, this.xrLine1, this.xrLine2 }); this.pageHeaderBand1.HeightF = 45F; this.pageHeaderBand1.Name = "pageHeaderBand1"; // // xrLabel1 // this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 7F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(109.3714F, 36F); this.xrLabel1.StyleName = "FieldCaption"; this.xrLabel1.Text = "Cantidad"; // // xrLabel2 // this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(115.3714F, 7F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(114.84F, 36F); this.xrLabel2.StyleName = "FieldCaption"; this.xrLabel2.Text = "Categoria"; // // xrLabel3 // this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(230.2114F, 7F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(202.3371F, 36F); this.xrLabel3.StyleName = "FieldCaption"; this.xrLabel3.Text = "Nombre Producto"; // // xrLabel4 // this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(432.5486F, 7F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(145.8286F, 36F); this.xrLabel4.StyleName = "FieldCaption"; this.xrLabel4.Text = "Precio Costo"; // // xrLabel5 // this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(578.3771F, 7F); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel5.SizeF = new System.Drawing.SizeF(65.62286F, 36F); this.xrLabel5.StyleName = "FieldCaption"; this.xrLabel5.Text = "Total"; // // xrLine1 // this.xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 5F); this.xrLine1.Name = "xrLine1"; this.xrLine1.SizeF = new System.Drawing.SizeF(638F, 2F); // // xrLine2 // this.xrLine2.LocationFloat = new DevExpress.Utils.PointFloat(6F, 43F); this.xrLine2.Name = "xrLine2"; this.xrLine2.SizeF = new System.Drawing.SizeF(638F, 2F); // // groupHeaderBand1 // this.groupHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel6, this.xrLabel7, this.xrLabel8, this.xrLabel9, this.xrLabel10 }); this.groupHeaderBand1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("Cantidad", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.groupHeaderBand1.HeightF = 23F; this.groupHeaderBand1.Name = "groupHeaderBand1"; this.groupHeaderBand1.StyleName = "DataField"; // // xrLabel6 // this.xrLabel6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "VENTAS.Cantidad") }); this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(6F, 0F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel6.SizeF = new System.Drawing.SizeF(109.3714F, 23F); this.xrLabel6.Text = "xrLabel6"; // // xrLabel7 // this.xrLabel7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "VENTAS.Categoria") }); this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(115.3714F, 0F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel7.SizeF = new System.Drawing.SizeF(114.84F, 23F); this.xrLabel7.Text = "xrLabel7"; // // xrLabel8 // this.xrLabel8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "VENTAS.Nombre_Producto") }); this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(230.2115F, 0F); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel8.SizeF = new System.Drawing.SizeF(202.3371F, 23F); this.xrLabel8.Text = "xrLabel8"; // // xrLabel9 // this.xrLabel9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "VENTAS.Precio_Costo", "{0:C2}") }); this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(432.5486F, 0F); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel9.SizeF = new System.Drawing.SizeF(145.8286F, 23F); this.xrLabel9.Text = "xrLabel9"; // // xrLabel10 // this.xrLabel10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "VENTAS.Total", "{0:C2}") }); this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(578.3771F, 0F); this.xrLabel10.Name = "xrLabel10"; this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel10.SizeF = new System.Drawing.SizeF(65.62286F, 23F); this.xrLabel10.Text = "xrLabel10"; // // pageFooterBand1 // this.pageFooterBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo1, this.xrPageInfo2 }); this.pageFooterBand1.HeightF = 29F; this.pageFooterBand1.Name = "pageFooterBand1"; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 6F); 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(313F, 23F); this.xrPageInfo1.StyleName = "PageInfo"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Página {0} de {1}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(331F, 6F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(313F, 23F); this.xrPageInfo2.StyleName = "PageInfo"; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // reportHeaderBand1 // this.reportHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel11, this.xrLine3 }); this.reportHeaderBand1.HeightF = 57F; this.reportHeaderBand1.Name = "reportHeaderBand1"; // // xrLabel11 // this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(96.81373F, 8F); this.xrLabel11.Name = "xrLabel11"; this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel11.SizeF = new System.Drawing.SizeF(460.3039F, 39F); this.xrLabel11.StyleName = "Title"; this.xrLabel11.Text = "Ventas Categorias por Producto"; // // xrLine3 // this.xrLine3.LocationFloat = new DevExpress.Utils.PointFloat(6F, 0F); this.xrLine3.Name = "xrLine3"; this.xrLine3.SizeF = new System.Drawing.SizeF(638F, 2F); // // 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", 24F); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.FieldCaption.BorderWidth = 1F; this.FieldCaption.Font = new System.Drawing.Font("Times New Roman", 10F, System.Drawing.FontStyle.Bold); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.PageInfo.BorderWidth = 1F; this.PageInfo.Font = new System.Drawing.Font("Times New Roman", 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DataField.BorderWidth = 1F; this.DataField.Font = new System.Drawing.Font("Times New Roman", 8F); this.DataField.ForeColor = System.Drawing.Color.Black; this.DataField.Name = "DataField"; this.DataField.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // VentasCategoriasporProducto // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.pageHeaderBand1, this.groupHeaderBand1, this.pageFooterBand1, this.reportHeaderBand1 }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "VENTAS"; this.DataSource = this.sqlDataSource1; this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.FieldCaption, this.PageInfo, this.DataField }); 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.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.RelationInfo relationInfo1 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo2 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.SortingInfo sortingInfo1 = new DevExpress.DataAccess.Sql.SortingInfo(); 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.TableInfo tableInfo2 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo3 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo4 = new DevExpress.DataAccess.Sql.ColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ClientesporDepartamento)); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.pageFooterBand1 = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.reportHeaderBand1 = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine7 = new DevExpress.XtraReports.UI.XRLine(); 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.xrLine10 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine12 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine9 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine1 = new DevExpress.XtraReports.UI.XRLine(); this.groupHeaderBand5 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrLine5 = new DevExpress.XtraReports.UI.XRLine(); this.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel4, this.xrLabel2, this.xrLabel6, this.xrLabel8 }); this.Detail.HeightF = 52.66666F; 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; // // xrLabel4 // this.xrLabel4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CLIENTES.Nombres") }); this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(124.7499F, 0F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(88.16665F, 36F); this.xrLabel4.StyleName = "DataField"; this.xrLabel4.Text = "xrLabel4"; // // xrLabel2 // this.xrLabel2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CLIENTES.RTN") }); this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(6.00001F, 0F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(97.89581F, 36F); this.xrLabel2.StyleName = "DataField"; this.xrLabel2.Text = "xrLabel2"; // // xrLabel6 // this.xrLabel6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CLIENTES.Apellidos") }); this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(273.6458F, 0F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel6.SizeF = new System.Drawing.SizeF(110F, 36F); this.xrLabel6.StyleName = "DataField"; this.xrLabel6.Text = "xrLabel6"; // // xrLabel8 // this.xrLabel8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CLIENTES.Departamento") }); this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(460.9375F, 0F); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel8.SizeF = new System.Drawing.SizeF(138.9584F, 36F); this.xrLabel8.StyleName = "DataField"; this.xrLabel8.Text = "xrLabel8"; // // TopMargin // this.TopMargin.HeightF = 47.91667F; 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 = 100F; 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 = "POSIXConnectionString"; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.Name = "CLIENTES"; relationColumnInfo1.NestedKeyColumn = "IdMunicipio"; relationColumnInfo1.ParentKeyColumn = "IdMunicipio"; relationInfo1.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo1 }); relationInfo1.NestedTable = "MUNICIPIO"; relationInfo1.ParentTable = "CLIENTES"; relationColumnInfo2.NestedKeyColumn = "IdDepto"; relationColumnInfo2.ParentKeyColumn = "IdDepto"; relationInfo2.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo2 }); relationInfo2.NestedTable = "DEPARTAMENTO"; relationInfo2.ParentTable = "MUNICIPIO"; tableQuery1.Relations.AddRange(new DevExpress.DataAccess.Sql.RelationInfo[] { relationInfo1, relationInfo2 }); sortingInfo1.Column = "Departamento"; sortingInfo1.Table = "DEPARTAMENTO"; tableQuery1.Sorting.AddRange(new DevExpress.DataAccess.Sql.SortingInfo[] { sortingInfo1 }); tableInfo1.Name = "CLIENTES"; columnInfo1.Name = "RTN"; columnInfo2.Name = "Nombres"; columnInfo3.Name = "Apellidos"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1, columnInfo2, columnInfo3 }); tableInfo2.Name = "MUNICIPIO"; tableInfo3.Name = "DEPARTAMENTO"; columnInfo4.Name = "Departamento"; tableInfo3.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo4 }); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1, tableInfo2, tableInfo3 }); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // xrLabel7 // this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(464.9375F, 10.00001F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel7.SizeF = new System.Drawing.SizeF(138.9584F, 36F); this.xrLabel7.StyleName = "FieldCaption"; this.xrLabel7.Text = "Departamento"; // // xrLabel5 // this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(277.6458F, 10.00001F); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel5.SizeF = new System.Drawing.SizeF(110F, 36F); this.xrLabel5.StyleName = "FieldCaption"; this.xrLabel5.Text = "Apellidos"; // // xrLabel3 // this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(128.7499F, 12.00002F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(88.16662F, 36F); this.xrLabel3.StyleName = "FieldCaption"; this.xrLabel3.Text = "Nombres"; // // xrLabel1 // this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 10.00001F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(96.5F, 36F); this.xrLabel1.StyleName = "FieldCaption"; this.xrLabel1.Text = "RTN"; // // pageFooterBand1 // this.pageFooterBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo1, this.xrPageInfo2 }); this.pageFooterBand1.HeightF = 31F; this.pageFooterBand1.Name = "pageFooterBand1"; // // 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(313F, 23F); this.xrPageInfo1.StyleName = "PageInfo"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Página {0} de {1}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(331F, 8F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(313F, 23F); this.xrPageInfo2.StyleName = "PageInfo"; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // reportHeaderBand1 // this.reportHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel9, this.xrLine7 }); this.reportHeaderBand1.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); this.reportHeaderBand1.HeightF = 89.29167F; this.reportHeaderBand1.Name = "reportHeaderBand1"; this.reportHeaderBand1.StylePriority.UseFont = false; // // xrLabel9 // this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(153.9166F, 10.00001F); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel9.SizeF = new System.Drawing.SizeF(366.125F, 39F); this.xrLabel9.StyleName = "Title"; this.xrLabel9.Text = "Clientes por Departamento"; // // xrLine7 // this.xrLine7.LocationFloat = new DevExpress.Utils.PointFloat(153.9166F, 46.91668F); this.xrLine7.Name = "xrLine7"; this.xrLine7.SizeF = new System.Drawing.SizeF(366.125F, 2.083332F); // // 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", 24F); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.FieldCaption.BorderWidth = 1F; this.FieldCaption.Font = new System.Drawing.Font("Times New Roman", 10F, System.Drawing.FontStyle.Bold); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.PageInfo.BorderWidth = 1F; this.PageInfo.Font = new System.Drawing.Font("Times New Roman", 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DataField.BorderWidth = 1F; this.DataField.Font = new System.Drawing.Font("Times New Roman", 8F); this.DataField.ForeColor = System.Drawing.Color.Black; this.DataField.Name = "DataField"; this.DataField.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // xrLine10 // this.xrLine10.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 8.000007F); this.xrLine10.Name = "xrLine10"; this.xrLine10.SizeF = new System.Drawing.SizeF(124F, 2F); // // xrLine12 // this.xrLine12.LocationFloat = new DevExpress.Utils.PointFloat(120.75F, 7.999992F); this.xrLine12.Name = "xrLine12"; this.xrLine12.SizeF = new System.Drawing.SizeF(186F, 2F); // // xrLine9 // this.xrLine9.LocationFloat = new DevExpress.Utils.PointFloat(287.3334F, 7.999992F); this.xrLine9.Name = "xrLine9"; this.xrLine9.SizeF = new System.Drawing.SizeF(186F, 2F); // // xrLine1 // this.xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(458.0001F, 8.000007F); this.xrLine1.Name = "xrLine1"; this.xrLine1.SizeF = new System.Drawing.SizeF(186F, 2F); // // groupHeaderBand5 // this.groupHeaderBand5.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLine1, this.xrLine9, this.xrLine12, this.xrLine10, this.xrLine5 }); this.groupHeaderBand5.HeightF = 24.45835F; this.groupHeaderBand5.Name = "groupHeaderBand5"; this.groupHeaderBand5.StyleName = "FieldCaption"; // // xrLine5 // this.xrLine5.LocationFloat = new DevExpress.Utils.PointFloat(6.000105F, 10.00001F); this.xrLine5.Name = "xrLine5"; this.xrLine5.SizeF = new System.Drawing.SizeF(638F, 2F); // // PageHeader // this.PageHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1, this.xrLabel3, this.xrLabel5, this.xrLabel7 }); this.PageHeader.HeightF = 61.45833F; this.PageHeader.Name = "PageHeader"; // // ClientesporDepartamento // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.groupHeaderBand5, this.pageFooterBand1, this.reportHeaderBand1, this.PageHeader }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "CLIENTES"; this.DataSource = this.sqlDataSource1; this.Margins = new System.Drawing.Printing.Margins(100, 100, 48, 100); this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.FieldCaption, this.PageInfo, this.DataField }); 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.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.RelationInfo relationInfo1 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo2 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.SortingInfo sortingInfo1 = new DevExpress.DataAccess.Sql.SortingInfo(); 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(); DevExpress.DataAccess.Sql.TableInfo tableInfo2 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo5 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo3 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo6 = new DevExpress.DataAccess.Sql.ColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ClientesporPreferencia)); 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.pageHeaderBand1 = new DevExpress.XtraReports.UI.PageHeaderBand(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine1 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine2 = new DevExpress.XtraReports.UI.XRLine(); this.groupHeaderBand1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrLabel7 = 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.pageFooterBand1 = new DevExpress.XtraReports.UI.PageFooterBand(); 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.xrLine3 = new DevExpress.XtraReports.UI.XRLine(); 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(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.HeightF = 23F; 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.HeightF = 100F; 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 = 100F; 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 = "POSIXConnectionString"; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.Name = "CLIENTES"; relationColumnInfo1.NestedKeyColumn = "IdCliente"; relationColumnInfo1.ParentKeyColumn = "IdCliente"; relationInfo1.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo1 }); relationInfo1.NestedTable = "CLIENTES_HAS_PREFFS"; relationInfo1.ParentTable = "CLIENTES"; relationColumnInfo2.NestedKeyColumn = "IdCategoria"; relationColumnInfo2.ParentKeyColumn = "IdCategoria"; relationInfo2.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo2 }); relationInfo2.NestedTable = "CATEGORIAS_PRODUCTOS"; relationInfo2.ParentTable = "CLIENTES_HAS_PREFFS"; tableQuery1.Relations.AddRange(new DevExpress.DataAccess.Sql.RelationInfo[] { relationInfo1, relationInfo2 }); sortingInfo1.Column = "Nombres"; sortingInfo1.Table = "CLIENTES"; tableQuery1.Sorting.AddRange(new DevExpress.DataAccess.Sql.SortingInfo[] { sortingInfo1 }); tableInfo1.Name = "CLIENTES"; columnInfo1.Name = "RTN"; columnInfo2.Name = "Nombres"; columnInfo3.Name = "Apellidos"; columnInfo4.Name = "Telefono"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1, columnInfo2, columnInfo3, columnInfo4 }); tableInfo2.Name = "CLIENTES_HAS_PREFFS"; columnInfo5.Name = "Observacion"; tableInfo2.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo5 }); tableInfo3.Name = "CATEGORIAS_PRODUCTOS"; columnInfo6.Name = "Categoria"; tableInfo3.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo6 }); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1, tableInfo2, tableInfo3 }); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // pageHeaderBand1 // this.pageHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1, this.xrLabel2, this.xrLabel3, this.xrLabel4, this.xrLabel5, this.xrLabel6, this.xrLine1, this.xrLine2 }); this.pageHeaderBand1.HeightF = 45F; this.pageHeaderBand1.Name = "pageHeaderBand1"; // // xrLabel1 // this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 7F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(61.80057F, 36F); this.xrLabel1.StyleName = "FieldCaption"; this.xrLabel1.Text = "RTN"; // // xrLabel2 // this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(67.80057F, 7F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(107.2422F, 36F); this.xrLabel2.StyleName = "FieldCaption"; this.xrLabel2.Text = "Nombres"; // // xrLabel3 // this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(175.0427F, 7F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(109.0598F, 36F); this.xrLabel3.StyleName = "FieldCaption"; this.xrLabel3.Text = "Apellidos"; // // xrLabel4 // this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(284.1025F, 7F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(101.7892F, 36F); this.xrLabel4.StyleName = "FieldCaption"; this.xrLabel4.Text = "Telefono"; // // xrLabel5 // this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(385.8917F, 7F); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel5.SizeF = new System.Drawing.SizeF(114.5128F, 36F); this.xrLabel5.StyleName = "FieldCaption"; this.xrLabel5.Text = "Categoria"; // // xrLabel6 // this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(500.4045F, 7F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel6.SizeF = new System.Drawing.SizeF(143.5955F, 36F); this.xrLabel6.StyleName = "FieldCaption"; this.xrLabel6.Text = "Observacion"; // // xrLine1 // this.xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 5F); this.xrLine1.Name = "xrLine1"; this.xrLine1.SizeF = new System.Drawing.SizeF(638F, 2F); // // xrLine2 // this.xrLine2.LocationFloat = new DevExpress.Utils.PointFloat(6F, 43F); this.xrLine2.Name = "xrLine2"; this.xrLine2.SizeF = new System.Drawing.SizeF(638F, 2F); // // groupHeaderBand1 // this.groupHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel7, this.xrLabel8, this.xrLabel9, this.xrLabel10, this.xrLabel11, this.xrLabel12 }); this.groupHeaderBand1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("RTN", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.groupHeaderBand1.HeightF = 33.00001F; this.groupHeaderBand1.Name = "groupHeaderBand1"; this.groupHeaderBand1.StyleName = "DataField"; // // xrLabel7 // this.xrLabel7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CLIENTES.RTN") }); this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(6F, 0F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel7.SizeF = new System.Drawing.SizeF(61.80057F, 23F); this.xrLabel7.Text = "xrLabel7"; // // xrLabel8 // this.xrLabel8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CLIENTES.Nombres") }); this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(67.80055F, 0F); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel8.SizeF = new System.Drawing.SizeF(107.2422F, 23F); this.xrLabel8.Text = "xrLabel8"; // // xrLabel9 // this.xrLabel9.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CLIENTES.Apellidos") }); this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(175.0427F, 3.178914E-05F); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel9.SizeF = new System.Drawing.SizeF(109.0598F, 23F); this.xrLabel9.Text = "xrLabel9"; // // xrLabel10 // this.xrLabel10.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CLIENTES.Telefono") }); this.xrLabel10.LocationFloat = new DevExpress.Utils.PointFloat(284.1026F, 0F); this.xrLabel10.Name = "xrLabel10"; this.xrLabel10.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel10.SizeF = new System.Drawing.SizeF(101.7892F, 23F); this.xrLabel10.Text = "xrLabel10"; // // xrLabel11 // this.xrLabel11.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CLIENTES.Categoria") }); this.xrLabel11.LocationFloat = new DevExpress.Utils.PointFloat(385.8917F, 3.178914E-05F); this.xrLabel11.Name = "xrLabel11"; this.xrLabel11.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel11.SizeF = new System.Drawing.SizeF(114.5128F, 23F); this.xrLabel11.Text = "xrLabel11"; // // xrLabel12 // this.xrLabel12.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "CLIENTES.Observacion") }); this.xrLabel12.LocationFloat = new DevExpress.Utils.PointFloat(500.4045F, 0F); this.xrLabel12.Name = "xrLabel12"; this.xrLabel12.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel12.SizeF = new System.Drawing.SizeF(143.5955F, 23F); this.xrLabel12.Text = "xrLabel12"; // // pageFooterBand1 // this.pageFooterBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo1, this.xrPageInfo2 }); this.pageFooterBand1.HeightF = 29F; this.pageFooterBand1.Name = "pageFooterBand1"; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 6F); 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(313F, 23F); this.xrPageInfo1.StyleName = "PageInfo"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Página {0} de {1}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(331F, 6F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(313F, 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.xrLine3 }); this.reportHeaderBand1.HeightF = 57F; this.reportHeaderBand1.Name = "reportHeaderBand1"; // // xrLabel13 // this.xrLabel13.LocationFloat = new DevExpress.Utils.PointFloat(108.2379F, 1.999998F); this.xrLabel13.Name = "xrLabel13"; this.xrLabel13.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel13.SizeF = new System.Drawing.SizeF(392.1667F, 39F); this.xrLabel13.StyleName = "Title"; this.xrLabel13.Text = "Clientes por Preferencia"; // // xrLine3 // this.xrLine3.LocationFloat = new DevExpress.Utils.PointFloat(6F, 0F); this.xrLine3.Name = "xrLine3"; this.xrLine3.SizeF = new System.Drawing.SizeF(638F, 2F); // // 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", 24F); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.FieldCaption.BorderWidth = 1F; this.FieldCaption.Font = new System.Drawing.Font("Times New Roman", 10F, System.Drawing.FontStyle.Bold); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.PageInfo.BorderWidth = 1F; this.PageInfo.Font = new System.Drawing.Font("Times New Roman", 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DataField.BorderWidth = 1F; this.DataField.Font = new System.Drawing.Font("Times New Roman", 8F); this.DataField.ForeColor = System.Drawing.Color.Black; this.DataField.Name = "DataField"; this.DataField.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // ClientesporPreferencia // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.pageHeaderBand1, this.groupHeaderBand1, this.pageFooterBand1, this.reportHeaderBand1 }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "CLIENTES"; this.DataSource = this.sqlDataSource1; this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.FieldCaption, this.PageInfo, this.DataField }); 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.MySqlConnectionParameters mySqlConnectionParameters1 = new DevExpress.DataAccess.ConnectionParameters.MySqlConnectionParameters(); DevExpress.DataAccess.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.QueryParameter queryParameter1 = new DevExpress.DataAccess.Sql.QueryParameter(); DevExpress.DataAccess.Sql.RelationInfo relationInfo1 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo2 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.SortingInfo sortingInfo1 = new DevExpress.DataAccess.Sql.SortingInfo(); 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(); DevExpress.DataAccess.Sql.TableInfo tableInfo2 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo5 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo6 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo7 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo3 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo8 = new DevExpress.DataAccess.Sql.ColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(reporteEmpleado)); 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.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrTable1 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow1 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell1 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell2 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell3 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell4 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTable2 = new DevExpress.XtraReports.UI.XRTable(); this.xrTableRow2 = new DevExpress.XtraReports.UI.XRTableRow(); this.xrTableCell5 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell6 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell7 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrTableCell8 = new DevExpress.XtraReports.UI.XRTableCell(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel(); this.ReportHeader = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel(); ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrTable2 }); this.Detail.HeightF = 25F; this.Detail.Name = "Detail"; this.Detail.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F); this.Detail.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft; // // TopMargin // this.TopMargin.HeightF = 17.70833F; 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 = 100F; 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 = "dbsur_Connection"; mySqlConnectionParameters1.DatabaseName = "u983648979_dbsur"; mySqlConnectionParameters1.Password = "******"; mySqlConnectionParameters1.ServerName = "185.224.137.20"; mySqlConnectionParameters1.UserName = "******"; this.sqlDataSource1.ConnectionParameters = mySqlConnectionParameters1; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.FilterString = "[tblEmpleado.id_empleado] = ?idempleado"; tableQuery1.GroupFilterString = ""; tableQuery1.Name = "tblVenta"; queryParameter1.Name = "idempleado"; queryParameter1.Type = typeof(int); queryParameter1.ValueInfo = "1"; tableQuery1.Parameters.Add(queryParameter1); relationColumnInfo1.NestedKeyColumn = "id_empleado"; relationColumnInfo1.ParentKeyColumn = "id_empleado"; relationInfo1.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo1 }); relationInfo1.NestedTable = "tblEmpleado"; relationInfo1.ParentTable = "tblVenta"; relationColumnInfo2.NestedKeyColumn = "id_sucursal"; relationColumnInfo2.ParentKeyColumn = "id_sucursal"; relationInfo2.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo2 }); relationInfo2.NestedTable = "tblSucursal"; relationInfo2.ParentTable = "tblVenta"; tableQuery1.Relations.AddRange(new DevExpress.DataAccess.Sql.RelationInfo[] { relationInfo1, relationInfo2 }); sortingInfo1.Column = "fecha"; sortingInfo1.Table = "tblVenta"; tableQuery1.Sorting.AddRange(new DevExpress.DataAccess.Sql.SortingInfo[] { sortingInfo1 }); tableInfo1.Name = "tblVenta"; columnInfo1.Name = "fecha"; columnInfo2.Name = "total"; columnInfo3.Name = "documento"; columnInfo4.Name = "id_venta"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1, columnInfo2, columnInfo3, columnInfo4 }); tableInfo2.Name = "tblEmpleado"; columnInfo5.Name = "nombre"; columnInfo6.Name = "apellido"; columnInfo7.Name = "usuario"; tableInfo2.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo5, columnInfo6, columnInfo7 }); tableInfo3.Name = "tblSucursal"; columnInfo8.Name = "nombre_sucursal"; tableInfo3.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo8 }); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1, tableInfo2, tableInfo3 }); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // xrLabel1 // this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 48.95833F); 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.Text = "Nombre:"; // // xrLabel2 // this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 71.95835F); 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.Text = "Apellido:"; // // xrLabel3 // this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(389.5833F, 48.95833F); 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.Text = "Usuario:"; // // xrLabel4 // this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(389.5833F, 71.95835F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(100F, 23F); this.xrLabel4.Text = "Sucursal"; // // xrTable1 // this.xrTable1.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable1.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrTable1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 122.9167F); this.xrTable1.Name = "xrTable1"; this.xrTable1.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow1 }); this.xrTable1.SizeF = new System.Drawing.SizeF(650F, 25F); this.xrTable1.StylePriority.UseBorders = false; this.xrTable1.StylePriority.UseFont = false; this.xrTable1.StylePriority.UseTextAlignment = false; this.xrTable1.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // xrTableRow1 // this.xrTableRow1.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell1, this.xrTableCell2, this.xrTableCell3, this.xrTableCell4 }); this.xrTableRow1.Name = "xrTableRow1"; this.xrTableRow1.Weight = 1D; // // xrTableCell1 // this.xrTableCell1.Name = "xrTableCell1"; this.xrTableCell1.Text = "# VENTA"; this.xrTableCell1.Weight = 1D; // // xrTableCell2 // this.xrTableCell2.Name = "xrTableCell2"; this.xrTableCell2.Text = "FECHA"; this.xrTableCell2.Weight = 1D; // // xrTableCell3 // this.xrTableCell3.Name = "xrTableCell3"; this.xrTableCell3.Text = "DOCUMENTO"; this.xrTableCell3.Weight = 3.03125D; // // xrTableCell4 // this.xrTableCell4.Name = "xrTableCell4"; this.xrTableCell4.Text = "TOTAL"; this.xrTableCell4.Weight = 1.46875D; // // xrTable2 // this.xrTable2.Borders = ((DevExpress.XtraPrinting.BorderSide)((((DevExpress.XtraPrinting.BorderSide.Left | DevExpress.XtraPrinting.BorderSide.Top) | DevExpress.XtraPrinting.BorderSide.Right) | DevExpress.XtraPrinting.BorderSide.Bottom))); this.xrTable2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F); this.xrTable2.Name = "xrTable2"; this.xrTable2.Rows.AddRange(new DevExpress.XtraReports.UI.XRTableRow[] { this.xrTableRow2 }); this.xrTable2.SizeF = new System.Drawing.SizeF(650F, 25F); this.xrTable2.StylePriority.UseBorders = false; // // xrTableRow2 // this.xrTableRow2.Cells.AddRange(new DevExpress.XtraReports.UI.XRTableCell[] { this.xrTableCell5, this.xrTableCell6, this.xrTableCell7, this.xrTableCell8 }); this.xrTableRow2.Name = "xrTableRow2"; this.xrTableRow2.Weight = 1D; // // xrTableCell5 // this.xrTableCell5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.id_venta") }); this.xrTableCell5.Name = "xrTableCell5"; this.xrTableCell5.Weight = 1D; // // xrTableCell6 // this.xrTableCell6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.fecha", "{0:d/MM/yyyy}") }); this.xrTableCell6.Name = "xrTableCell6"; this.xrTableCell6.StylePriority.UseTextAlignment = false; this.xrTableCell6.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell6.Weight = 1D; // // xrTableCell7 // this.xrTableCell7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.documento") }); this.xrTableCell7.Name = "xrTableCell7"; this.xrTableCell7.StylePriority.UseTextAlignment = false; this.xrTableCell7.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell7.Weight = 3.03125D; // // xrTableCell8 // this.xrTableCell8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.total", "{0:Q0.00}") }); this.xrTableCell8.Name = "xrTableCell8"; this.xrTableCell8.StylePriority.UseTextAlignment = false; this.xrTableCell8.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; this.xrTableCell8.Weight = 1.46875D; // // xrLabel5 // this.xrLabel5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.nombre") }); this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(100F, 48.95833F); 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); // // xrLabel6 // this.xrLabel6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.apellido") }); this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(100F, 71.95835F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel6.SizeF = new System.Drawing.SizeF(100F, 23F); // // xrLabel7 // this.xrLabel7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.usuario") }); this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(489.5833F, 48.95833F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel7.SizeF = new System.Drawing.SizeF(160.4167F, 23F); // // xrLabel8 // this.xrLabel8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "tblVenta.nombre_sucursal") }); this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(489.5834F, 71.95835F); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel8.SizeF = new System.Drawing.SizeF(160.4166F, 23F); // // ReportHeader // this.ReportHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel9, this.xrLabel5, this.xrLabel2, this.xrLabel3, this.xrLabel4, this.xrLabel1, this.xrLabel6, this.xrLabel7, this.xrLabel8, this.xrTable1 }); this.ReportHeader.HeightF = 147.9167F; this.ReportHeader.Name = "ReportHeader"; // // xrLabel9 // this.xrLabel9.Font = new System.Drawing.Font("Times New Roman", 9.75F, System.Drawing.FontStyle.Bold); this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(100F, 10.00001F); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 96F); this.xrLabel9.SizeF = new System.Drawing.SizeF(389.5834F, 23F); this.xrLabel9.StylePriority.UseFont = false; this.xrLabel9.StylePriority.UseTextAlignment = false; this.xrLabel9.Text = "REPORTE DE VENTAS POR EMPLEADO"; this.xrLabel9.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopCenter; // // reporteEmpleado // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.ReportHeader }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "tblVenta"; this.DataSource = this.sqlDataSource1; this.Margins = new System.Drawing.Printing.Margins(100, 100, 18, 100); this.Version = "15.2"; ((System.ComponentModel.ISupportInitialize)(this.xrTable1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.xrTable2)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); DevExpress.DataAccess.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.RelationInfo relationInfo1 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.SortingInfo sortingInfo1 = new DevExpress.DataAccess.Sql.SortingInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo1 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo1 = new DevExpress.DataAccess.Sql.ColumnInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo2 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo2 = new DevExpress.DataAccess.Sql.ColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ProductosporCategorias)); this.Detail = new DevExpress.XtraReports.UI.DetailBand(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.TopMargin = new DevExpress.XtraReports.UI.TopMarginBand(); this.BottomMargin = new DevExpress.XtraReports.UI.BottomMarginBand(); this.sqlDataSource1 = new DevExpress.DataAccess.Sql.SqlDataSource(this.components); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.groupHeaderBand3 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrLine1 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine2 = new DevExpress.XtraReports.UI.XRLine(); this.pageFooterBand1 = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.reportHeaderBand1 = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel5 = 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.PageHeader = new DevExpress.XtraReports.UI.PageHeaderBand(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel4, this.xrLabel2 }); this.Detail.HeightF = 57.875F; 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; // // xrLabel4 // this.xrLabel4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "PRODUCTOS.Categoria") }); this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(241.5F, 0F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(140.0834F, 36F); this.xrLabel4.StyleName = "DataField"; this.xrLabel4.Text = "xrLabel4"; // // xrLabel2 // this.xrLabel2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "PRODUCTOS.Nombre_Producto") }); this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(27.70834F, 0F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(175.5833F, 36F); this.xrLabel2.StyleName = "DataField"; this.xrLabel2.Text = "xrLabel2"; // // TopMargin // this.TopMargin.HeightF = 100F; 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 = 100F; 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 = "POSIXConnectionString"; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.Name = "PRODUCTOS"; relationColumnInfo1.NestedKeyColumn = "IdCategoria"; relationColumnInfo1.ParentKeyColumn = "IdCategoria"; relationInfo1.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo1 }); relationInfo1.NestedTable = "CATEGORIAS_PRODUCTOS"; relationInfo1.ParentTable = "PRODUCTOS"; tableQuery1.Relations.AddRange(new DevExpress.DataAccess.Sql.RelationInfo[] { relationInfo1 }); sortingInfo1.Column = "Nombre_Producto"; sortingInfo1.Table = "PRODUCTOS"; tableQuery1.Sorting.AddRange(new DevExpress.DataAccess.Sql.SortingInfo[] { sortingInfo1 }); tableInfo1.Name = "PRODUCTOS"; columnInfo1.Name = "Nombre_Producto"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1 }); tableInfo2.Name = "CATEGORIAS_PRODUCTOS"; columnInfo2.Name = "Categoria"; tableInfo2.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo2 }); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1, tableInfo2 }); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // xrLabel1 // this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(10.00001F, 10.00001F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(175.5833F, 36F); this.xrLabel1.StyleName = "FieldCaption"; this.xrLabel1.Text = "Nombre Producto"; // // xrLabel3 // this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(223.7916F, 10.00001F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(140.0833F, 36F); this.xrLabel3.StyleName = "FieldCaption"; this.xrLabel3.Text = "Categoria"; // // groupHeaderBand3 // this.groupHeaderBand3.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLine1, this.xrLine2 }); this.groupHeaderBand3.HeightF = 23F; this.groupHeaderBand3.Name = "groupHeaderBand3"; this.groupHeaderBand3.StyleName = "FieldCaption"; // // xrLine1 // this.xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 5F); this.xrLine1.Name = "xrLine1"; this.xrLine1.SizeF = new System.Drawing.SizeF(638F, 2F); // // xrLine2 // this.xrLine2.LocationFloat = new DevExpress.Utils.PointFloat(6F, 7F); this.xrLine2.Name = "xrLine2"; this.xrLine2.SizeF = new System.Drawing.SizeF(638F, 2F); // // pageFooterBand1 // this.pageFooterBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo1, this.xrPageInfo2 }); this.pageFooterBand1.HeightF = 29F; this.pageFooterBand1.Name = "pageFooterBand1"; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 6F); 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(313F, 23F); this.xrPageInfo1.StyleName = "PageInfo"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Página {0} de {1}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(331F, 6F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(313F, 23F); this.xrPageInfo2.StyleName = "PageInfo"; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // reportHeaderBand1 // this.reportHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel5 }); this.reportHeaderBand1.HeightF = 57F; this.reportHeaderBand1.Name = "reportHeaderBand1"; // // xrLabel5 // this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(133.0833F, 7.999992F); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel5.SizeF = new System.Drawing.SizeF(347.375F, 39F); this.xrLabel5.StyleName = "Title"; this.xrLabel5.Text = "Productos por Categoria"; // // 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", 24F); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.FieldCaption.BorderWidth = 1F; this.FieldCaption.Font = new System.Drawing.Font("Times New Roman", 10F, System.Drawing.FontStyle.Bold); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.PageInfo.BorderWidth = 1F; this.PageInfo.Font = new System.Drawing.Font("Times New Roman", 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DataField.BorderWidth = 1F; this.DataField.Font = new System.Drawing.Font("Times New Roman", 8F); this.DataField.ForeColor = System.Drawing.Color.Black; this.DataField.Name = "DataField"; this.DataField.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // PageHeader // this.PageHeader.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1, this.xrLabel3 }); this.PageHeader.HeightF = 56.25F; this.PageHeader.Name = "PageHeader"; // // ProductosporCategorias // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.groupHeaderBand3, this.pageFooterBand1, this.reportHeaderBand1, this.PageHeader }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "PRODUCTOS"; this.DataSource = this.sqlDataSource1; this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.FieldCaption, this.PageInfo, this.DataField }); 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.Sql.TableQuery tableQuery1 = new DevExpress.DataAccess.Sql.TableQuery(); DevExpress.DataAccess.Sql.RelationInfo relationInfo1 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo1 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.RelationInfo relationInfo2 = new DevExpress.DataAccess.Sql.RelationInfo(); DevExpress.DataAccess.Sql.RelationColumnInfo relationColumnInfo2 = new DevExpress.DataAccess.Sql.RelationColumnInfo(); DevExpress.DataAccess.Sql.SortingInfo sortingInfo1 = new DevExpress.DataAccess.Sql.SortingInfo(); 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.TableInfo tableInfo2 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.TableInfo tableInfo3 = new DevExpress.DataAccess.Sql.TableInfo(); DevExpress.DataAccess.Sql.ColumnInfo columnInfo4 = new DevExpress.DataAccess.Sql.ColumnInfo(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(ProveedoresporDepartamento)); 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.pageHeaderBand1 = new DevExpress.XtraReports.UI.PageHeaderBand(); this.xrLabel1 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel2 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel3 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel4 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine1 = new DevExpress.XtraReports.UI.XRLine(); this.xrLine2 = new DevExpress.XtraReports.UI.XRLine(); this.groupHeaderBand1 = new DevExpress.XtraReports.UI.GroupHeaderBand(); this.xrLabel5 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel6 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel7 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLabel8 = new DevExpress.XtraReports.UI.XRLabel(); this.pageFooterBand1 = new DevExpress.XtraReports.UI.PageFooterBand(); this.xrPageInfo1 = new DevExpress.XtraReports.UI.XRPageInfo(); this.xrPageInfo2 = new DevExpress.XtraReports.UI.XRPageInfo(); this.reportHeaderBand1 = new DevExpress.XtraReports.UI.ReportHeaderBand(); this.xrLabel9 = new DevExpress.XtraReports.UI.XRLabel(); this.xrLine3 = new DevExpress.XtraReports.UI.XRLine(); 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(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // Detail // this.Detail.HeightF = 23F; 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.HeightF = 100F; 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 = 100F; 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 = "POSIXConnectionString"; this.sqlDataSource1.Name = "sqlDataSource1"; tableQuery1.Name = "PROVEEDORES"; relationColumnInfo1.NestedKeyColumn = "IdMunicipio"; relationColumnInfo1.ParentKeyColumn = "IdMunicipio"; relationInfo1.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo1 }); relationInfo1.NestedTable = "MUNICIPIO"; relationInfo1.ParentTable = "PROVEEDORES"; relationColumnInfo2.NestedKeyColumn = "IdDepto"; relationColumnInfo2.ParentKeyColumn = "IdDepto"; relationInfo2.KeyColumns.AddRange(new DevExpress.DataAccess.Sql.RelationColumnInfo[] { relationColumnInfo2 }); relationInfo2.NestedTable = "DEPARTAMENTO"; relationInfo2.ParentTable = "MUNICIPIO"; tableQuery1.Relations.AddRange(new DevExpress.DataAccess.Sql.RelationInfo[] { relationInfo1, relationInfo2 }); sortingInfo1.Column = "Departamento"; sortingInfo1.Table = "DEPARTAMENTO"; tableQuery1.Sorting.AddRange(new DevExpress.DataAccess.Sql.SortingInfo[] { sortingInfo1 }); tableInfo1.Name = "PROVEEDORES"; columnInfo1.Name = "IdProveedor"; columnInfo2.Name = "Nombre"; columnInfo3.Name = "RTN"; tableInfo1.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo1, columnInfo2, columnInfo3 }); tableInfo2.Name = "MUNICIPIO"; tableInfo3.Name = "DEPARTAMENTO"; columnInfo4.Name = "Departamento"; tableInfo3.SelectedColumns.AddRange(new DevExpress.DataAccess.Sql.ColumnInfo[] { columnInfo4 }); tableQuery1.Tables.AddRange(new DevExpress.DataAccess.Sql.TableInfo[] { tableInfo1, tableInfo2, tableInfo3 }); this.sqlDataSource1.Queries.AddRange(new DevExpress.DataAccess.Sql.SqlQuery[] { tableQuery1 }); this.sqlDataSource1.ResultSchemaSerializable = resources.GetString("sqlDataSource1.ResultSchemaSerializable"); // // pageHeaderBand1 // this.pageHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel1, this.xrLabel2, this.xrLabel3, this.xrLabel4, this.xrLine1, this.xrLine2 }); this.pageHeaderBand1.HeightF = 45F; this.pageHeaderBand1.Name = "pageHeaderBand1"; // // xrLabel1 // this.xrLabel1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 7F); this.xrLabel1.Name = "xrLabel1"; this.xrLabel1.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel1.SizeF = new System.Drawing.SizeF(203.6692F, 36F); this.xrLabel1.StyleName = "FieldCaption"; this.xrLabel1.Text = "Id Proveedor"; // // xrLabel2 // this.xrLabel2.LocationFloat = new DevExpress.Utils.PointFloat(209.6692F, 7F); this.xrLabel2.Name = "xrLabel2"; this.xrLabel2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel2.SizeF = new System.Drawing.SizeF(83.43077F, 36F); this.xrLabel2.StyleName = "FieldCaption"; this.xrLabel2.Text = "RTN"; // // xrLabel3 // this.xrLabel3.LocationFloat = new DevExpress.Utils.PointFloat(293.1F, 7F); this.xrLabel3.Name = "xrLabel3"; this.xrLabel3.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel3.SizeF = new System.Drawing.SizeF(130.0538F, 36F); this.xrLabel3.StyleName = "FieldCaption"; this.xrLabel3.Text = "Nombre"; // // xrLabel4 // this.xrLabel4.LocationFloat = new DevExpress.Utils.PointFloat(423.1539F, 7F); this.xrLabel4.Name = "xrLabel4"; this.xrLabel4.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel4.SizeF = new System.Drawing.SizeF(220.8461F, 36F); this.xrLabel4.StyleName = "FieldCaption"; this.xrLabel4.Text = "Departamento"; // // xrLine1 // this.xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 5F); this.xrLine1.Name = "xrLine1"; this.xrLine1.SizeF = new System.Drawing.SizeF(638F, 2F); // // xrLine2 // this.xrLine2.LocationFloat = new DevExpress.Utils.PointFloat(6F, 43F); this.xrLine2.Name = "xrLine2"; this.xrLine2.SizeF = new System.Drawing.SizeF(638F, 2F); // // groupHeaderBand1 // this.groupHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel5, this.xrLabel6, this.xrLabel7, this.xrLabel8 }); this.groupHeaderBand1.GroupFields.AddRange(new DevExpress.XtraReports.UI.GroupField[] { new DevExpress.XtraReports.UI.GroupField("IdProveedor", DevExpress.XtraReports.UI.XRColumnSortOrder.Ascending) }); this.groupHeaderBand1.HeightF = 23F; this.groupHeaderBand1.Name = "groupHeaderBand1"; this.groupHeaderBand1.StyleName = "DataField"; // // xrLabel5 // this.xrLabel5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "PROVEEDORES.IdProveedor") }); this.xrLabel5.LocationFloat = new DevExpress.Utils.PointFloat(6.00001F, 0F); this.xrLabel5.Name = "xrLabel5"; this.xrLabel5.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel5.SizeF = new System.Drawing.SizeF(68.25258F, 23F); this.xrLabel5.Text = "xrLabel5"; // // xrLabel6 // this.xrLabel6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "PROVEEDORES.RTN") }); this.xrLabel6.LocationFloat = new DevExpress.Utils.PointFloat(74.25257F, 0F); this.xrLabel6.Name = "xrLabel6"; this.xrLabel6.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel6.SizeF = new System.Drawing.SizeF(182.1392F, 23F); this.xrLabel6.Text = "xrLabel6"; // // xrLabel7 // this.xrLabel7.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "PROVEEDORES.Nombre") }); this.xrLabel7.LocationFloat = new DevExpress.Utils.PointFloat(256.3917F, 0F); this.xrLabel7.Name = "xrLabel7"; this.xrLabel7.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel7.SizeF = new System.Drawing.SizeF(172.7622F, 23F); this.xrLabel7.Text = "xrLabel7"; // // xrLabel8 // this.xrLabel8.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] { new DevExpress.XtraReports.UI.XRBinding("Text", null, "PROVEEDORES.Departamento") }); this.xrLabel8.LocationFloat = new DevExpress.Utils.PointFloat(429.1539F, 0F); this.xrLabel8.Name = "xrLabel8"; this.xrLabel8.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel8.SizeF = new System.Drawing.SizeF(220.8461F, 23F); this.xrLabel8.Text = "xrLabel8"; // // pageFooterBand1 // this.pageFooterBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrPageInfo1, this.xrPageInfo2 }); this.pageFooterBand1.HeightF = 29F; this.pageFooterBand1.Name = "pageFooterBand1"; // // xrPageInfo1 // this.xrPageInfo1.LocationFloat = new DevExpress.Utils.PointFloat(6F, 6F); 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(313F, 23F); this.xrPageInfo1.StyleName = "PageInfo"; // // xrPageInfo2 // this.xrPageInfo2.Format = "Página {0} de {1}"; this.xrPageInfo2.LocationFloat = new DevExpress.Utils.PointFloat(331F, 6F); this.xrPageInfo2.Name = "xrPageInfo2"; this.xrPageInfo2.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrPageInfo2.SizeF = new System.Drawing.SizeF(313F, 23F); this.xrPageInfo2.StyleName = "PageInfo"; this.xrPageInfo2.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight; // // reportHeaderBand1 // this.reportHeaderBand1.Controls.AddRange(new DevExpress.XtraReports.UI.XRControl[] { this.xrLabel9, this.xrLine3 }); this.reportHeaderBand1.HeightF = 57F; this.reportHeaderBand1.Name = "reportHeaderBand1"; // // xrLabel9 // this.xrLabel9.LocationFloat = new DevExpress.Utils.PointFloat(120.3334F, 10.00001F); this.xrLabel9.Name = "xrLabel9"; this.xrLabel9.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); this.xrLabel9.SizeF = new System.Drawing.SizeF(440.0706F, 39F); this.xrLabel9.StyleName = "Title"; this.xrLabel9.Text = "Proveedores por Departamento"; // // xrLine3 // this.xrLine3.LocationFloat = new DevExpress.Utils.PointFloat(6F, 0F); this.xrLine3.Name = "xrLine3"; this.xrLine3.SizeF = new System.Drawing.SizeF(638F, 2F); // // 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", 24F); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.FieldCaption.BorderWidth = 1F; this.FieldCaption.Font = new System.Drawing.Font("Times New Roman", 10F, System.Drawing.FontStyle.Bold); 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.PageInfo.BorderWidth = 1F; this.PageInfo.Font = new System.Drawing.Font("Times New Roman", 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.Borders = DevExpress.XtraPrinting.BorderSide.None; this.DataField.BorderWidth = 1F; this.DataField.Font = new System.Drawing.Font("Times New Roman", 8F); this.DataField.ForeColor = System.Drawing.Color.Black; this.DataField.Name = "DataField"; this.DataField.Padding = new DevExpress.XtraPrinting.PaddingInfo(2, 2, 0, 0, 100F); // // ProveedoresporDepartamento // this.Bands.AddRange(new DevExpress.XtraReports.UI.Band[] { this.Detail, this.TopMargin, this.BottomMargin, this.pageHeaderBand1, this.groupHeaderBand1, this.pageFooterBand1, this.reportHeaderBand1 }); this.ComponentStorage.AddRange(new System.ComponentModel.IComponent[] { this.sqlDataSource1 }); this.DataMember = "PROVEEDORES"; this.DataSource = this.sqlDataSource1; this.StyleSheet.AddRange(new DevExpress.XtraReports.UI.XRControlStyle[] { this.Title, this.FieldCaption, this.PageInfo, this.DataField }); this.Version = "15.1"; ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); }