1796 lines
68 KiB
XML
1796 lines
68 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
|
|
<Body>
|
|
<ReportItems>
|
|
<Tablix Name="Tablix1">
|
|
<TablixBody>
|
|
<TablixColumns>
|
|
<TablixColumn>
|
|
<Width>6.46597cm</Width>
|
|
</TablixColumn>
|
|
<TablixColumn>
|
|
<Width>2.07011cm</Width>
|
|
</TablixColumn>
|
|
<TablixColumn>
|
|
<Width>2.07011cm</Width>
|
|
</TablixColumn>
|
|
<TablixColumn>
|
|
<Width>2.07011cm</Width>
|
|
</TablixColumn>
|
|
<TablixColumn>
|
|
<Width>2.07011cm</Width>
|
|
</TablixColumn>
|
|
<TablixColumn>
|
|
<Width>2.07011cm</Width>
|
|
</TablixColumn>
|
|
<TablixColumn>
|
|
<Width>2.07011cm</Width>
|
|
</TablixColumn>
|
|
<TablixColumn>
|
|
<Width>2.07011cm</Width>
|
|
</TablixColumn>
|
|
<TablixColumn>
|
|
<Width>2.07011cm</Width>
|
|
</TablixColumn>
|
|
<TablixColumn>
|
|
<Width>2.07011cm</Width>
|
|
</TablixColumn>
|
|
<TablixColumn>
|
|
<Width>2.07011cm</Width>
|
|
</TablixColumn>
|
|
<TablixColumn>
|
|
<Width>2.07011cm</Width>
|
|
</TablixColumn>
|
|
</TablixColumns>
|
|
<TablixRows>
|
|
<TablixRow>
|
|
<Height>0.46466cm</Height>
|
|
<TablixCells>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="Textbox14">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Parameters!Grupo.Value</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox14</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="Textbox16">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>Saldo $</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox16</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="Textbox12">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Fields!NomC1.Value</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox12</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="Textbox24">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Fields!NomC2.Value</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox24</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="Textbox26">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Fields!NomC3.Value</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox26</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="Textbox28">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Fields!NomC4.Value</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox28</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="Textbox30">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Fields!NomC5.Value</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox30</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="Textbox5">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Fields!NomC6.Value</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox5</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="Textbox15">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Fields!NomC7.Value</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox15</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="Textbox20">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Fields!NomC8.Value</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox20</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="Textbox13">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Fields!NomC9.Value</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox13</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="Textbox22">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>Total</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox22</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
</TablixCells>
|
|
</TablixRow>
|
|
<TablixRow>
|
|
<Height>0.48373cm</Height>
|
|
<TablixCells>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="GPO">
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Fields!GPO.Value</Value>
|
|
<Style>
|
|
<FontSize>8pt</FontSize>
|
|
<FontWeight>=iif(Fields!Orden.Value = "", "Bold","Default")</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Left</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>GPO</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<BackgroundColor>=iif(Fields!Orden.Value = "", "#67809f", "")</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="Saldo">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=IIF(Fields!Saldo.Value = 0, "-", Fields!Saldo.Value)</Value>
|
|
<Style>
|
|
<FontSize>8pt</FontSize>
|
|
<FontWeight>=iif(Fields!Orden.Value = "", "Bold","Default")</FontWeight>
|
|
<Format>#,0.00;(#,0.00)</Format>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Right</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Saldo</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<BackgroundColor>=iif(Fields!Orden.Value = "", "#67809f", "Lightgrey")</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="vencido_1_7">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=IIF(Fields!Columna1.Value = 0, "-", Fields!Columna1.Value)</Value>
|
|
<Style>
|
|
<FontSize>8pt</FontSize>
|
|
<FontWeight>=iif(Fields!Orden.Value = "", "Bold","Default")</FontWeight>
|
|
<Format>#,0.00;-#,0.00;'-'</Format>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Right</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>vencido_1_7</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<BackgroundColor>=iif(Fields!Orden.Value = "", "#67809f", iif(Fields!NomC1.Value="Total","LightGrey" ,"Transparent"))</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="vencido_8_30">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=IIF(Fields!Columna2.Value = 0, "-", Fields!Columna2.Value)</Value>
|
|
<Style>
|
|
<FontSize>8pt</FontSize>
|
|
<FontWeight>=iif(Fields!Orden.Value = "", "Bold","Default")</FontWeight>
|
|
<Format>#,0.00;(#,0.00);'-'</Format>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Right</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>vencido_8_30</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<BackgroundColor>=iif(Fields!Orden.Value = "", "#67809f",iif(Fields!NomC2.Value="Total","LightGrey" ,"Transparent"))</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="vencido_30_mas">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=IIF(Fields!Columna3.Value = 0, "-", Fields!Columna3.Value)</Value>
|
|
<Style>
|
|
<FontSize>8pt</FontSize>
|
|
<FontWeight>=iif(Fields!Orden.Value = "", "Bold","Default")</FontWeight>
|
|
<Format>#,0.00;(#,0.00);'-'</Format>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Right</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>vencido_30_mas</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<BackgroundColor>=iif(Fields!Orden.Value = "", "#67809f", iif(Fields!NomC3.Value="Total","LightGrey" ,"Transparent"))</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="vencido">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=IIF(Fields!Columna4.Value = 0, "-", Fields!Columna4.Value)</Value>
|
|
<Style>
|
|
<FontSize>8pt</FontSize>
|
|
<FontWeight>=iif(Fields!Orden.Value = "", "Bold","Default")</FontWeight>
|
|
<Format>#,0.00;(#,0.00);'-'</Format>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Right</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>vencido</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<BackgroundColor>=iif(Fields!Orden.Value = "", "#67809f", iif(Fields!NomC4.Value="Total","LightGrey" ,"Transparent"))</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="por_vencer_0_7">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=IIF(Fields!Columna5.Value = 0, "-", Fields!Columna5.Value)</Value>
|
|
<Style>
|
|
<FontSize>8pt</FontSize>
|
|
<FontWeight>=iif(Fields!Orden.Value = "", "Bold","Default")</FontWeight>
|
|
<Format>#,0.00;(#,0.00);'-'</Format>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Right</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>por_vencer_0_7</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<BackgroundColor>=iif(Fields!Orden.Value = "", "#67809f", iif(Fields!NomC5.Value="Total","LightGrey" ,"Transparent"))</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="por_vencer_8_14">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=IIF(Fields!Columna6.Value = 0, "-", Fields!Columna6.Value)</Value>
|
|
<Style>
|
|
<FontSize>8pt</FontSize>
|
|
<FontWeight>=iif(Fields!Orden.Value = "", "Bold","Default")</FontWeight>
|
|
<Format>#,0.00;-#,0.00;'-'</Format>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Right</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>por_vencer_8_14</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<BackgroundColor>=iif(Fields!Orden.Value = "", "#67809f", iif(Fields!NomC6.Value="Total","LightGrey" ,"Transparent"))</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="por_vencer_15_30">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=IIF(Fields!Columna7.Value = 0, "-", Fields!Columna7.Value)</Value>
|
|
<Style>
|
|
<FontSize>8pt</FontSize>
|
|
<FontWeight>=iif(Fields!Orden.Value = "", "Bold","Default")</FontWeight>
|
|
<Format>#,0.00;(#,0.00);'-'</Format>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Right</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>por_vencer_15_30</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<BackgroundColor>=iif(Fields!Orden.Value = "", "#67809f", iif(Fields!NomC7.Value="Total","LightGrey" ,"Transparent"))</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="por_vencido_30_mas">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=IIF(Fields!Columna8.Value = 0, "-", Fields!Columna8.Value)</Value>
|
|
<Style>
|
|
<FontSize>8pt</FontSize>
|
|
<FontWeight>=iif(Fields!Orden.Value = "", "Bold","Default")</FontWeight>
|
|
<Format>#,0.00;-#,0.00;'-'</Format>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Right</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>por_vencido_30_mas</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<BackgroundColor>=iif(Fields!Orden.Value = "", "#67809f", iif(Fields!NomC8.Value="Total","LightGrey" ,"Transparent"))</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="Textbox17">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=IIF(Fields!Columna9.Value = 0, "-", Fields!Columna9.Value)</Value>
|
|
<Style>
|
|
<FontSize>8pt</FontSize>
|
|
<FontWeight>=iif(Fields!Orden.Value = "", "Bold","Default")</FontWeight>
|
|
<Format>0.00</Format>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Right</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox17</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<BackgroundColor>=iif(Fields!Orden.Value = "", "#67809f", iif(Fields!NomC9.Value="Total","LightGrey" ,"Transparent"))</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
<TablixCell>
|
|
<CellContents>
|
|
<Textbox Name="por_vencer">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Fields!por_vencer.Value</Value>
|
|
<Style>
|
|
<FontSize>8pt</FontSize>
|
|
<FontWeight>=iif(Fields!Orden.Value = "", "Bold","Default")</FontWeight>
|
|
<Format>#,0.00;-#,0.00;'-'</Format>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Right</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>por_vencer</rd:DefaultName>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<BackgroundColor>=iif(Fields!Orden.Value = "", "#67809f", "Lightgrey")</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
</CellContents>
|
|
</TablixCell>
|
|
</TablixCells>
|
|
</TablixRow>
|
|
</TablixRows>
|
|
</TablixBody>
|
|
<TablixColumnHierarchy>
|
|
<TablixMembers>
|
|
<TablixMember />
|
|
<TablixMember />
|
|
<TablixMember />
|
|
<TablixMember />
|
|
<TablixMember />
|
|
<TablixMember>
|
|
<Visibility>
|
|
<Hidden>=IIF(Fields!TC4.Value = "1" or Fields!TC4.Value = "2" ,false,true)</Hidden>
|
|
</Visibility>
|
|
</TablixMember>
|
|
<TablixMember>
|
|
<Visibility>
|
|
<Hidden>=IIF(Fields!TC5.Value = "1" or Fields!TC5.Value = "2" ,false,true)</Hidden>
|
|
</Visibility>
|
|
</TablixMember>
|
|
<TablixMember>
|
|
<Visibility>
|
|
<Hidden>=IIF(Fields!TC6.Value = "1" or Fields!TC6.Value = "2" ,false,true)</Hidden>
|
|
</Visibility>
|
|
</TablixMember>
|
|
<TablixMember>
|
|
<Visibility>
|
|
<Hidden>=IIF(Fields!TC7.Value = "1" or Fields!TC7.Value = "2" ,false,true)</Hidden>
|
|
</Visibility>
|
|
</TablixMember>
|
|
<TablixMember>
|
|
<Visibility>
|
|
<Hidden>=IIF(Fields!TC8.Value = "1" or Fields!TC8.Value = "2" ,false,true)</Hidden>
|
|
</Visibility>
|
|
</TablixMember>
|
|
<TablixMember>
|
|
<Visibility>
|
|
<Hidden>=IIF(Fields!TC9.Value = "1" or Fields!TC9.Value = "2" ,false,true)</Hidden>
|
|
</Visibility>
|
|
</TablixMember>
|
|
<TablixMember />
|
|
</TablixMembers>
|
|
</TablixColumnHierarchy>
|
|
<TablixRowHierarchy>
|
|
<TablixMembers>
|
|
<TablixMember>
|
|
<KeepWithGroup>After</KeepWithGroup>
|
|
</TablixMember>
|
|
<TablixMember>
|
|
<Group Name="Details" />
|
|
</TablixMember>
|
|
</TablixMembers>
|
|
</TablixRowHierarchy>
|
|
<DataSetName>DataSet1</DataSetName>
|
|
<Top>1.58722cm</Top>
|
|
<Left>0.1905cm</Left>
|
|
<Height>0.94839cm</Height>
|
|
<Width>29.23718cm</Width>
|
|
<Style>
|
|
<Border>
|
|
<Color>DimGray</Color>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<TopBorder>
|
|
<Color>CornflowerBlue</Color>
|
|
</TopBorder>
|
|
<BottomBorder>
|
|
<Color>CornflowerBlue</Color>
|
|
</BottomBorder>
|
|
<LeftBorder>
|
|
<Color>CornflowerBlue</Color>
|
|
</LeftBorder>
|
|
<RightBorder>
|
|
<Color>CornflowerBlue</Color>
|
|
</RightBorder>
|
|
</Style>
|
|
</Tablix>
|
|
<Line Name="Line1">
|
|
<Top>0.77583cm</Top>
|
|
<Left>0.1905cm</Left>
|
|
<Height>0cm</Height>
|
|
<Width>29.17523cm</Width>
|
|
<ZIndex>1</ZIndex>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
</Style>
|
|
</Line>
|
|
<Textbox Name="Textbox3">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>Vencido Por Vencer</Value>
|
|
<Style>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox3</rd:DefaultName>
|
|
<Top>0.98722cm</Top>
|
|
<Left>8.72658cm</Left>
|
|
<Height>0.6cm</Height>
|
|
<Width>20.7011cm</Width>
|
|
<ZIndex>2</ZIndex>
|
|
<Visibility>
|
|
<Hidden>=iif(CInt(Parameters!CantColumnas.Value)=9,false,true)</Hidden>
|
|
</Visibility>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
<Textbox Name="Textbox6">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Parameters!AgrupadoPor.Value</Value>
|
|
<MarkupType>HTML</MarkupType>
|
|
<Style>
|
|
<FontWeight>Normal</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Left</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox2</rd:DefaultName>
|
|
<Height>0.59944cm</Height>
|
|
<Width>29.37102cm</Width>
|
|
<ZIndex>3</ZIndex>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
<Textbox Name="Textbox18">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>Vencido Por Vencer</Value>
|
|
<Style>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox3</rd:DefaultName>
|
|
<Top>0.98722cm</Top>
|
|
<Left>8.72658cm</Left>
|
|
<Height>0.6cm</Height>
|
|
<Width>16.56088cm</Width>
|
|
<ZIndex>4</ZIndex>
|
|
<Visibility>
|
|
<Hidden>=iif(CInt(Parameters!CantColumnas.Value) = 7, False, True)</Hidden>
|
|
</Visibility>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
<Textbox Name="Textbox4">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>Vencido Por Vencer</Value>
|
|
<Style>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox3</rd:DefaultName>
|
|
<Top>0.98722cm</Top>
|
|
<Left>8.72658cm</Left>
|
|
<Height>0.6cm</Height>
|
|
<Width>18.63099cm</Width>
|
|
<ZIndex>5</ZIndex>
|
|
<Visibility>
|
|
<Hidden>=iif(CInt(Parameters!CantColumnas.Value)=8,false,true)</Hidden>
|
|
</Visibility>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
<Textbox Name="Textbox19">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>Vencido Por Vencer</Value>
|
|
<Style>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox3</rd:DefaultName>
|
|
<Top>0.98722cm</Top>
|
|
<Left>8.72658cm</Left>
|
|
<Height>0.6cm</Height>
|
|
<Width>14.49077cm</Width>
|
|
<ZIndex>6</ZIndex>
|
|
<Visibility>
|
|
<Hidden>=iif(CInt(Parameters!CantColumnas.Value) = 6, False, True)</Hidden>
|
|
</Visibility>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
<Textbox Name="Textbox21">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>Vencido Por Vencer</Value>
|
|
<Style>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox3</rd:DefaultName>
|
|
<Top>0.98722cm</Top>
|
|
<Left>8.72658cm</Left>
|
|
<Height>0.6cm</Height>
|
|
<Width>12.42066cm</Width>
|
|
<ZIndex>7</ZIndex>
|
|
<Visibility>
|
|
<Hidden>=iif(CInt(Parameters!CantColumnas.Value) = 5, False, True)</Hidden>
|
|
</Visibility>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
<Textbox Name="Textbox23">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>Vencido Por Vencer</Value>
|
|
<Style>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox3</rd:DefaultName>
|
|
<Top>0.98722cm</Top>
|
|
<Left>8.72658cm</Left>
|
|
<Height>0.6cm</Height>
|
|
<Width>10.35055cm</Width>
|
|
<ZIndex>8</ZIndex>
|
|
<Visibility>
|
|
<Hidden>=iif(CInt(Parameters!CantColumnas.Value) = 4, False, True)</Hidden>
|
|
</Visibility>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
<BackgroundColor>LightGrey</BackgroundColor>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
</ReportItems>
|
|
<Height>1.31609in</Height>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
</Style>
|
|
</Body>
|
|
<Width>11.61695in</Width>
|
|
<Page>
|
|
<PageHeader>
|
|
<Height>2.74374cm</Height>
|
|
<PrintOnFirstPage>true</PrintOnFirstPage>
|
|
<PrintOnLastPage>true</PrintOnLastPage>
|
|
<ReportItems>
|
|
<Image Name="Logo">
|
|
<Source>External</Source>
|
|
<Value>=Parameters!LogoPath.Value</Value>
|
|
<Sizing>FitProportional</Sizing>
|
|
<Top>0.27375cm</Top>
|
|
<Left>0.22225cm</Left>
|
|
<Height>2.22362cm</Height>
|
|
<Width>2.33715cm</Width>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
</Style>
|
|
</Image>
|
|
<Textbox Name="Textbox1">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Parameters!NombreEmpresa.Value</Value>
|
|
<Style>
|
|
<FontSize>12pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox1</rd:DefaultName>
|
|
<Top>0.27375cm</Top>
|
|
<Left>2.85388cm</Left>
|
|
<Height>0.6cm</Height>
|
|
<Width>22.98347cm</Width>
|
|
<ZIndex>1</ZIndex>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
<Textbox Name="Textbox2">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>CUENTAS POR PAGAR</Value>
|
|
<Style>
|
|
<FontSize>10.5pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value />
|
|
<Style>
|
|
<FontSize>10.5pt</FontSize>
|
|
<FontWeight>Bold</FontWeight>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Center</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox2</rd:DefaultName>
|
|
<Top>1.19125cm</Top>
|
|
<Left>9.19375cm</Left>
|
|
<Height>0.52945cm</Height>
|
|
<Width>9.98771cm</Width>
|
|
<ZIndex>2</ZIndex>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
</ReportItems>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
</Style>
|
|
</PageHeader>
|
|
<PageFooter>
|
|
<Height>1.87853cm</Height>
|
|
<PrintOnFirstPage>true</PrintOnFirstPage>
|
|
<PrintOnLastPage>true</PrintOnLastPage>
|
|
<ReportItems>
|
|
<Textbox Name="Textbox7">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>="Página " & Globals.PageNumber & " de " & Globals.TotalPages</Value>
|
|
<Style>
|
|
<FontStyle>Italic</FontStyle>
|
|
<FontSize>8pt</FontSize>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style>
|
|
<TextAlign>Right</TextAlign>
|
|
</Style>
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox3</rd:DefaultName>
|
|
<Top>0.87489cm</Top>
|
|
<Left>27.20409cm</Left>
|
|
<Height>0.36335cm</Height>
|
|
<Width>2.06587cm</Width>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
<Textbox Name="Textbox8">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>Usuario:</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style />
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox8</rd:DefaultName>
|
|
<Top>0.87489cm</Top>
|
|
<Left>0.127cm</Left>
|
|
<Height>0.36335cm</Height>
|
|
<Width>1.60042cm</Width>
|
|
<ZIndex>1</ZIndex>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
<Textbox Name="Textbox9">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Parameters!UsuarioImprimio.Value</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style />
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox9</rd:DefaultName>
|
|
<Top>0.87489cm</Top>
|
|
<Left>1.67133cm</Left>
|
|
<Height>0.36335cm</Height>
|
|
<Width>5.14936cm</Width>
|
|
<ZIndex>2</ZIndex>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
<Textbox Name="Textbox10">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>Fecha Impresión:</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style />
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox10</rd:DefaultName>
|
|
<Top>0.87489cm</Top>
|
|
<Left>12.01358cm</Left>
|
|
<Height>0.36335cm</Height>
|
|
<Width>2.92333cm</Width>
|
|
<ZIndex>3</ZIndex>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
<Textbox Name="Textbox11">
|
|
<CanGrow>true</CanGrow>
|
|
<KeepTogether>true</KeepTogether>
|
|
<Paragraphs>
|
|
<Paragraph>
|
|
<TextRuns>
|
|
<TextRun>
|
|
<Value>=Parameters!FechaImpresion.Value</Value>
|
|
<Style>
|
|
<FontSize>9pt</FontSize>
|
|
</Style>
|
|
</TextRun>
|
|
</TextRuns>
|
|
<Style />
|
|
</Paragraph>
|
|
</Paragraphs>
|
|
<rd:DefaultName>Textbox11</rd:DefaultName>
|
|
<Top>0.87489cm</Top>
|
|
<Left>14.9228cm</Left>
|
|
<Height>0.36335cm</Height>
|
|
<Width>4.32745cm</Width>
|
|
<ZIndex>4</ZIndex>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
<PaddingLeft>2pt</PaddingLeft>
|
|
<PaddingRight>2pt</PaddingRight>
|
|
<PaddingTop>2pt</PaddingTop>
|
|
<PaddingBottom>2pt</PaddingBottom>
|
|
</Style>
|
|
</Textbox>
|
|
<Line Name="Line2">
|
|
<Top>0.74083cm</Top>
|
|
<Left>0.127cm</Left>
|
|
<Height>0cm</Height>
|
|
<Width>29.23873cm</Width>
|
|
<ZIndex>5</ZIndex>
|
|
<Style>
|
|
<Border>
|
|
<Style>Solid</Style>
|
|
</Border>
|
|
</Style>
|
|
</Line>
|
|
</ReportItems>
|
|
<Style>
|
|
<Border>
|
|
<Style>None</Style>
|
|
</Border>
|
|
</Style>
|
|
</PageFooter>
|
|
<PageHeight>21cm</PageHeight>
|
|
<PageWidth>29.7cm</PageWidth>
|
|
<LeftMargin>0cm</LeftMargin>
|
|
<RightMargin>0cm</RightMargin>
|
|
<TopMargin>0.5cm</TopMargin>
|
|
<BottomMargin>0.5cm</BottomMargin>
|
|
<ColumnSpacing>0.13cm</ColumnSpacing>
|
|
<Style />
|
|
</Page>
|
|
<AutoRefresh>0</AutoRefresh>
|
|
<DataSources>
|
|
<DataSource Name="DataSet3">
|
|
<ConnectionProperties>
|
|
<DataProvider>System.Data.DataSet</DataProvider>
|
|
<ConnectString>/* Local Connection */</ConnectString>
|
|
</ConnectionProperties>
|
|
<rd:DataSourceID>74f8a171-24f1-4404-809e-ec2e098f1907</rd:DataSourceID>
|
|
</DataSource>
|
|
</DataSources>
|
|
<DataSets>
|
|
<DataSet Name="DataSet1">
|
|
<Query>
|
|
<DataSourceName>DataSet3</DataSourceName>
|
|
<CommandText>/* Local Query */</CommandText>
|
|
</Query>
|
|
<Fields>
|
|
<Field Name="GPO">
|
|
<DataField>GPO</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="Saldo">
|
|
<DataField>Saldo</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="vencido">
|
|
<DataField>vencido</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="por_vencer">
|
|
<DataField>por_vencer</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="Orden">
|
|
<DataField>Orden</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="Columna1">
|
|
<DataField>Columna1</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="Columna2">
|
|
<DataField>Columna2</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="Columna3">
|
|
<DataField>Columna3</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="Columna4">
|
|
<DataField>Columna4</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="Columna5">
|
|
<DataField>Columna5</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="Columna6">
|
|
<DataField>Columna6</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="Columna7">
|
|
<DataField>Columna7</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="Columna8">
|
|
<DataField>Columna8</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="Columna9">
|
|
<DataField>Columna9</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="NomC1">
|
|
<DataField>NomC1</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="NomC2">
|
|
<DataField>NomC2</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="NomC3">
|
|
<DataField>NomC3</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="NomC4">
|
|
<DataField>NomC4</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="NomC5">
|
|
<DataField>NomC5</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="NomC6">
|
|
<DataField>NomC6</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="NomC7">
|
|
<DataField>NomC7</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="NomC8">
|
|
<DataField>NomC8</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="NomC9">
|
|
<DataField>NomC9</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="TC1">
|
|
<DataField>TC1</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="TC2">
|
|
<DataField>TC2</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="TC3">
|
|
<DataField>TC3</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="TC4">
|
|
<DataField>TC4</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="TC5">
|
|
<DataField>TC5</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="TC6">
|
|
<DataField>TC6</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="TC7">
|
|
<DataField>TC7</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="TC8">
|
|
<DataField>TC8</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
<Field Name="TC9">
|
|
<DataField>TC9</DataField>
|
|
<rd:TypeName>System.String</rd:TypeName>
|
|
</Field>
|
|
</Fields>
|
|
<rd:DataSetInfo>
|
|
<rd:DataSetName>DataSet3</rd:DataSetName>
|
|
<rd:SchemaPath>C:\Users\jesus\Documents\Visual Studio 2015\WebSites\WebSite2\App_Code\DataSet3.xsd</rd:SchemaPath>
|
|
<rd:TableName>DataTable1</rd:TableName>
|
|
<rd:TableAdapterFillMethod />
|
|
<rd:TableAdapterGetDataMethod />
|
|
<rd:TableAdapterName />
|
|
</rd:DataSetInfo>
|
|
</DataSet>
|
|
</DataSets>
|
|
<ReportParameters>
|
|
<ReportParameter Name="LogoPath">
|
|
<DataType>String</DataType>
|
|
<Nullable>true</Nullable>
|
|
<AllowBlank>true</AllowBlank>
|
|
<Prompt>ReportParameter1</Prompt>
|
|
</ReportParameter>
|
|
<ReportParameter Name="NombreEmpresa">
|
|
<DataType>String</DataType>
|
|
<Nullable>true</Nullable>
|
|
<AllowBlank>true</AllowBlank>
|
|
<Prompt>ReportParameter1</Prompt>
|
|
</ReportParameter>
|
|
<ReportParameter Name="RFC">
|
|
<DataType>String</DataType>
|
|
<Nullable>true</Nullable>
|
|
<AllowBlank>true</AllowBlank>
|
|
<Prompt>ReportParameter1</Prompt>
|
|
</ReportParameter>
|
|
<ReportParameter Name="DireccionEmpresa">
|
|
<DataType>String</DataType>
|
|
<Nullable>true</Nullable>
|
|
<AllowBlank>true</AllowBlank>
|
|
<Prompt>ReportParameter1</Prompt>
|
|
</ReportParameter>
|
|
<ReportParameter Name="TipoCuentas">
|
|
<DataType>String</DataType>
|
|
<Nullable>true</Nullable>
|
|
<AllowBlank>true</AllowBlank>
|
|
<Prompt>ReportParameter1</Prompt>
|
|
</ReportParameter>
|
|
<ReportParameter Name="FechaInicio">
|
|
<DataType>String</DataType>
|
|
<Nullable>true</Nullable>
|
|
<AllowBlank>true</AllowBlank>
|
|
<Prompt>ReportParameter1</Prompt>
|
|
</ReportParameter>
|
|
<ReportParameter Name="FechaFin">
|
|
<DataType>String</DataType>
|
|
<Nullable>true</Nullable>
|
|
<AllowBlank>true</AllowBlank>
|
|
<Prompt>ReportParameter1</Prompt>
|
|
</ReportParameter>
|
|
<ReportParameter Name="NombreCliente">
|
|
<DataType>String</DataType>
|
|
<Nullable>true</Nullable>
|
|
<AllowBlank>true</AllowBlank>
|
|
<Prompt>ReportParameter1</Prompt>
|
|
</ReportParameter>
|
|
<ReportParameter Name="UsuarioImprimio">
|
|
<DataType>String</DataType>
|
|
<Nullable>true</Nullable>
|
|
<AllowBlank>true</AllowBlank>
|
|
<Prompt>ReportParameter1</Prompt>
|
|
</ReportParameter>
|
|
<ReportParameter Name="FechaImpresion">
|
|
<DataType>String</DataType>
|
|
<Nullable>true</Nullable>
|
|
<AllowBlank>true</AllowBlank>
|
|
<Prompt>ReportParameter1</Prompt>
|
|
</ReportParameter>
|
|
<ReportParameter Name="Grupo">
|
|
<DataType>String</DataType>
|
|
<Nullable>true</Nullable>
|
|
<AllowBlank>true</AllowBlank>
|
|
<Prompt>ReportParameter1</Prompt>
|
|
</ReportParameter>
|
|
<ReportParameter Name="AgrupadoPor">
|
|
<DataType>String</DataType>
|
|
<Nullable>true</Nullable>
|
|
<AllowBlank>true</AllowBlank>
|
|
<Prompt>ReportParameter1</Prompt>
|
|
</ReportParameter>
|
|
<ReportParameter Name="CantColumnas">
|
|
<DataType>String</DataType>
|
|
<Nullable>true</Nullable>
|
|
<AllowBlank>true</AllowBlank>
|
|
<Prompt>ReportParameter1</Prompt>
|
|
</ReportParameter>
|
|
</ReportParameters>
|
|
<rd:ReportUnitType>Cm</rd:ReportUnitType>
|
|
<rd:ReportID>2ec96151-d7c1-4609-bfdd-795b02d33b5a</rd:ReportID>
|
|
</Report> |