<AutoRefresh>0</AutoRefresh> <DataSources> <ConnectionProperties> <DataProvider>System.Data.DataSet</DataProvider> <ConnectString>/* Local Connection */</ConnectString> </ConnectionProperties> b56aea9d-dbaf-4eb8-82d4-8ce62dedfd7a </DataSources> <DataSets> <Query> <DataSourceName>DSNovedadesCanillas</DataSourceName> <CommandText>/* Local Query */</CommandText> </Query> <Fields> <DataField>Canilla</DataField> System.String <DataField>Legajo</DataField> System.Int32 <DataField>Francos</DataField> System.Int32 <DataField>Faltas</DataField> System.Int32 <DataField>TotalRendir</DataField> System.Decimal </Fields> DSNovedadesCanillas C:\Users\dmolinari\source\repos\Cobol-VBNet\Reportes\DSNovedadesCanillas.xsd SP_DistCanillasGanancias Fill GetData SP_DistCanillasGananciasTableAdapter <Query> <DataSourceName>DSNovedadesCanillas</DataSourceName> <CommandText>/* Local Query */</CommandText> </Query> <Fields> <DataField>NomApe</DataField> System.String <DataField>Fecha</DataField> System.DateTime <DataField>Detalle</DataField> System.String </Fields> DSNovedadesCanillas C:\Users\dmolinari\source\repos\Cobol-VBNet\Reportes\DSNovedadesCanillas.xsd SP_DistCanillasNovedades Fill GetData SP_DistCanillasNovedadesTableAdapter </DataSets> <ReportSections> <ReportSection>
<ReportItems> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Fecha Consultada: Desde</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>0.14111cm</Top> <Left>0.619cm</Left> <Height>0.64974cm</Height> <Width>4.5cm</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>=CDate(Parameters!FechaDesde.Value).ToString("dd/MM/yyyy")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox49 <Top>0.17639cm</Top> <Left>5.03692cm</Left> <Height>0.6cm</Height> <Width>2.52646cm</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>Hasta</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>0.14111cm</Top> <Left>7.28116cm</Left> <Height>0.64974cm</Height> <Width>1.13709cm</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(Parameters!FechaHasta.Value).ToString("dd/MM/yyyy")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox49 <Top>0.14111cm</Top> <Left>8.41824cm</Left> <Height>0.6cm</Height> <Width>2.52646cm</Width> <ZIndex>3</ZIndex>
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> <TablixBody> <TablixColumns> <TablixColumn> <Width>6.64813cm</Width> </TablixColumn> <TablixColumn> <Width>3.35187cm</Width> </TablixColumn> <TablixColumn> <Width>2.5cm</Width> </TablixColumn> <TablixColumn> <Width>2.5cm</Width> </TablixColumn> <TablixColumn> <Width>4cm</Width> </TablixColumn> </TablixColumns> <TablixRows> <TablixRow> <Height>0.6cm</Height> <TablixCells> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Canilla</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox10
</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>Legajo</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox12
</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>Faltas</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox17
</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>Francos</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox14
</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>Comisiones</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox16
</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!Canilla.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Canilla
</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!Legajo.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Legajo
</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!Faltas.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Faltas1
</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!Francos.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Francos
</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>=IIF(IsNothing(Fields!TotalRendir.Value), 0, Fields!TotalRendir.Value)</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> TotalRendir
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> es-AR </CellContents> </TablixCell> </TablixCells> </TablixRow> <TablixRow> <Height>0.6cm</Height> <TablixCells> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value />
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox1
</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 />
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox2
</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 />
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox21
</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>Total</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox3
</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!TotalRendir.Value, "DSNovedadesCanillas")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox4
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> es-AR </CellContents> </TablixCell> </TablixCells> </TablixRow> </TablixRows> </TablixBody> <TablixColumnHierarchy> <TablixMembers> <TablixMember /> <TablixMember /> <TablixMember /> <TablixMember /> <TablixMember /> </TablixMembers> </TablixColumnHierarchy> <TablixRowHierarchy> <TablixMembers> <TablixMember> <KeepWithGroup>After</KeepWithGroup> </TablixMember> <TablixMember> <SortExpressions> <SortExpression> <Value>=Fields!Canilla.Value</Value> </SortExpression> </SortExpressions> <TablixMembers> <TablixMember /> </TablixMembers> </TablixMember> <TablixMember> <KeepWithGroup>Before</KeepWithGroup> </TablixMember> </TablixMembers> </TablixRowHierarchy> <DataSetName>DSNovedadesCanillas</DataSetName> <Top>1.61282cm</Top> <Left>0.619cm</Left> <Height>1.8cm</Height> <Width>19cm</Width> <ZIndex>4</ZIndex>
</Border> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Parameters!NomEmp.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox18 <Top>0.924cm</Top> <Left>0.619cm</Left> <Height>0.6cm</Height> <Width>19cm</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>Otras novedades</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>3.57185cm</Top> <Left>0.619cm</Left> <Height>0.54391cm</Height> <Width>4.5cm</Width> <ZIndex>6</ZIndex>
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> <TablixBody> <TablixColumns> <TablixColumn> <Width>2.45172cm</Width> </TablixColumn> <TablixColumn> <Width>9.90015cm</Width> </TablixColumn> </TablixColumns> <TablixRows> <TablixRow> <Height>0.6cm</Height> <TablixCells> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Fecha</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox15
</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>Detalle</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox20
</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!Fecha.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Fecha
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> true </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!Detalle.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Detalle
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> </TablixCells> </TablixRow> </TablixRows> </TablixBody> <TablixColumnHierarchy> <TablixMembers> <TablixMember /> <TablixMember /> </TablixMembers> </TablixColumnHierarchy> <TablixRowHierarchy> <TablixMembers> <TablixMember> <TablixHeader> <Size>6.64813cm</Size> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Nom Ape</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox24
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixHeader> <TablixMembers> <TablixMember /> </TablixMembers> <KeepWithGroup>After</KeepWithGroup> </TablixMember> <TablixMember> <GroupExpressions> <GroupExpression>=Fields!NomApe.Value</GroupExpression> </GroupExpressions> <SortExpressions> <SortExpression> <Value>=Fields!NomApe.Value</Value> </SortExpression> </SortExpressions> <TablixHeader> <Size>6.64813cm</Size> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!NomApe.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> NomApe1
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <GroupExpressions> <GroupExpression>=Fields!Fecha.Value</GroupExpression> </GroupExpressions> <SortExpressions> <SortExpression> <Value>=Fields!NomApe.Value</Value> </SortExpression> <SortExpression> <Value>=Fields!Fecha.Value</Value> </SortExpression> </SortExpressions> </TablixMember> </TablixMembers> </TablixMember> </TablixMembers> </TablixRowHierarchy> <DataSetName>DSNovedadesCanillasDetalles</DataSetName> <Top>4.22159cm</Top> <Left>0.619cm</Left> <Height>1.2cm</Height> <Width>19cm</Width> <ZIndex>7</ZIndex>
</Border> </ReportItems> <Height>2.19455in</Height>
<Width>20.00233cm</Width> <Page> <PageHeader> <Height>2.47537cm</Height> <PrintOnFirstPage>true</PrintOnFirstPage> <PrintOnLastPage>true</PrintOnLastPage> <ReportItems> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Listado de Novedades</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>0.28575cm</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>Canillas</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>1.01911cm</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 de Generación del Reporte</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>1.73229cm</Top> <Left>0.619cm</Left> <Height>0.64974cm</Height> <Width>5.9525cm</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.73229cm</Top> <Left>6.63676cm</Left> <Height>0.6cm</Height> <Width>3.50542cm</Width> <ZIndex>3</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>DateTime</DataType> <Prompt>ReportParameter1</Prompt> <DataType>DateTime</DataType> <Prompt>ReportParameter1</Prompt> </ReportParameters> <ReportParametersLayout> <GridLayoutDefinition> <NumberOfColumns>4</NumberOfColumns> <NumberOfRows>2</NumberOfRows> <CellDefinitions> <CellDefinition> <ColumnIndex>0</ColumnIndex> <RowIndex>0</RowIndex> <ParameterName>NomEmp</ParameterName> </CellDefinition> <CellDefinition> <ColumnIndex>1</ColumnIndex> <RowIndex>0</RowIndex> <ParameterName>FechaDesde</ParameterName> </CellDefinition> <CellDefinition> <ColumnIndex>2</ColumnIndex> <RowIndex>0</RowIndex> <ParameterName>FechaHasta</ParameterName> </CellDefinition> </CellDefinitions> </GridLayoutDefinition> </ReportParametersLayout> Cm 9b172a94-4bac-4027-a97f-837f768deec6