<AutoRefresh>0</AutoRefresh> <DataSources> <ConnectionProperties> <DataProvider>System.Data.DataSet</DataProvider> <ConnectString>/* Local Connection */</ConnectString> </ConnectionProperties> c3588116-f33e-486f-8e77-9edbd5a767af </DataSources> <DataSets> <Query> <DataSourceName>DSConsumoBobinas</DataSourceName> <CommandText>/* Local Query */</CommandText> </Query> <Fields> <DataField>TipoBobina</DataField> System.String <DataField>BobinasUtilizadasMesA</DataField> System.Int32 <DataField>BobinasUtilizadasMesB</DataField> System.Int32 <DataField>DiferenciaBobinasUtilizadas</DataField> System.Int32 <DataField>KilosUtilizadosMesA</DataField> System.Int32 <DataField>KilosUtilizadosMesB</DataField> System.Int32 <DataField>DiferenciaKilosUtilizados</DataField> System.Int32 </Fields> DSConsumoBobinas C:\Users\dmolinari\source\repos\Cobol-VBNet\Reportes\DSConsumoBobinas.xsd SP_CompararConsumoBobinasMeses Fill GetData SP_CompararConsumoBobinasMesesTableAdapter </DataSets> <ReportSections> <ReportSection>
<ReportItems> <TablixBody> <TablixColumns> <TablixColumn> <Width>5.8cm</Width> </TablixColumn> <TablixColumn> <Width>2.3cm</Width> </TablixColumn> <TablixColumn> <Width>2.3cm</Width> </TablixColumn> <TablixColumn> <Width>2cm</Width> </TablixColumn> <TablixColumn> <Width>2.3cm</Width> </TablixColumn> <TablixColumn> <Width>2.3cm</Width> </TablixColumn> <TablixColumn> <Width>2cm</Width> </TablixColumn> </TablixColumns> <TablixRows> <TablixRow> <Height>0.6cm</Height> <TablixCells> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Tipo Bobina</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox9
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Cant. Mes A</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox23
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Cant. Mes B</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox13
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Diferencia</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox15
</Border> <RightBorder> <Color>Black</Color> <Width>1.5pt</Width> </RightBorder> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Kg Mes A</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox17
</Border> <LeftBorder> <Color>Black</Color> <Width>1.5pt</Width> </LeftBorder> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Kg Mes B</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox19
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Diferencia </Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox21
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> </TablixCells> </TablixRow> <TablixRow> <Height>0.6cm</Height> <TablixCells> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!TipoBobina.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> TipoBobina
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!BobinasUtilizadasMesA.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> BobinasUtilizadasMesA
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!BobinasUtilizadasMesB.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> BobinasUtilizadasMesB
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!DiferenciaBobinasUtilizadas.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> DiferenciaBobinasUtilizadas
</Border> <RightBorder> <Color>Black</Color> <Width>1.5pt</Width> </RightBorder> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!KilosUtilizadosMesA.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> KilosUtilizadosMesA
</Border> <LeftBorder> <Color>Black</Color> <Width>1.5pt</Width> </LeftBorder> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!KilosUtilizadosMesB.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> KilosUtilizadosMesB
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!DiferenciaKilosUtilizados.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> DiferenciaKilosUtilizados
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> </TablixCells> </TablixRow> <TablixRow> <Height>0.6cm</Height> <TablixCells> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Totales</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox25
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Sum(Fields!BobinasUtilizadasMesA.Value, "DSConsumoBobinasMeses")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox26
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Sum(Fields!BobinasUtilizadasMesB.Value, "DSConsumoBobinasMeses")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox27
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Sum(Fields!DiferenciaBobinasUtilizadas.Value, "DSConsumoBobinasMeses")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox28
</Border> <RightBorder> <Color>Black</Color> <Width>1.5pt</Width> </RightBorder> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Sum(Fields!KilosUtilizadosMesA.Value, "DSConsumoBobinasMeses")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox29
</Border> <LeftBorder> <Color>Black</Color> <Width>1.5pt</Width> </LeftBorder> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Sum(Fields!KilosUtilizadosMesB.Value, "DSConsumoBobinasMeses")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox30
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Sum(Fields!DiferenciaKilosUtilizados.Value, "DSConsumoBobinasMeses")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox31
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> </TablixCells> </TablixRow> </TablixRows> </TablixBody> <TablixColumnHierarchy> <TablixMembers> <TablixMember /> <TablixMember /> <TablixMember /> <TablixMember /> <TablixMember /> <TablixMember /> <TablixMember /> </TablixMembers> </TablixColumnHierarchy> <TablixRowHierarchy> <TablixMembers> <TablixMember> <KeepWithGroup>After</KeepWithGroup> </TablixMember> <TablixMember> </TablixMember> <TablixMember> <KeepWithGroup>Before</KeepWithGroup> </TablixMember> </TablixMembers> </TablixRowHierarchy> <DataSetName>DSConsumoBobinasMeses</DataSetName> <Top>0.14111cm</Top> <Left>0.619cm</Left> <Height>1.8cm</Height> <Width>19cm</Width>
</Border> </ReportItems> <Height>0.84039in</Height>
<Width>21cm</Width> <Page> <PageHeader> <Height>2.55474cm</Height> <PrintOnFirstPage>true</PrintOnFirstPage> <PrintOnLastPage>true</PrintOnLastPage> <ReportItems> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Reporte de Consumo de Bobinas - Comparativa Mensual</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>0.28998cm</Top> <Left>0.619cm</Left> <Height>0.72912cm</Height> <Width>19cm</Width>
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>="Planta: " & Parameters!NomPlanta.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>1.08874cm</Top> <Left>0.619cm</Left> <Height>0.64975cm</Height> <Width>19cm</Width> <ZIndex>1</ZIndex>
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Fecha del Reporte</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>1.80192cm</Top> <Left>0.619cm</Left> <Height>0.64974cm</Height> <Width>3.43896cm</Width> <ZIndex>2</ZIndex>
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=CDate(Globals!ExecutionTime).ToString("dd/MM/yyyy")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox49 <Top>1.80192cm</Top> <Left>4.00151cm</Left> <Height>0.6cm</Height> <Width>2.26011cm</Width> <ZIndex>3</ZIndex>
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Meses Consultados:</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>1.83727cm</Top> <Left>6.33218cm</Left> <Height>0.64974cm</Height> <Width>3.65333cm</Width> <ZIndex>4</ZIndex>
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Parameters!MesA.Value & "(Mes A)"</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox49 <Top>1.8408cm</Top> <Left>9.89285cm</Left> <Height>0.6cm</Height> <Width>4.3cm</Width> <ZIndex>5</ZIndex>
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Contra</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>1.83727cm</Top> <Left>14.0562cm</Left> <Height>0.64974cm</Height> <Width>1.29584cm</Width> <ZIndex>6</ZIndex>
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Parameters!MesB.Value & "(Mes B)"</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox49 <Top>1.8408cm</Top> <Left>15.30618cm</Left> <Height>0.6cm</Height> <Width>4.31282cm</Width> <ZIndex>7</ZIndex>
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </ReportItems>
</Border> </PageHeader> <PageHeight>29.7cm</PageHeight> <PageWidth>21cm</PageWidth> <LeftMargin>0cm</LeftMargin> <RightMargin>0cm</RightMargin> <TopMargin>0.5cm</TopMargin> <BottomMargin>0.5cm</BottomMargin> <ColumnSpacing>0.13cm</ColumnSpacing>
</Page> </ReportSection> </ReportSections> <ReportParameters> <DataType>String</DataType> <Prompt>ReportParameter1</Prompt> <DataType>String</DataType> <Prompt>ReportParameter1</Prompt> <DataType>String</DataType> <Prompt>ReportParameter1</Prompt> </ReportParameters> <ReportParametersLayout> <GridLayoutDefinition> <NumberOfColumns>4</NumberOfColumns> <NumberOfRows>2</NumberOfRows> <CellDefinitions> <CellDefinition> <ColumnIndex>0</ColumnIndex> <RowIndex>0</RowIndex> <ParameterName>NomPlanta</ParameterName> </CellDefinition> <CellDefinition> <ColumnIndex>1</ColumnIndex> <RowIndex>0</RowIndex> <ParameterName>MesA</ParameterName> </CellDefinition> <CellDefinition> <ColumnIndex>2</ColumnIndex> <RowIndex>0</RowIndex> <ParameterName>MesB</ParameterName> </CellDefinition> </CellDefinitions> </GridLayoutDefinition> </ReportParametersLayout> Cm 047bc866-20bc-4afb-999d-93d11dad8fb9