<AutoRefresh>0</AutoRefresh> <DataSources> <ConnectionProperties> <DataProvider>System.Data.DataSet</DataProvider> <ConnectString>/* Local Connection */</ConnectString> </ConnectionProperties> 9df3f92d-80cd-4b70-97b3-2059ca1f8fab </DataSources> <DataSets> <Query> <DataSourceName>DSListadoDistribucionCan</DataSourceName> <CommandText>/* Local Query */</CommandText> </Query> <Fields> <DataField>Publicacion</DataField> System.String <DataField>Canilla</DataField> System.String <DataField>TotalCantSalida</DataField> System.Int32 <DataField>TotalCantEntrada</DataField> System.Int32 <DataField>TotalRendir</DataField> System.Decimal </Fields> DSListadoDistribucionCan C:\Users\dmolinari\source\repos\Cobol-VBNet\Reportes\DSListadoDistribucionCan.xsd SP_DistCanillasAccConImporteEntreFechas Fill GetData SP_DistCanillasAccConImporteEntreFechasTableAdapter </DataSets> <ReportSections> <ReportSection>
<ReportItems> <TablixBody> <TablixColumns> <TablixColumn> <Width>4.5cm</Width> </TablixColumn> <TablixColumn> <Width>3cm</Width> </TablixColumn> <TablixColumn> <Width>3cm</Width> </TablixColumn> <TablixColumn> <Width>3.5cm</Width> </TablixColumn> </TablixColumns> <TablixRows> <TablixRow> <Height>0.6cm</Height> <TablixCells> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Publicación</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox9
</Border> <BottomBorder> <Color>Black</Color> </BottomBorder> <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>Llevados</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox11
</Border> <BottomBorder> <Color>Black</Color> </BottomBorder> <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>Devueltos</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox13
</Border> <BottomBorder> <Color>Black</Color> </BottomBorder> <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>Importe</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox29
</Border> <BottomBorder> <Color>Black</Color> </BottomBorder> <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!Publicacion.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Publicacion
</Border> <TopBorder> <Color>Black</Color> </TopBorder> <BottomBorder> <Color>Black</Color> </BottomBorder> <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!TotalCantSalida.Value)</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> TotalCantSalida
</Border> <TopBorder> <Color>Black</Color> </TopBorder> <BottomBorder> <Color>Black</Color> </BottomBorder> <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!TotalCantEntrada.Value)</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> TotalCantEntrada
</Border> <TopBorder> <Color>Black</Color> </TopBorder> <BottomBorder> <Color>Black</Color> </BottomBorder> <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)</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> TotalRendir
</Border> <TopBorder> <Color>Black</Color> </TopBorder> <BottomBorder> <Color>Black</Color> </BottomBorder> <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> Textbox47
</Border> <TopBorder> <Color>Black</Color> </TopBorder> <BottomBorder> <Color>Black</Color> <Width>1.5pt</Width> </BottomBorder> <LeftBorder>
</LeftBorder> <RightBorder>
</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 />
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox48
</Border> <TopBorder> <Color>Black</Color> </TopBorder> <BottomBorder> <Color>Black</Color> <Width>1.5pt</Width> </BottomBorder> <LeftBorder>
</LeftBorder> <RightBorder>
</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!TotalRendir.Value)</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox75
</Border> <TopBorder> <Color>Black</Color> </TopBorder> <BottomBorder> <Color>Black</Color> <Width>1.5pt</Width> </BottomBorder> <LeftBorder>
</LeftBorder> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> <ColSpan>2</ColSpan> </CellContents> </TablixCell> <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> Textbox71
</Border> <TopBorder> <Color>Black</Color> </TopBorder> <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!TotalCantSalida.Value, "DSListadoDistribucionCanMensual")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox72
</Border> <TopBorder> <Color>Black</Color> </TopBorder> <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!TotalCantEntrada.Value, "DSListadoDistribucionCanMensual")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox73
</Border> <TopBorder> <Color>Black</Color> </TopBorder> <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, "DSListadoDistribucionCanMensual")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox74
</Border> <TopBorder> <Color>Black</Color> </TopBorder> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> </TablixCells> </TablixRow> </TablixRows> </TablixBody> <TablixColumnHierarchy> <TablixMembers> <TablixMember /> <TablixMember /> <TablixMember /> <TablixMember /> </TablixMembers> </TablixColumnHierarchy> <TablixRowHierarchy> <TablixMembers> <TablixMember> <TablixHeader> <Size>5cm</Size> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Canilla</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox27
</Border> <BottomBorder> <Color>Black</Color> </BottomBorder> <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!Canilla.Value</GroupExpression> </GroupExpressions> <SortExpressions> <SortExpression> <Value>=Fields!Canilla.Value</Value> </SortExpression> </SortExpressions> <TablixHeader> <Size>5cm</Size> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!Canilla.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Canilla
</Border> <TopBorder> <Color>Black</Color> </TopBorder> <BottomBorder> <Color>Black</Color> <Width>1.5pt</Width> </BottomBorder> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixHeader> <TablixMembers> <TablixMember> <GroupExpressions> <GroupExpression>=Fields!Publicacion.Value</GroupExpression> </GroupExpressions> <TablixMembers> <TablixMember /> </TablixMembers> </TablixMember> <TablixMember> <KeepWithGroup>Before</KeepWithGroup> </TablixMember> </TablixMembers> </TablixMember> <TablixMember> <TablixHeader> <Size>5cm</Size> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value />
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox70
</Border> <TopBorder> <Color>Black</Color> </TopBorder> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixHeader> <KeepWithGroup>Before</KeepWithGroup> </TablixMember> </TablixMembers> </TablixRowHierarchy> <DataSetName>DSListadoDistribucionCanMensual</DataSetName> <Top>0.14111cm</Top> <Left>0.63223cm</Left> <Height>2.4cm</Height> <Width>19cm</Width>
</Border> </ReportItems> <Height>1.04591in</Height>
<Width>20.70896cm</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 Distribución Mensual</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>0.26606cm</Top> <Left>0.63223cm</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>=IIF(Parameters!CanAcc.Value = 1,"Accionistas","Canillitas")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>0.94163cm</Top> <Left>0.63223cm</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 Reporte</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>1.68656cm</Top> <Left>0.63223cm</Left> <Height>0.64974cm</Height> <Width>3.28021cm</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.68656cm</Top> <Left>3.98299cm</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> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>Fecha Consultada: Desde</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>1.68656cm</Top> <Left>7.55897cm</Left> <Height>0.64974cm</Height> <Width>4.5cm</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>=CDate(Parameters!FechaDesde.Value).ToString("dd/MM/yyyy")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox49 <Top>1.72184cm</Top> <Left>11.97689cm</Left> <Height>0.6cm</Height> <Width>2.52646cm</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>Hasta</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox41 <Top>1.68656cm</Top> <Left>14.22113cm</Left> <Height>0.64974cm</Height> <Width>1.13709cm</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>=CDate(Parameters!FechaHasta.Value).ToString("dd/MM/yyyy")</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox49 <Top>1.68656cm</Top> <Left>15.35821cm</Left> <Height>0.6cm</Height> <Width>2.52646cm</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>Integer</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>CanAcc</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 b51d6f83-c910-43b6-94e3-9a378214032b